Concurrent Consolidate Inventory Onhand Quantites Finish In Status Error
Last updated on MAY 19, 2015
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to run the Consolidate Inventory Onhand Quantites request (INV_CONSOLIDATE_ONHAND) the following error occurs.
Consolidation of Onhand Quantities failed.
You see this additional error with inventory debug enabled:
ORA-12899: value too large for column "INV"."MTL_MOQD_BACKUP"."LOT_NUMBER" (actual: 32, maximum: 30)
Here is an example of the error in the log file without debug enabled:
1. Navigate to Inventory Responsibility > Requests > Submit
2. Select the Consolidate Inventory Onhand Quantites request
3. The program completes in error.
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