My Oracle Support Banner

Error When Trying To Create A Receipt From A Purchase Order .Error in PeopleCode ScrollSelect processing. (2,213) PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Name:SelPoShipItem PCPC:21215 Statement:347 (Doc ID 2561500.1)

Last updated on FEBRUARY 01, 2023

Applies to:

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

Symptoms

On : 9.2.30, Receiving

Error when trying to create a receipt from a PO

Getting below error when clicking on Search with Retrieve Open PO Schedules box unchecked.




 

ERROR
-----------------------

Error in PeopleCode ScrollSelect processing. (2,213) PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Name:SelPoShipItem PCPC:21215 Statement:347
Called from:PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Name:GetRecptPODetails Statement:429
Called from:PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Statement:559

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.

Examine the error messages and the PeopleCode program containing the ScrollSelect call to determine the cause of the error.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Add/update receipts page
2. do not select "Retrieve Open PO Schedules" click on search
3. Error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot select Purchase order's on receipts page

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


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