OBIA 11g: EMPLOYEEDIMENSION_JOBINFORMATION Session in ODI is Not Running as Expected

(Doc ID 2073136.1)

Last updated on JANUARY 31, 2017

Applies to:

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


Implementing OBIA with HR Analytics and using Peoplesoft as a source.
You have created a load plan in the BIACM (HCM Load) and monitoring it in ODI on daily basis.

As part of a daily incremental load, the session, completed within seconds and sometimes its taking a long time and causing a delay in the data load.

For example,
The session took 5541 seconds to complete on 21-Sep-2015 and 67 seconds on 23-Sep-2015.
Why are there fluctuations?  How can you tune this query so that there will be no fluctuations in this session?


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