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
1
vote
3 answers

calling shell command from peoplecode

I am getting error when calling OS command for Peoplecode using EXEC function. The call is like this CommitWork(); &ShellCommand = "/path/mytest.sh param1 param2"; &ReturnCode = Exec(&ShellCommand, %Exec_Synchronous +…
user7926822
  • 21
  • 1
  • 5
0
votes
1 answer

Loading a large CSV File into Oracle Table using peoplecode

I am using file layout method and using Peoplesoft suggested code. It works fine with a small csv file but I need to import a file that is 921,000kb. It took a day and is still running. I cannot use an external tool because this is supposed to be a…
SForum
  • 3
  • 3
0
votes
1 answer

How do I organize SendMail() Output in peoplecode?

I'm currently generating emails to notify my team when there is an error in our process monitoring. All of my code works but, when I go to send 1 of the 3 emails, the layout is all over the place. I've tried code like.. If Len(&strPrcsTyp) < 21…
Ashley
  • 11
  • 2
0
votes
0 answers

How to send a PDF attachment using Peoplesoft AWE while sending Email notification

How to send a PDF attachment using Peoplesoft AWE while sending Email notification. Im trying to use the AWE features to send Email Notification once the request is approved. Along with the Email notification i should also send a generated PDF which…
0
votes
0 answers

Error log for null values in application Engine PeopleSoft

I have the requirement that the BUSINESS_UNIT field needs to be updated in the Voucher tables(VCHR_LINE_STG), I'm writing SQL in SQL action in the application engine After the update statement, the results are returning the null values. The total…
0
votes
1 answer

Peoplecode Help Needed

I'm trying to write my first peoplecode step in an Application Engine and am lost. I have 2 tables. Table A is populated with results from several selects and updates in the engine. Table B has 1 row of data that I'm using to store results from a…
Ashley
  • 11
  • 2
0
votes
0 answers

How to setup up Creating Notifications, and Alerts for Contracts in FSCM?

Does anyone know or has setup Notification and Alerts for Contracts in FSCM? Accounding to PeopleBooks (https://docs.oracle.com/cd/F60972_01/fscm92pbr45/eng/fscm/fspr/CreatingSpendThresholds_Notifications_AndAlertsForContracts.html) it is setup…
0
votes
0 answers

How to generate PSSPREADSHEET from a record data(SQL Table)

as I am new to peoplesoft I am trying to write peoplecode in application engine to generate PSSpreadsheet from a record which is SQL Table but I am unable to get. It will be very helpful If anyone can help? I am expecting code if possible.
Ananya
  • 1
0
votes
2 answers

Having multiple validation errors in single error message in Peoplesoft

Is it possible to get multiple error messages for missing required fields in a single error message to the user? For example, if I left all 5 of my required fields blank, the error message that is displayed when clicking Submit will show all 5…
Ananya
  • 1
0
votes
1 answer

CI_JOB_DATA future dated rows

I have written an app engine calling CI CI_JOB_DATA. Everything works fine with the exception when there an employee has a future dated row in their JOB data. Specifically, a termination row. So, we are loading salary increases for all employees as…
JOMAR
  • 1
0
votes
3 answers

Component interface failure due to incorrect data

I have created a PeopleTools Application Engine program to insert/update employee National ID data in the PS_PERS_NID table. I am using a PeopleTools File Layout definition to insert data into a staging table and then using an Application Engine Do…
angel
  • 47
  • 8
0
votes
1 answer

In Peoplesoft, How grid levels work in application designer?

Now I'm just having some training on PeopleSoft while working on application designer I could not understand grids and scroll levels, how it works on data fetch and result populating dynamically from multiple tables connected through parent-child…
0
votes
1 answer

Removing img tags from a bunch of tags, in a record field value, peoplecode.

I have a field value in peoplesoft which contains a long description. The description has lot of HTML tags. from those I only want to remove the img tags (//). How can I do it through peoplecode? And where to write the peoplecode. Thanks in advance
0
votes
1 answer

How to add JVM options to PeopleCode calls?

We have a Java class that is called from PeopleCode using the CreateJavaObject() call. I support the Java code and a recent upgrade in one of the dependencies has broken the call. We think it may be a classloader issue. To troubleshoot, we want…
0
votes
2 answers

This is a Peoplesoft peoplcode question for substring

I have an output for an SQLEXEC "C:\Users\Desktop\XYZ\MMMM.CSV" I need to store this output to a variable in peoplcode which should say &i="C:\Users\Desktop\XYZ". How can I do the substring to remove the file name from the output and get only the…