PeopleCode Error while Clicking Schedule Overdue Icon on POs with Overdue Shipments Page
(Doc ID 2526397.1)
Last updated on JANUARY 24, 2020
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
IBM z/OS on System z
Getting PeopleCode Error while clicking the "Schedules Overdue" icon at the line details of "POs with Overdue Shipments" page at the Supplier Portal on DB2 Environment.
The issue can be reproduced at will with the following steps:
1. Log into Supplier Portal
2. Navigate Supplier Secure Home Page > Alerts > POs with Overdue Shipments
3. Click "Schedules Overdue" on the line
4. Getting the below error
A fatal PeopleCode SQL error occurred. Please consult your system log for details.
SQL Error in Compile.
SCP_RPOSHP_V_FL.PO_ID.RowInit PCPC:1367 Statement:25
During the execution of SQL, an error occurred in the Compile phase of SQL execution. The preceding message should have identified the details of the SQL being executed.
Error in PeopleCode ScrollSelect processing
SCP_ALR_SCH_DTLSCF.Activate PCPC:415 Statement:2
A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document