My Oracle Support Banner

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

Last updated on NOVEMBER 28, 2019

Applies to:

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

Symptoms

On Oracle Business Intelligence Applications Consumer(OBIA) 11.1.1.10.2 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 11.1.1.10.2 
  2. ODI Version: ODI_11.1.1.9.0_GENERIC_150427.0937 
  3. Source system & its version: Oracle cloud FUSION 11  
  4. Modules being used: Financials

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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