OBIA 11g: SDE_ORAR1213_ADAPTOR_SDE_ORA_SLAJOURNALFACT Full Load Running For Days With No Activity at Step Insert Row

(Doc ID 2322250.1)

Last updated on MARCH 29, 2018

Applies to:

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

Symptoms

Full load of SDE_ORAR1213_ADAPTOR_SDE_ORA_SLAJOURNALFACT running for days.  Hung without any activity at step SDE_ORA_SLAJournalFact.W_SLA_XACT_FS-Insert New rows. 

Have already applied Instruction_20534742__GL_EBS_SDE_ORA_SLAJOURNALFACT_PerformanceFix_111181_V6.doc for incremental load performance.

Changes

This happened after applying the OBIA CPU patch for both application and Database. 

Cause

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