Eprocurement Casual Receiving Page Gives An Error On Search
(Doc ID 2426315.1)
Last updated on APRIL 01, 2021
Applies to:
PeopleSoft Enterprise SCM eProcurement - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
In ePro-Casual receiving, the user receives SQL error message on search.
ERROR
-----------------------
A SQL error occurred. Please consult your system log for details.
Error in PeopleCode ScrollSelect processing.
PV_RECV_PICK_WK.PB_FETCH_PO.FieldChange Name:pv_pb_fetch_po PCPC:25491 Statement:503
Called from:PV_RECV_TX_FL.Activate Statement:22
A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function.
This error may have been described by a preceding message.
STEPS
-----------------------
1. Enable ePro Receiving under employee self-service home page.
2. Make the ship to location blank under user preference.
3. Enter the BusinessUnit and click search, the user will get SQL error message.
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 |
| Cause |
| Solution |
| References |