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
0
votes
1 answer

Return Codes from PeopleCode Exec Function

I am attempting to kick off a third party program using EXEC command in PeopleSoft. It is returning error code 127. When I kick the program off from Unix command line, I get no error. Does anybody know what code 127 is? Or have a list of all the…
John
  • 11
  • 2
0
votes
1 answer

Unable to print special (Non-English) characters (Latin, German, etc.,) in XML using XSL

I have an XML that contains some special (Non-English) characters like š,ý, etc.. How can I handle the special characters in XSL? When I used encoding as UTF-8 in my program, the XML file got generated but I was unable to open the XML file as it has…
Sai
  • 1
  • 1
0
votes
1 answer

Find SendMail Peoplecode

We have custom functionality in PeopleSoft FSCM that generates an email notification with a link to direct users to approve vouchers online. I have found part of the text string variable that compose the email message within the following Record…
Nick
  • 268
  • 8
  • 33
0
votes
1 answer

Reusing SQL statement in PeopleCode for prompt table

I have a page in PeopleSoft that has a number of similar fields. Each one uses a prompt table that is set to a dynamic view. When one field is changed, it populates the SQLText property of two other fields, incorporating the value that was just…
SarekOfVulcan
  • 1,348
  • 4
  • 16
  • 35
0
votes
1 answer

PeopleCode reflection for variables

Does PeopleCode have something similar to reflection in C# whereby I can access a variable with the variable name stored in a string? I am aware of the @ operator but I think it only applies to fields and records (correct me if I am wrong. I tried…
Talib
  • 335
  • 3
  • 15
0
votes
1 answer

Perform logic if last row of SQL Fetch/Loop doesn't find match

I have the below Application Engine program that I am modifying. I am basically adding in code for cases when the Unit of Measure (&UOMResult) of an item is entered in a CSV/File Layout does not match the value of the existing row(s) retrieved for…
JBinson88
  • 113
  • 1
  • 14
0
votes
0 answers

Application Engine Program - NULL Insert Error occuring

I have the below Application Engine program that I am modifying slightly and I am now getting a NULL Insert error (Cannot insert the value NULL into column 'EFFDT', table 'XXX.dbo.PS_ITM_VNDR_UOM_PR'. Within the While block there is a SQLExec…
JBinson88
  • 113
  • 1
  • 14
0
votes
1 answer

Peoplecode SQL update setting values on extra variables

I modified the below Application Engine program, I added an additional field (&ItmField) to the CSV file layout that the program reads. It is correctly updating (SQL UPDATE) the field ITEM_FIELD_C10_B however I noticed in the Trace file that the SQL…
JBinson88
  • 113
  • 1
  • 14
0
votes
2 answers

Application Engine Peoplecode bind variables

I have the below PeopleCode step in an Application Engine program that reads a CSV file using a File Layout and then inserts the data into a table, and I am just trying to get a better understanding of how the the line of code (&SQL1 =…
JBinson88
  • 113
  • 1
  • 14
0
votes
2 answers

How to evaluate date only in Datetime field in App Engine PeopleCode

just wanted to preface by saying that I am new to PeopleSoft AppEngine and PeopleCode development. I have the following step in a PeopleSoft App Engine program (OnExecute step) that retrieves records in a table and then takes those existing values…
Nick
  • 268
  • 8
  • 33
0
votes
2 answers

Understanding How to Implement a Few Oracle Peoplesoft PSSpreadsheet Functions

I know this is going to be very specific, and I'll be lucky if anyone who has experience on this topic sees this, but I've run out of patience trying to search for answers so I thought I might see if anyone in the community knows. I'm trying to…
mattmorin
  • 1
  • 2
0
votes
1 answer

AddDropDownItem PeopleCode

I got this PeopleCode somewhere that says it can dynamically add items in the drop down list: Component number &rownum; Local SQL &SQL; Local Rowset &rset0, &rset1; Local String &type, &descr; &rset0 = GetLevel0(); &rset1 =…
Tom Micua
  • 5
  • 1
  • 4
0
votes
1 answer

Display status of a running process in PeopleSoft

So I have a button in a page wherein when it is pressed, it kicks off a process, specifically an application engine. As we all know, when an app engine runs, it is being shown in the process monitor page. What I want to do is on that same page that…
Tom Micua
  • 5
  • 1
  • 4
0
votes
2 answers

Error in Peoplcode ScrollSelect processing

When I'm trying to open the page I get the error that "Return: 8011 - SQL statment is too long". We have about millions of rows. On the page we are filling the scroll and the where statement is created something like this For &i = 1 To…
user7194270
  • 117
  • 2
  • 16
0
votes
2 answers

PeopleSoft Query Manager Table Name

I cannot for the life of me figure out the table name that would enable me to see the approval queue. There is time pending approval in the approval process "TLReportedTime" and I'm looking for a table to build a report so that I can see who the…
Phlegon_of_Tralles
  • 181
  • 1
  • 14
1 2 3 4
5
6