Physical Inventory Adjustment Error ORA-01400 When Executing Inventory Adjustments (Doc ID 1941845.1)

Last updated on APRIL 25, 2016

Applies to:

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

Symptoms

When attempting to perform Physical Inventory Adjustments, by running the Physical Inventory Adjustments concurrent request, the following errors occur in the request log.
Patch 17516591:R12.INV.B was applied, which does describe the same issue, but the issue was not resolved.
The fixed file version in the patch is INVPINLB.pls 120.7.12010000.27. However, the version of the same file in the production instance is INVPINLB.pls 120.7.12010000.28.

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")

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