My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2019

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.