Depot Repair: Error Creating Internal Move Order (IMO) - INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control
Last updated on MARCH 02, 2018
Applies to:Oracle Depot Repair - Version 12.1.3 and later
Information in this document applies to any platform.
Attempting to create an Internal Move Order (IMO) in Depot Repair results in error.
The expectation is to perform ONLY move orders between Sub-Inventories which are inside the same Inventory Organizaiton.
In other words, perform sub-inventory transfers only from within Depot Repair.
ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control
Creation of Internal Requisition has failed. Please check the concurrent program log for Requisition Import program for more details.
(R) Depot Repair Manager
(N) Repair Workbench > Logistics Tab > Internal Move Orders
The Java error seems to occur when a locator sub-inventory is selected and no locator details are entered.
However the error happens even when the sub-inventory is not locator controlled and stock exists in both source and destination - and both sub-inventories are usable.
What is Working:
Move Orders can be created without errors via the Inventory forms.
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