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

Last updated on AUGUST 11, 2022

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.