OBIA 11g SDE_ORAR1213_ADAPTOR_SDE_ORA_PURCHASEVARIANCEFACT Performance is Very Slow (Doc ID 2088912.1)

Last updated on MARCH 29, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.9.2 to 11.1.1.9.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

OBIA-11.1.1.9.2
Source-EBS-12.1.3
Finance & Spend implementation.
EBS-Source hardware-4 CPU's,80GB memory.
Apps server hardware:8 CPU's,32GB Memory.
ODI 11g Load plan Full load/Incremental load
Target version-Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -64bit Production
Source DB version-Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

SDE_ORAR1213_ADAPTOR_SDE_ORA_PURCHASEVARIANCEFACT Performance is very slow on both Full and Incremental Loads

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