OBIA 11g Slow Performance : EBS 12.2 Adaptor - STAGE_GLSEGMENTDIMENSION_HIERARCHY_PRIMARY & STAGE_GLSEGMENTDIMENSION_HIERARCHY

(Doc ID 2277232.1)

Last updated on JUNE 19, 2017

Applies to:

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

Symptoms

Experiencing a performance issue during daily incremental load run with the E-Business Suite (EBS) 12.2 adapter.

Incremental Loads prior to the upgrade took approximately 1.5 hours.  After the upgrade the same loads are taking 7.5 hours.  In particular the following scenarios are show marked increase of execution time, causing of the performance issue.

SDE_ORAR122_ADAPTOR_SDE_ORA_STAGE_GLSEGMENTDIMENSION_HIERARCHY_PRIMARY
SDE_ORAR122_ADAPTOR_SDE_ORA_STAGE_GLSEGMENTDIMENSION_HIERARCHY 


Changes

 Recently upgraded E-Business Suite (EBS) source system from 12.1.3 to 12.2,  Thus now using the 12.2 adapter.

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