OBIA 11g Incorrect Stats Generated On Fact Temporary, Reconciliation Tables Used In PLP And Diff Man Loads

(Doc ID 1910835.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

In BI Application 11.1.1.7.1 the Finalize step which calculates all the stats on Fact, reconciliation and other temporary tables happens at the end of the fact group. So during the incremental loads when you execute the diff man load ETL Task which queries on reconciliation tables and loads the fact tables, the SQL optimizer generates the load plan based on the old stats generated in the last full/incremental load. Because of this the ETL tasks are getting stuck.

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