Sales Incremental Request Set ORA-23413 Error On BIL_BI_GRP_CNT_MV (Doc ID 1631228.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Sales Intelligence - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

You are trying to run the Incremental Sales Request Set program but it is showing error:

BIS Materialized View Refresh Program


**Starts**25-FEB-2014 10:10:18
**Ends**25-FEB-2014 10:10:19
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

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