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 SEPTEMBER 21, 2016

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:                   



Cause

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