My Oracle Support Banner

OBIA 11g: Performance With SDE_FUSION_ACCRUAL_TRANSACTION_FACT_SDS Running Slow (Doc ID 2488257.1)

Last updated on FEBRUARY 20, 2019

Applies to:

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

Symptoms

OBIA 11.1.1.10.2
Data Source: Oracle Fusion Cloud R13
HCM Subject Area

The OBIA/ODI Load Plan step SDE_FUSION_ACCRUAL_TRANSACTION_FACT_SDS performance is very slow. It is taking 9 hours on average for the full load to complete that step and 4 hours for the Incremental. It is taking this much time to insert rows into the target table W_ACCRUAL_XACT_FS.

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.