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 <> 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 <> and a new link <