ORA-12096 Error In Materialized View Log On WIP.WIP_DISCRETE_JOBS
(Doc ID 2462879.1)
Last updated on JUNE 20, 2024
Applies to:
Oracle Work in Process - Version 12.1.3 and laterOracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
Goal
The following error occurs in Data Collection or on WIP side forms:
Unexpected error : ORA-12096 error in materialized view log on WIP.WIP_DISCRETE_JOBS
ORA-01653: unable to extend table WIP.MLOG$_WIP_DISCRETE_JOBS by 8192 in tablespace APPS_TS_SUMMARYSQLCODE=-12096
The following materialized views MLOG$ segments can encounter the same error OR they can cause huge table space consuming:
OWNER SEGMENT NAME
INV MLOG$_MTL_SYSTEM_ITEMS_B
ONT MLOG$_OE_ORDER_LINES_ALL
ENI MLOG$_ENI_OLTP_ITEM_STAR
WIP MLOG$_WIP_DISCRETE_JOBS
MRP MLOG$_MRP_SCHEDULE_DATES
WIP MLOG$_WIP_REQUIREMENT_OPER
Solution
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
| Goal |
| Solution |
| References |