E-PG: Why Are Pivot Grid Prompts Values Defaulted to Current Date and Current Date – 30? (Doc ID 2651514.1)

Last updated on JULY 27, 2022

Applies to:

Goal

What is the reason for the prompt value to be defaulted to current date (To date) and current date – 30 ( From date) regardless of what is the default values are set in the Pivot Grid definition?

If users are trying to run pivot grid model from Pivot Grid Viewer, the prompts will be filled in with the values from the Pivot Grid Definition ("Select Query Prompt Values" section is Step 2 of Pivot Grid Wizard).

Running the same model from a pagelet or tile, the prompts will be automatically filled in with the current date and 30 days prior.

Solution

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