My Oracle Support Banner

Depot Repair: Error Creating Internal Move Order (IMO) - INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control (Doc ID 2366602.1)

Last updated on FEBRUARY 06, 2022

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 Organization.
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.




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

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