My Oracle Support Banner

OAC: Performance Issues When Connecting EPBCS to OAC through ADM Driver (Doc ID 2510585.1)

Last updated on DECEMBER 01, 2019

Applies to:

Oracle Analytics Cloud - Classic - Version 18.1.3 and later
Information in this document applies to any platform.

Goal

On Oracle Analytics Cloud (OAC),

When connecting to EPBCS using the ADM driver, OAC reports that run against Enterprise Planning and Budgeting Cloud Service (EPBCS) cause poor performance in EPBCS (i.e.,) the retrievals are slow.

With this arrangement, One of the big issues is the filters can not be created/used in the reports, use the selection steps instead of filters due to this the retrievals are very slow. Due to this, can not use number of the prompts. 

Question: Is it possible to allow a direct connection to the underlying database to improve performance?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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