"Bis Materialized View Refresh Program" Running For Hours: No Output In Log File (Doc ID 836203.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle E-Business Intelligence - Version 11.5.8 to 12.1.1 [Release 11.5 to 12.1]
Oracle Financials Intelligence - Version 11.5.8 to 12.1.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:

The user is running the DBI Initial Load request set for all Financials dashboards.

The request set executes the BIS Materialized View Refresh Program with the parameter "INIT,
FII_GL_BASE_MAP_MV", which executes for hours. Initially it was giving a tablespace error which got
resolved after increasing the tablespace.

Because the user wishes to demonstrate Oracle Balanced Scorecard as well as Daily Business Intelligence,
the option "Use Material Views for Summarization" is checked in BSC.

Following <Note 358287.1>, the user has set the profile option 'Concurrent:Sequential Requests' to
'No', but this does not resolve the problem.

The user has e-Business Suite 12.0.6 with Oracle database 10.2.0.3.

-- Steps To Reproduce:
1. Log into e-Business Suite 12.0.6.
2. Navigate to the DBI Administrator responsibility.
3. Requests -> View Request Set -> DBI Initial Load for Financials.
4. At the standard Materialized View Refresh Program, enter the parameter "INIT,
FII_GL_BASE_MAP_MV".
5. Submit.

-- Business Impact:
Unable to populate Financials dashboards in Daily Business Intelligence.

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