My Oracle Support Banner

Fusion - All OTBI Prompt Values Refresh Upon Selecting a Value in Any of the Prompts (Doc ID 2318714.1)

Last updated on FEBRUARY 18, 2020

Applies to:

Oracle Fusion Performance Management Cloud Service - Version and later
Information in this document applies to any platform.


The customer created a custom dashboard.
One of the parameters (prompt) fields of this custom dashboard is Employee.
By default it is set to (All Column Values)
When the user is trying to search and select a specific employee (for example 113257) for the parameter Employee, after clicking ok and closing the search and select pop-up, all parameters of the dashboard are refreshed and set back to the default values.

Filter the dashboard to show the results only for the selected employee.

The issue can be reproduced at will with the following steps:
1. Open the dashboard
2. Expand the drop-down list for the parameter Employee
3. Click on More/Search...
4. Search for the employee "113257"
5. Move it to the Selected pool (right side)
6. Click OK
7. As Soon as the OK button is clicked, all parameters of the dashboard are refreshed and set back to the default values
The output of that dashboard is not filtered only for the employee "113257".


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

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