Gather Schema INV Errors "MLOG$_MTL_ONHAND_QUANTITIES_DETAIL***ORA-12899: Value Too Large"
(Doc ID 2717634.1)
Last updated on AUGUST 06, 2024
Applies to:
Oracle Inventory Management - Version 12.2.9 and laterInformation 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 |