My Oracle Support Banner

OBIA 11g: Performance Issue on FTS General Post Load in ODI (Doc ID 2538734.1)

Last updated on JANUARY 24, 2022

Applies to:

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


On Oracle Business Intelligence Applications Consumer(OBIA) version, 

The "3 FTS General Post Load" in ODI is taking 57 mins to complete on an average. 

Below sessions are taking time. All these sessions are serial execution. 

  1. Execute Grants to DW User (Oracle Fusion 11 CRM) 
  2. Execute Grants to DW User (Oracle Fusion 11 FSCM) 
  3. Execute Grants to DW User (Oracle Fusion 11 HCM)  

In ODI session logs, found that "Build changed table or column DDLs" task is taking most of the time. 

Environment Details:

  1. OBIA Version: OBIA 
  2. ODI Version: ODI_11. 
  3. Source system & its version: Oracle cloud FUSION 11  
  4. Modules being used: Financials




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.