In BIL BIM Request Set - ORA-23413: table "APPS"."<materialived view>" does not have a materialized view log (Doc ID 1162533.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Sales Intelligence - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.
***Checked for relevance on 19-JAN-2012 ***

Symptoms

Now the BIS Materialized view refresh program failed:
with error ORA-23413
like
ORA-23413: table "APPS"."<materialize view name>" does not have a materialized view log

eg of concurrent log.:
ORA-23413: table "APPS"."BIL_BI_GRP_CNT_MV" does not have a materialized view log
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Start refreshing for BIL_BI_RS_GRP_MV, mode INCR
MV compile state : VALID.
BIL_BI_RS_GRP_MV is Fast Refreshable!

Performing Fast Refresh for BIL_BI_RS_GRP_MV, mode Incremental Loading
Setting star_transformation_enabled=TEMP_DISABLE
Resetting star_transformation_enabled=FALSE
The following error while fast-refreshing BIL_BI_RS_GRP_MV is not ignorable:
ORA-23413: table "APPS"."BIL_BI_GRP_CNT_MV" does not have a materialized view log


Error occurred:
ORA-23413: table "APPS"."BIL_BI_GRP_CNT_MV" does not have a materialized view log
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms