'Bis Materialized View Refresh Program' Error On A Particular Materialized View

(Doc ID 833504.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Operations Intelligence - Version and later
Information in this document applies to any platform.
***Checked for relevance on 06-Mar-2011***
***Checked for relevance on 16-Apr-2013***


-- Problem Statement:
On an R11.5.10.2 Production Instance:

When running the request set to load the 'Inventory Management' dashboard, the following error is

BIS_MV_REFRESH module: BIS Materialized View Refresh Program ends in error:
Start refreshing for OPI_INV_ITD_ORG_MV, mode INIT
MV compile state : VALID.
Performing Initial loading
DB Version:
Atomic refresh: false
OPI_INV_ITD_ORG_MV was altered to parallel

Error occurred:
ORA-12008: error in materialized view refresh path
ORA-01410: invalid ROWID

-- Steps To Reproduce:
1) Run Daily SCI - Clear & Load - Inventory, Warehouse, Transportation-1 (Report Set) which
Inventory Management OPI_DBI_INV_MGMT_PAGE Dashboard

-- Business Impact:
Cannot update the supply chain dashboards used by the CEO.


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