OBIA 11g - SDE_ORA_AccrualTransactionFact OBIA HR Load Plan Step Hung
Last updated on FEBRUARY 05, 2018
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.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.
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