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

Last updated on MARCH 13, 2017

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

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