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.
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
Million Knowledge Articles and hundreds of Community platforms