OBIA 11g - SDE_ORA_AccrualTransactionFact OBIA HR Load Plan Step Hung (Doc ID 2137996.1)

Last updated on FEBRUARY 02, 2017

Applies to:

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

Symptoms

OBIA 11.1.1.9.2
EBS 12.1.3

HR load Plan never gets completed and stuck at below steps:

Load Plan Step: SDE_ORA_AccrualTransactionFact

Session : SDE_ORA_AccrualTransactionFact_Extract > SDE_ORA_AccrualTransactionFact_Extract.W_ACCRUAL_XACT_FS_EXTR -- ODI session got struck at this step.
There are almost half a million accrual records from source and it is trying to load to table DW.W_ACCRUAL_XACT_FS_TMP and it never gets completed even though using DB link mode in Load Plan.

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