OBIA 11g: Indexes Are In Stale State After ODI Gather Stats Step (Doc ID 2285406.1)

Last updated on AUGUST 07, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

OBIA 11.1.1.10.8 and higher including 11.1.1.10.x

BI Apps modules: - Financials, Proc & Spend, HR Analytics, and custom modules
Target System/Version: DB- Oracle 12C (12.1.0.2.0)

After data loads in OBIA 11G using ODI (and Session finishes successfully), found that the indexes are in stale state.
The ODI gather stats script is using CASCADE=> FALSE due to which it is skipping the stats on indexes and as a result the indexes are becoming stale.

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