My Oracle Support Banner

SQL Error After Selecting the Purchase Order (PO) Line for Receiving on the Select PO Page - (2,280) RECV_LN_SHIP_WK.FUNCLIB.FieldChange (Doc ID 1513971.1)

Last updated on FEBRUARY 05, 2019

Applies to:

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

Symptoms

After selecting the Purchase Order (PO) Line for Receiving on the Select PO Page and clicking OK, a fatal PeopleCode error is received.

 

Error:

SQL error in Exec. (2,280) RECV_LN_SHIP_WK.FUNCLIB.FieldChange
Name:DistribByAmtVuom PCPC:28591 Statement:479
Called from:RECV_LN_SHIP_WK.FUNCLIB.FieldChange Name:ShToDsQtyAccptVuom Statement:523
Called from:RECV_HDR_WK.PB_SELECT_PO.FieldChange Name:RecvLineUpdate Statemnet:436
Called from:RECV_HDR_WK.PB_SELECT_PO.FieldChange Name:CopyPoShip Statement:530
Called from:RECV_HDR_WK.PB_SELECT_PO.FieldChange Name:Pick_PO_to_Receipt Statement:571
Called from:PO_PICK_ORD_WRK.PB_SELECT_PO.FieldChange Name:Launch_Pick_Order

Steps to reproduce the issue:


1. Navigate to Purchasing=>Receipts=>Add/Update Receipts, clicks the Add button to add a receipt.
2. On the next page, put in the Business Unit and PO ID, and clear the check box "Retrieve Open PO Schedules", then click Search.
3. When the PO displays at the bottom, check the box under Select and click OK.
4. A fatal PeopleCode SQL error occurred.


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
References


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