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 SEPTEMBER 06, 2022

Applies to:

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

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