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

How can I create SQL output to a CSV file in Application Engine?

I am new to Peopletools and Peoplecode. I have a SQL statement i want to gather the output (all data from the SQL) and create a CSV file. Can you provide a sample CSV file code? DO i need to create the file layout for the App engine process?enter…
Steve
  • 1
  • 1
0
votes
1 answer

How can I convert SQL output to a CSV file?

I want to create a SQL output to CSV-type file. I am using Peoplesoft's IDE, PeopleTools Application Designer. I have an Application Engine process that can loop and do set-based processing. Is there a PeopleCode sample I can use?
Steve
  • 1
  • 1
0
votes
1 answer

For-Loop PeopleCode Array

Is it possible to loop for two array statements? I am trying to put it on display just to see if I will be getting the correct values, but it turned out it that my code is only working for single statement: Here's the code (not working): &DelFrom =…
capacitive
  • 17
  • 6
0
votes
2 answers

Excel report creation on page through peoplecode

I am trying to create report in excel format through peoplecode. Requirement: There is page is having grid containing multiple columns. When manager logins, he can see his direct reporters information on this grid.. There is button provided again to…
angel
  • 47
  • 8
0
votes
1 answer

Peoplesoft peoplecode application engine logic - multiple row insertion with one string

I need to store a value in database in column. The value I m getting is combination of four string. I need to break the value and insert it in every row through peoplecode in app engine. E. G. My value is A1. 9876.B2 5432. The value is separated by…
angel
  • 47
  • 8
0
votes
1 answer

How to read two elements from (XML) in App Engine Peoplecode

Can't read two elements? I can read one element but I don't know how to read two. &FieldL= &inXMLDoc.DocumentElement.GetElementsByTagName("ws:Name_Data"); For &a = 1 To &FieldL.Len &pNode = &FieldL[&a]; &Name_Type =…
Viktor
  • 11
  • 8
0
votes
1 answer

Trigger Peoplecode from a grid when a row is selected

To make a row selected in a grid we can use this Peoplecode : &rsGriD.getRow(&i).selected =True; But how we can trigger peoplecode if a row in a grid is selected ? There is any field in a grid that represent the CheckBock Select, it is added just…
kh.tab
  • 1,284
  • 3
  • 13
  • 25
0
votes
1 answer

SQL for case with Employee ID with two work locations

I need help with a view. I have this one employee showing up twice right now because he has two work locations listed. How can I put something into the view so it selects one location instead of both? Example of data EMPLID Location 120032 …
0
votes
1 answer

PeopleCode function context

I have the following functions that I am trying to modify to default in a Printer output destination within Pay Cycle Manager in FSCM 9.2, but need to get a better understanding of what the current customization is doing. We have a custom function…
Nick
  • 268
  • 8
  • 33
0
votes
1 answer

Knowing how many records inside a query in a project

So I have this homework wherein if a PeopleSoft project has a query in it, I try to see how many records are inside this query for performance reason. I tried going through meta table but I can't seem to find any record that stores this information,…
Link
  • 171
  • 2
  • 19
0
votes
1 answer

How to know the value of record and field in an app package when running app engine?

So I have this Application Engine that calls on this Application Package, this application package has a CreateSql(Select...) statement, and some of the records and fields are dynamic. My question is -- how can i possibly know what value does these…
Link
  • 171
  • 2
  • 19
0
votes
1 answer

Get Requsition ID based on PO

In FSCM I am looking to modify the Search view on Add/Update PO page (Main Menu--> Purchasing--> Purchase Orders--> Add/Update POs) to display the Requisition ID associated with the PO in the search results page. The only table I have found that has…
Nick
  • 268
  • 8
  • 33
0
votes
1 answer

How to peoplecode with radio button

Anyone of you who knows how to peoplecode with the value choosen with radio button? I have this page with radio button of academic programs and when a user select from one of the programs, I want to print a report basing on that program chosen in…
Link
  • 171
  • 2
  • 19
0
votes
1 answer

How to address "Fetching Array Element 2: Index is not in range 1 to 1"?

I'm setting up a program wherein it will read a csv file from a directory and it will be loaded into a peoplesoft table. Local SQL &SQL; Local File &FileSetid; Local array of string &Columns_array; Local string &RowSetid; &FileSetid =…
Tom Micua
  • 5
  • 1
  • 4
0
votes
1 answer

Error when using a winmessage for a variable outside the method

So I have this code in my Class inside an Application Package. If i put the winmessage inside the method it has no problem, but when its outside it says it needs a statement. Any one knows why this is happening? Here is my code: The part the error…
Link
  • 171
  • 2
  • 19