Stack Overflow
Stack Overflow

Questions tagged [peoplesoft-app-engine]

PeopleCode is an object-oriented proprietary language used by Oracle's PeopleSoft applications.

PeopleCode syntax closely resembles other object-oriented programming languages, such as Java.

See the PeopleCode Developer's Guide for more: http://docs.oracle.com/cd/E66686_01/pt855pbr1/eng/pt/tpcd/concept_PeopleCodeOverview-074b56.html

50 questions
3
votes
1 answer

Peoplesoft CreateRowset with related display record

According to the Peoplebook here, CreateRowset function has the parameters {FIELD.fieldname, RECORD.recname} which is used to specify the related display record. I had tried to use it like the following (just for example): &rs1 =…
Coleman
  • 33
  • 3
2
votes
1 answer

How does PeopleSoft App Engine program flow occur

I am learning more about PeopleSoft Application Engine program flow. From what I've read in PeopleBooks, any actions within a step that specify a Do Select , Do When or Do While perform a looping activity, where all subsequent Actions (within that…
Nick
  • 268
  • 8
  • 33
2
votes
1 answer

Function of Rows, Rowsets in PeopleCode

I'm trying to get a better understanding of what Rows and Rowsets are used for in PeopleCode? I've read through PeopleBooks and still don't feel like I have a good understanding. I'm looking to get more understanding of these as it pertains to…
Nick
  • 268
  • 8
  • 33
2
votes
2 answers

PeopleSoft Effective-Dated CI: No rows exist for the specified keys (Java)

I've seen this issue several times in other posts but haven't been able to solve it yet. Maybe you guys can shed some light here. I'm trying to perform an Update for Component Interface "LOCATION" using the Java Object Adapter library (psjoa.jar)…
CountD
  • 669
  • 2
  • 11
  • 34
2
votes
0 answers

Copying a rowset from table to a rowset message

I am having an issue copying a rowset (that is populated from a table) to a rowset type message. This is what I have (took out a lot of tries that failed many times) Local Message &MSG; Local Rowset &HDR_RS, &LN_RS; &MSG =…
Shawn
  • 2,355
  • 14
  • 48
  • 98
1
vote
1 answer

Using YEAR from Prompt entry in Date Selection Criteria

I'm trying to figure out how to use a YEAR entered via a prompt in a date selection criteria... so the user enters 2018 for the Balance_Year... and I want to look for the TAXFORM_DED record with an EFFDT between 01/01/YEAR and 31/12/YEAR. Where YEAR…
Heather Graham
  • 11
  • 1
1
vote
1 answer

PeopleSoft Query Manager - isolating a row

Okay so I'm struggling here. We have a table that keeps track of a certain user ID. One row has the ID, a second row has the inactive ID. It looks kind of like…
Phlegon_of_Tralles
  • 181
  • 1
  • 14
1
vote
1 answer

PeopleCode to load from CSV file and split 1 field into multiple columns

I am not familiar with Application Engine or PeopleCode but inherited this project when someone left. Seems simple but I'm not sure how to approach it. I have to load a CSV file that has 5 fields. The last field has multiple values separated by a…
Eric
  • 11
  • 1
1
vote
1 answer

Generate HTML formatted emails with Peoplesoft data elements

I am trying to generate an App Engine program that will generate emails to employees with an upcoming employment anniversary (i.e. 5 years, 10 years, etc..) and display a sort of Countdown timer in the body of the email that has the Days remaining…
Nick
  • 268
  • 8
  • 33
1
vote
2 answers

CreateRecord Update Method does not update table

I have modified the below App Engine program to update a field on an existing row, using a File Layout. I have added code to update existing rows for items that have a new Vendor Item ID populated. While the program doesn’t error while running, it…
Nick
  • 268
  • 8
  • 33
1
vote
1 answer

Is there a way to use the WITH Clause in Peoplesoft Query Manager?

I use the WITH clause in Oracle SQL lots of times and knowing that more than 90% of the time, it performs faster, but since I am working on the Peoplesoft application, so I just wonder is there a way to use the WITH Clause in Peoplesoft Query…
general46
  • 800
  • 6
  • 16
1
vote
2 answers

How to store multiple SQLExec values in variable(s)

I am wondering whether in an Application Engine PeopleCode I can run a SQLExec command and if multiple rows are returned how they are stored in the variable? For example - I am working on adding the following code: SQLExec("SELECT C.UNIT_OF_MEASURE…
JBinson88
  • 113
  • 1
  • 14
1
vote
1 answer

Peoplesoft Component Interface

Im working on Component Interface in Psoft using AE and Pcode. Upon create() method for keys an error shows ERROR : Invalid value for key with Prompt table in Search Edit. (91,78) Does anyone have a big knowledge in peoplesoft specially in…
Tomer Medina
  • 11
  • 3
1
vote
1 answer

Good example using XML Publisher with a rowset

Does anyone know of a good example of an Application Engine program creating a rowset and then calling XML Publisher to create a report? PeopleTools 8.49 Thanks in advance.
WayneH
  • 340
  • 5
  • 12
1
vote
1 answer

ExcelToCI error upload to PS_TRAINING record

This week I started working on what I thought was a fairly straight forward data load using the ExcelToCI tool. I am no expert with this tool, but I have also used it enough to have some familiarity with ExcelToCI. The problem that I am having is…
Tommy
  • 65
  • 11
1
2 3 4