My Oracle Support Banner

Concurrent Consolidate Inventory Onhand Quantites Finish In Status Error (Doc ID 2012021.1)

Last updated on APRIL 11, 2022

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.