PO_RECVLOAD Error Processing A Serialized Receipt

(Doc ID 2372983.1)

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.

Symptoms

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

Error -

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

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