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

Last updated on OCTOBER 03, 2016

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

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