My Oracle Support Banner

Requisition Loader Process (PO_REQLOAD) Looping if the Number of Digits in the Requisition Line Number are More than 5 Instead of Failing (Doc ID 2793710.1)

Last updated on JULY 22, 2021

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Requisition Loader Process (PO_REQLOAD) looping if the number of digits in the Requisition line number are more than 5 instead of failing
Note: Line_nbr field in record PO_REQLOAD_RQST in Application designer is 5 digit number.

Steps to reproduce the issue:

1) The data was inserted in PO_REQLOAD_RQST table thru third-party.
2) Third party system sent a 6-digit number in line_nbr field in PO_REQLOAD_RQST table.
3) Run the Requisition loader process.(Navigation: Purchasing > Requisition > Load Requisition)
4) The req load process did not fail but kept running in loop for entire day. It has to be cancelled.

Changes

 

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.