My Oracle Support Banner

RDBMS 28251237 > OM 28248410 > OEXITORDMV Refresh OM Materialized Views. Error ORA-12018 (Doc ID 2437336.1)

Last updated on JULY 04, 2021

Applies to:

Oracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Refresh Order Management Materialized Views concurrent program is failing with following error:
**SQL error and free**22-JUN-2018 01:00:40
ORACLE error 12018 in FDPSTP

Cause: FDPSTP failed due to ORA-12018: following error encountered during code generation for "APPS"."OE_ITEMS_MV"
ORA-01740: missing double quote in identifier
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
ORA-06512: at "SYS.22-JUN-2018 01:00:40

Observed similar patches suggested in Bug.24593132 has two bugs fixed on top of BP 12.1.0.2.161018--> 19134095 and 21297872
Bug Fix#/Patch# 21297872 is already part of 12.1.0.2.170418ProactiveBP and we applied another patch# 19134095 as we mentioned above.

Still issue exist.

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
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.