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 18.104.22.168.1 and later
Information in this document applies to any platform.
In BI Application 22.214.171.124.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!