My Oracle Support Banner

Request Sets DBI For Supply Chain - Customer, Shipping And Product Revenue Error ORA-23413 (Doc ID 734073.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Supply Chain Intelligence - Version 11.5.10.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

On 11.5.10 :
Request sets DBI for Supply Chain - Customer, Shipping and Product Revenue (Report Set) and DBI
for Supply Chain - Customer, Shipping and Product Revenue-1(Incremental) (Report Set) are
erroring out.  As a result, it is not possible to see DBI reports.

Note the following error in the 'BIS Materialized View Refresh Program':


ERROR
ORA-23413: table "APPS"."ISC_DBI_CFM_003_MV" does not have a materialized view log

STEPS
The issue can be reproduced at will with the following steps:


1)Log on to applications.
2)Choose responsibility: Daily Business Intelligence Administrator responsibility.
3)Go to View --> Requests.

Launch request sets DBI for Supply Chain - Customer, Shipping and Product Revenue (Report Set) and DBI for Supply Chain - Customer, Shipping and Product Revenue-1(Incremental) (Report Set)

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.