My Oracle Support Banner

Dashboard Prompt On Descriptive Flex Fields (DFF) Timing Out (Doc ID 2238332.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Fusion Incentive Compensation - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Analytics

ACTUAL BEHAVIOR
---------------
Dashboard prompt timeout
Customer is using custom report with multiple parameters.
Parameters used:
Business Unit
PL Tier2
PL Tier3

PL Tier4
From and To date.

Tier1 & Tier2 are DFF and value of Tier3 depends on Tier2.
Whenever they query Tier3, application is trying to look for the all the trx in a system to get tier2 values and show only values which are related to Tier2, but it seems due to very high volume it is timing out.

EXPECTED BEHAVIOR
-----------------------
No timeout should occur and the list of values should be displayed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open custom report
2. Try to query on Tier3 which is dependent on Tier 2.
Observe that timeout occurs and no values are available to be selected.

Same issue was observed for Tier4 which is dependent on Tier3.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the report.

Cause

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
Symptoms
Cause
Solution
References


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