Oracle Fusion Incentive Compensation Invalid Materialized Views in Database (Doc ID 2212253.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

There are invalid materialized views in the database for Oracle Fusion Incentive Compensation.

select owner, object_name, object_type, created, last_ddl_time
from dba_objects
where status = 'INVALID'
and object_name like 'CN%'
OWNER OBJECT_NAME OBJECT_TYPE CREATED LAST_DDL_TIME
FUSION CN_TP_TXN_STATUS_MV MATERIALIZED VIEW 2015-05-28 00:49:58 2016-11-05 15:50:39
FUSION CN_TP_HOLD_TXNS_MV MATERIALIZED VIEW 2015-05-28 00:49:58 2016-11-05 15:50:39
FUSION CN_TP_EARNING_STATUS_MV MATERIALIZED VIEW 2015-05-28 00:49:58 2016-11-05 15:50:39
FUSION CN_TP_CREDIT_STATUS_MV MATERIALIZED VIEW 2015-05-28 00:49:59 2016-07-30 19:12:30

select staleness , mview_name
from dba_mviews
where mview_name like 'CN%'
STALENESS MVIEW_NAME
NEEDS_COMPILE CN_TP_TXN_STATUS_MV
NEEDS_COMPILE CN_TP_HOLD_TXNS_MV
NEEDS_COMPILE CN_TP_EARNING_STATUS_MV
NEEDS_COMPILE CN_TP_CREDIT_STATUS_MV

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