Error Opening Receipt Loaded From Advance Shipping Receipts (ASR) When Receipt Load Cascade Is Turned On
Last updated on JANUARY 13, 2017
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
Error opening Receipt loaded from Advance Shipping Receipts (ASR)when Receipt Load Cascade is turned on.
Steps to reproduce the issue:
1) Load two ASR files for the same Purchase Order
2) Run PO_RECVLOAD, two receivers will be created
3) Attempt to open either of the two receivers that were created and the following error is thrown:
Negative number assigned to an unsigned field: RECV_LN_SHIP_WK.TTL_SH_QTY_PO. (2,121) RECV_HDR.RECEIVER_ID.SaveEdit Name:ShipQtyPct PCPC:32463 Statement:692
Called from:RECV_HDR.BUSINESS_UNIT.RowInit Statement:73
4) Attempt to create a new receipt for the PO and the following error is thrown:
Negative number assigned to an unsigned field: PO_PICK_ORD_WS.QTY_PRIOR_RECEIPT. (2,121) RECV_PICK_PO_WK.DETAILS_PB.FieldChange Name:PriorAccptQty PCPC:1111 Statement:18
Called from:PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Name:GetRecptPODetails Statement:426
Called from:PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Statement:504
The specified field is an unsigned field and a negative value is being assigned to it.
Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms