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 MARCH 26, 2017

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

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