My Oracle Support Banner

Physical Inventory Adjustments Fails With (Main-11a) Error Code = -1405 Or ORA-01400 Cannot Insert Null Into "INV"."MTL_PHYSICAL_ADJUSTMENTS"."SUBINVENTORY_NAME" (Doc ID 1938145.1)

Last updated on JANUARY 23, 2021

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Errors when attempting to perform Physical Inventory Adjustments, by running the Physical Inventory Adjustments concurrent request.

ERROR
-----------------------
Error in Physical Adjustment Program - ( SQL Error(Main-11a), Error Code = -1405 )
PHY_INV_SUB_XFER : Process enabled flag : N
PHY_INV_SUB_XFER : Exception inside procedure PROCESS_PHY_INV_SUBXFER :ORA-01400: cannot insert NULL into ("INV"."MTL_PHYSICAL_ADJUSTMENTS"."SUBINVENTORY_NAME")

While performing Physical Inventory there were multiple issues found:                   



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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