Serial ID Not Populating From ASN To Receipts (Doc ID 2151509.1)

Last updated on JUNE 20, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Serial ID is not captured in Receipts when entered by a supplier through Create ASN page and ran the Recv Load process or abend when quantity greater than 1.
"ABENDED at Step PO_RECVLOAD.RASN0681.Step02 (SQL) -- RC = 805 (108,524)"
 

STEPS
The issue can be reproduced at will with the following steps:

Test 1 - PO with only 1 serial id:
1 - Create PO and dispatch
2 - Logged in as supplier to create ASN
3 - Pulled the PO which was created
4 - Pulled the PO which was created
5 - Inform Ship No and submit ASN
6 - Login Employee and Run Load Receipts process
7 - Opened the Receipts from Add update Receipts page:
  - Clicked Device tracking and no serial id
  - Clicked inv status and no serial id
  - Clicked AM pending and no serial Id

Test 2 - PO more than 1 and enter number Serial ID's as per the quantity.
1 - Create PO, line quantity greater than 1, validate KK and dispatch
2 - Logged in as supplier to create ASN
3 - Inform serial id for each line
4 - Submit ASN
5 - Login Employee and Load Receipts process. NO SUCCESS.
ABENDED at Step PO_RECVLOAD.RASN0681.Step02 (SQL) -- RC = 805 (108,524)


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