My Oracle Support Banner

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

Symptoms


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.

Changes

 Not Applicable

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.