My Oracle Support Banner

ORA-12008: Error In Materialized View Refresh Path ORA-00932: Inconsistent Datatypes (Doc ID 2549941.1)

Last updated on MARCH 02, 2021

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6.3 and later
Information in this document applies to any platform.

Symptoms

12.2.6.3

ORA-12008: error in materialized view refresh path
ORA-00932: inconsistent datatypes: expected - got CLOB
ORA-06512: at "APPS.MRP_CL_REFRESH_SNAPSHOT", line 3077
ORA-06512: at line 1

Same error repeated for different snapshots

1ST RUN
 l14781110.req - 12-MAY 18:27:11 : Error refreshing individual snapshot : APPS.WIP_WOPR_RESS_SN
 l14781108.req - 12-MAY 18:27:11 : Error refreshing individual snapshot : APPS.WIP_WOPRS_SN.
2ND RUN
 l14805237.req -- 12-MAY 20:30:11 : Error refreshing individual snapshot : APPS.WIP_WOPR_RESS_SN
 l14805235.req - 12-MAY 20:30:11 : Error refreshing individual snapshot : APPS.WIP_WOPRS_SN

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.