Last updated on FEBRUARY 02, 2017
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.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
Million Knowledge Articles and hundreds of Community platforms