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

How to write a Max effe date < 2 years in Application Design PeopleSoft

I need to pull the students data who is inactive for more than 2 continuous years.
surya
  • 5
  • 6
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

PeopleSoft Testing - Catch CreateProcessRequest error

I'm currently conducting component testing rn and one of the test conditions is to catch the error of CreateProcessRequest. I have this code: /define run control parameters – see code below/ Local ProcessRequest &RQST; &RUN_PO_BU =…
jackono
  • 3
  • 2
0
votes
1 answer

Create REST Service for Grades in Peoplesoft

I have a grade service (CI_ENRL_GRADES). I need to make a REST Service of that existing service. How can I do it? please assist me with appropriate steps or any information would be much appreciated. THANKS !!!
James
  • 1
0
votes
2 answers

Triggers in PeopleSoft

Can we create triggers in PeopleSoft when running Peoplesoft App Engine? We want to create triggers for some tables based on the selection at the time of App Engine Thanks in advance
user7194270
  • 117
  • 2
  • 16
0
votes
2 answers

Issue in executing a batch file using PeopleCode in Application engine program

I want to execute a batch file using People code in Application Engine Program. But The program have an issue returning Exec code as a non zero value (Value - 1). Below is people code snippet below. Global File &FileLog; Global string…
Sandy
  • 27
  • 2
  • 8
0
votes
1 answer

Generating an EDI 824 file from an EDI 820 file

I am now working on PeopleSoft and doing some tests to know how it works. I want to know if an EDI 824 file that says that a transaction is rejected can make the status payment change from "paid" to "awating for dispatch" or "error". This is why I…
Sofia B.
  • 29
  • 1
  • 5
0
votes
2 answers

SQL to Insert Multiple Rows

Hi I have a table as below, Id StartDt EndDt ----- -------- ------- 123 01-Apr-2016 15-Apr-2016 456 02-Apr-2016 03-Apr-2016 I want to write a generic sql Insert statement that will work in all DB…
Saeem Ahamed
  • 1
0
votes
3 answers

filling a grid with from two different record (table) sources

I was wondering if there is any way to populate a table using two different records. My records have the same primary keys, but when I am adding the specific fields to my grid I have this error: More than one data (key) in one scroll. I tried to…
user 12321
  • 2,846
  • 1
  • 24
  • 34
0
votes
1 answer

Problems with EXEC pplcd from PeopleSoft Application Engine

On a Unix server, I am running an application engine via the process scheduler. In it, I am attempting to use a "zip" Unix command from within an "Exec" pplcode function. However, I only get the error PS_Exec(P): Error executing batch command with…
zeroBelief
  • 21
  • 1
  • 8
1 2
3
4