E-PG: Wrong Drilling Query URL Executed When Currency Control Field Value Is Populated On Pivot Grid (Doc ID 2730148.1)

Last updated on JULY 27, 2022

Applies to:

Symptoms

Wrong Drilling Query URL is executed when "Currency Control Field" value is populated on Pivot Grid.

This happens when a Pivot Grid is created from a PSQuery with 2 or more different drill down URLs, *and* the "Currency Control Field" is set in the Pivot Grid "Formatting Options" from "Select Data Source Information". The detailed view will no longer correctly generate the drilling URL.

 
In order to replicate the issue, follow the below steps:

1. Create pivot grid query data source that uses multiple drilling query URLs.
2. Create pivot grid and use the query from #1. Make sure to select a "Currency Control Field" on Step 3 Formatting Options tab.
3. Run the Pivot Grid using Pivot Grid Viewer (Reporting Tools > Pivot Grid > Pivot Grid Viewer).
4. Click on any hyperlink from the first pivot grid column that has a mapped drilling query URL - the correct query is executed.
5. Click on any hyperlink from the second pivot grid column that has a mapped drilling query URL - the wrong query is executed. Instead of running the drilling query that the column was mapped to, the system ran the drilling URL from the first mapped column.

Changes

Cause

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