My Oracle Support Banner

Error Received when Clicking on the Receipt, Comment Bubble: RECV_LN_WK.PB_PO_COMMENTS.FieldChange Name:GetPoComments PCPC:3751 Statement:41 (Doc ID 2324700.1)

Last updated on NOVEMBER 23, 2019

Applies to:

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


Requisitions and Purchase Orders both have the ability to create Header and/or line comments. When creating these comments there is a check-box 'Show at Receipt' that is intended to preserve or copy these these comments and make them available on the receipt.

However, if the SHIPTO_ID used in the Req or PO has an apostrophe, a SQL error is generated when trying to view these comments. 

Error in PeopleCode ScrollSelect processing. (2,213)
RECV_LN_WK.PB_PO_COMMENTS.FieldChange Name:GetPoComments PCPC:3751 Statement:41
Called from:RECV_LN_WK.PB_PO_COMMENTS.FieldChange Name:F_PB_PO_COMM Statement:57
Called from:RECV_LN_WK.PB_PO_COMMENTS.FieldChange Statement:63

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 to reproduce the issue:
1. Create a Location ID with an (apostophe) included
2. Create a Ship To Location using the Location
3a. Create a purchase order using the above ship to location.
3b. Add a line comment with Shown at Receipt checked.
4. Dispatch the PO.
5. Receive the PO. Click the Source Information tab
6. Click into the Line Comment Bubble icon.
7. Errors are received.
8. Receipt can still be saved.

The issue has the following business impact:
Due to this issue, users cannot see the PO Line comment.


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

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