My Oracle Support Banner

Gather Schema INV Errors "MLOG$_MTL_ONHAND_QUANTITIES_DETAIL***ORA-12899: Value Too Large" (Doc ID 2717634.1)

Last updated on OCTOBER 18, 2020

Applies to:

Oracle Inventory Management - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Gather Schema Stats for INV Errors with "MLOG$_MTL_ONHAND_QUANTITIES_DETAIL***ORA-12899: value too large"

22-SEP-2020 20:05:30]: **Ends**
ORA-0000: normal, successful completion
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= INV percent= 0 degree = 4 internal_flag= NOBACKUP
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=INV.MLOG$_MTL_ONHAND_QUANTITIES_DETAIL***ORA-12899: value too large for column "APPLSYS"."FND_STATS_HIST"."OBJECT_NAME" (actual: 34, maximum: 30)***
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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