My Oracle Support Banner

OBIA 11g : Performance Issue with SDE_SIAPAYMENTS_FG Mapping (Doc ID 2244274.1)

Last updated on AUGUST 14, 2018

Applies to:

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

Symptoms

On Oracle Business Intelligence Applications 11.1.1.7.1 version

Implemented Module - Student Analytics

Source system :  Peoplesoft 9.0

Source and target DB versions.    Oracle 12c

 In SDE_PSFT_90_ADAPTOR_SDE_PSFT_SIAPAYMENTCHARGESFACT  session , SIAPAYMENTS_FG mapping is taking around 212 minutes to execute in SDE layer.

Due to this poor performance incremental load plan can not be scheduled

 

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!


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