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 03, 2017

Applies to:

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

Symptoms

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:  
-----------------------
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.



The issue can be reproduced at will with the following steps:
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.

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