OBIA 11g - SDE_ORA_AccrualTransactionFact OBIA HR Load Plan Step Hung

(Doc ID 2137996.1)

Last updated on FEBRUARY 05, 2018

Applies to:

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


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.


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