Physical Inventory Adjustment Error ORA-01400 When Executing Inventory Adjustments
(Doc ID 1941845.1)
Last updated on JULY 08, 2020
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")
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