How To Add An Index in Oracle EBS to Increase Performance in ERPi for Data Load Rule (Doc ID 1335753.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.1.3.00 and later
Information in this document applies to any platform.

Goal

Currently when running a data load rule in ERPi to retrieve source data from Oracle EBS the process is taking over 30 minutes to complete.  Is there a way to increase performance of the data load rule to retrieve the source data from the EBS Delta Balances table quicker?

Solution

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