My Oracle Support Banner

Eprocurement Casual Receiving Page Gives An Error On Search (Doc ID 2426315.1)

Last updated on NOVEMBER 23, 2019

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information 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


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