OBIA 11g - SDE_ORA_AccrualTransactionFact OBIA HR Load Plan Step Hung
(Doc ID 2137996.1)
Last updated on FEBRUARY 10, 2020
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52.2 and later
Information in this document applies to any platform.
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.
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