Analysis With Session Variable Taking Too Much Time To Process Result

(Doc ID 2416574.1)

Last updated on JUNE 28, 2018

Applies to:

Oracle Fusion General Ledger Cloud Service - Version to N/A [Release 1.0]
Information in this document applies to any platform.


On : N/A version, Financial Reporting and Analysis

Analysis with session variable taking too much time to process result

We have 7 analysis with session variable involved in dashboard, it takes around 2 min to provide result. Expectation is to return data within 20-30 seconds.

We have added these 7 analysis in a Dashboard where we are trying to fetch result in different views(Front/Expanded,etc) one at a time.

We have created 7 version of this analysis for 7 parent cost center values.Only difference each analysis has is the Cost center session variable condition.At a time only one analysis is called (eg: User who belongs to Parent 4 tries to run the report so parent 4_analysis will be called in the switchboard.This has been taken care by applying some evaluating condition).

Analysis is based on General Ledger -Balances Real Time subject area.We are trying to fetch actual and budget balances against Cost center and account code combination.


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