Concurrent Consolidate Inventory Onhand Quantites Finish In Status Error

(Doc ID 2012021.1)

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