Create Intransit Shipment Interface Record Failed: INV_ALL_SQL_ERROR, ORA-01403: No Data Found (Doc ID 2037076.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Via Mobile Supply Chain Application (MSCA) using Warehouse management systems (WMS):

Create In-transit shipment interface record failed trying to receive an internal sales order on wms mobile using Int Shipments menu, get the following message.

Error

Steps
1. Create an Internal Requisition
2. Create internal sales order
3. Pick release
3. Pick complete (Using LPN Pick and Drop in WMS Mobile)
4. Ship Confirme
5. Perform Internal Shipment receipt in Mobile Applications (MSCA/WMS) via Inbound > Receipt > Int Shipment.
6. Key in Delivery as shipment number
7. Enter LPN, item, subinventory, locator, quantity, lot, lot quantity.
8. Hit Done.
9. Receive the error message.

Cause

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