Refreshing the prompts for Oracle BI Reports.

154 Views Asked by At

There are a few prompts on the report of which some are prompts are dependent on other prompts. The user unchecked values on the prompts and is being considered as “’All” and null value is passed to the report.

When the value in the prompt is unchecked, the prompt(s) display a blank and the value being passed to the back-end is NULL and is perfectly fine. The problem is when the user unchecked the values of the prompt on which the other prompt is dependent, both/all the prompts gets refreshed to ALL.

0

There are 0 best solutions below