MSCA Receiving Failing With Error 'Update Shipment Header Failed' Errors ORA-06512 ORA-01403 (Doc ID 2040377.1)

Last updated on MAY 31, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to receive expense items in Mobile, the following error occurs.

ERROR
-----------------------
'Update Shipment Header Failed' |INV ALL_SQL_ERROR (ROUTINE=INV_RCV_STD_RCPT_API
S.rcv_update_header_interface) (ERR_NUMBER=50) (SQL_ERR=ORA-01403: no data found
ORA-06512: at "APPS.INV_CR_ASN_DETAILS",
line 1187 ORA-01403: no data found).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Receipts > All
2. Receipt (10) > Enter all data below
ASN Num = 920000147
Item = Multi-net
Desc = Multi-net
Project = C201750
Location = Carlsbad
UOM = EAC(1 EAC
Qty = 1
3. Done
4. Receipt Information > Enter data below
ASN Num = 9200001475
Rcpt Num = 124176
Pack Slip = 9200001475
Waybill = UPS AWB: 1
Airbill = UPS AWB: 1
5. Done and see below Message Page
Update shipment header failed. |INV ALL_SQL_ERROR (ROUTINE=INV_RCV_STD_RCPT_API
S.rcv_update_header_interface) (ERR_NUMBER=50) (SQL_ERR=ORA-01403: no data found
ORA-06512: at "APPS.INV_CR_ASN_DETAILS",
line 1187 ORA-01403: no data found). Press any key to cont
Mobile Server 1.0. >

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