Analysis With Session Variable Taking Too Much Time To Process Result
Last updated on JUNE 28, 2018
Applies to:Oracle Fusion General Ledger Cloud Service - Version 220.127.116.11.0 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