Stack Overflow
Stack Overflow

Questions tagged [peoplecode]

PeopleCode is the proprietary language used by PeopleSoft applications.

PeopleCode is the PeopleSoft proprietary integrated object-oriented programming language used to express business logic for virtually every aspect of PeopleSoft applications.

PeopleCode and its run-time environment are part of the larger PeopleTools framework.

PeopleCode Documentation:

83 questions
3
votes
1 answer

How to get column names for SQL object in PeopleCode?

I have an iscript that runs one of a collection of previously created SQL statements, binds several parameters, and generates an XML result. The SQL used in each request varies in the number of parameters and the number of (and name of) columns…
jstur
  • 659
  • 6
  • 12
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
1 answer

PeopleCode :1 variables

I am trying to get an understanding of how the : variables are defined and used. I've seen them used primarily in SQL (SQLExec) commands and I have tried looking to see where they are defined. An example is the following, to which I see :1 is being…
Nick
  • 268
  • 8
  • 33
2
votes
1 answer

How to suppress prompt table validation

Is there a way to suppress field prompt table validation for a particular value using peoplecode. For example: On the page, for field A I enter value as "NEXT" (this value doesnot exist in the prompt table attached). When I save the page, if the…
user7194270
  • 117
  • 2
  • 16
2
votes
1 answer

Peoplesoft : Invalid transaction handle instance passed when saving record by CI in AE program

We are using an Application Engine (AE) program to save/insert Record GP_ABS_EVENT via delivered Component Interface (CI) GP_ABSENCE_EVENT. The AE program fails randomly. However, it will run to success if we re-run the AE program again with…
Cube
  • 95
  • 2
  • 11
2
votes
1 answer

Peoplecode TRANSFER to page without search record

Is there a way to use the PeopleCode "transfer" function to transfer (and fill in fields) to a page where the component uses INSTALLATION as the search record? We are using FSCM 9.1 on PT 8.53. The page I'm trying to transfer to is…
Tom
  • 247
  • 1
  • 17
2
votes
1 answer

PeopleSoftModifying field labels while keeping the column label

I have a grid where one column is a column of hyperlinks. How can I set the field labels to display the field's value, while keeping the column's label fixed?
Andrew Zahn
  • 21
  • 6
1
vote
1 answer

Updating fields from changes in scroll levels

I have a page that has 3 levels. Levels 0 & 1 are from the same record. Level 2 is from a second record. When a change is made to level 1, I would like to apply that change to the same field in Level 2's record. Basically, this deals with…
Ashley
  • 11
  • 2
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
2 answers

People soft component ci - delete row from base table

There is a need to update/insert and delete data from existing table based in data coming in the file through component interface. Although I have written below code but not getting confidence, if there is any other way to perform the same , please…
angel
  • 47
  • 8
1
vote
1 answer

Use Peoplecode to delete files from remote FTP site

I am trying to use a PeopleCode app engine to delete files from a remote server. GetAttachment would work except that I want to loop through a the whole directory on the server and match files like march.csv. Also, I am needing to do this by date…
John
  • 11
  • 2
1
vote
1 answer

PeopleSoft Query Manager - 'count' function

I'm using the current version of PeopleSoft and I'm using their Query manager. I've built a query that looks at the job table and a customized version of the job table (so I can see future hires). In order to do this I've created a union. Everything…
Phlegon_of_Tralles
  • 181
  • 1
  • 14
1
vote
1 answer

Peoplesoft : Unix command returning error code 1 from EXEC() but working from putty

I am trying to run below command from EXEC() peoplecode but getting return code 1. &cmd = tail -n +2 /dirname/filename.csv | split -d --lines 20 - --filter='bash -c "{ head -n1 /dirname/filename.csv; cat; } > $FILE"' --additional-suffix=.txt…
deansamy
  • 11
  • 1
1
2 3 4 5 6