My Oracle Support Banner

Internal Shipment Receipts For Serialized Items Fail With Err 'Online .. ORA-1403: Pkg INV_MATER (Doc ID 1645758.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

When performing a serial receipt in WMS for intransit shipments, system is showing the error message: 'Online transaction failed' and the serial is getting locked and no longer available to receive. Once the "marked" mtl_serial_numbers fields are cleared and transaction is attempted again, some will process. This process is repeated until all the transactions are processed successfully. This issue occurs for at least 80% of the transactions attempted.

This issue does NOT occur when using Core Receiving forms or when non Serial and non Lot Controlled Items are processed

ERROR
-----------------------
ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control

Log shows

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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