Error in PeopleCode ScrollSelect Processing when using Load ASR Transactions Option to Load Receivers (Doc ID 2013754.1)

Last updated on MARCH 06, 2017

Applies to:

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

Symptoms

When attempting to use parameters Start Date and End Date to limit the number of Purchase orders (in fact, search clicking on <<OK>> Button without selecting any row), when selecting Load ASR Transactions option before running PO_RECVLOAD process (Receive Load Process), the following error occurs:

ERROR:  Error in PeopleCode ScrollSelect processing. (2,213) PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Name:Select_Po_Ship PCPC:15431 Statement:290
Called from:PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Name:GetRecptPODetails Statement:477
Called from:PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Statement:503

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.


The issue can be reproduced at will with the following steps:

1. Add a new Receipt Load Run Control ID

2. In Process Request Parameters Grid, in Receiver Load Options drop-down, select <<Load ASR Transactions>> and a new link <<Select Purchase Orders>> will become available.

3. Go to Select Purchase Order link.

4. Pick a Start Date and an End Date to fetch only Purchase Orders within that period.

5. Click Search. The following message appears:
A SQL error occurred. Please consult your system log for details.

6. Click OK. The following message appears:
Error in PeopleCode ScrollSelect processing. (2,213) PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Name:Select_Po_Ship PCPC:15431 Statement:290
Called from:PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Name:GetRecptPODetails Statement:477
Called from:PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Statement:503

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.

7. Click OK. No Purchase Orders is selected.

8. If we select other fields (PO Unit and Supplier ID) and click search, a number of Purchase Orders are retrieved successfully.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms