Physical Inventory Adjustment Error ORA-01400 When Executing Inventory Adjustments
Last updated on JANUARY 22, 2018
Applies to:Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
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 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")
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