Internal Shipment Receipts For Serialized Items Fail With Err 'Online .. ORA-1403: Pkg INV_MATER
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.
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
ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control
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