PO_RECVLOAD Error Processing A Serialized Receipt
Last updated on MARCH 13, 2018
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
User have connectivity to warehouse application system where most receipts are entered and sent to PeopleSoft and processed through the PO_RECVLOAD app engine program. User was able to process non-serialized receipts, but when we sent serialized receipts the process abends with a duplicate insert error into PS_RECV_LN_ASSET table in step PO_RECVLOAD.INSRECV.STEP0051 (SQL).
Noticed that the SQL statement was changed to pull the RECV_LN_ASSET.DISTRIB_SEQ_NUM value from the PS_RECV_ASN_DEFA D in image 24, instead of PS_RECV_LOAD_T2B4 B table in image 14.
Steps to reproduce the issue:
1.Enter PO for serialized item with quantity of 5
2.Send Expected PO Receipt Message (PO_EXPECTED_RECEIPT_BUS_UNIT) to Warehouse System
3.Get PURCHASE_ORDER_RECEIPT message back with 5 serial numbers from Warehouse System
4) Run PO_RECVLOAD to process the BCT Receipt and create the PO Receipt transaction
Process 965565 ABENDED at Step PO_RECVLOAD.RASN0678.STEP0041 (SQL) -- RC =805 (108,524)
Process 130532 ABENDED at Step PO_RECVLOAD.INSRECV.STEP0051 (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 04.43.14 2017-09-04
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