My Oracle Support Banner

E-PG: Query Drilling URL Column is Enabled with Hyperlink On Blank Fields When Accessing From Pivot Grid. (Doc ID 2624764.1)

Last updated on JANUARY 01, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

Upon running Pivot Grids, hyperlink are seen on the blank fields of query drilling URL columns. 


The issue can be reproduced at will with the following steps:


1. Navigate to Reporting tools >Query > Query Manager.

2.  Create a new Query with Drilling URL and a case statement to get the blank fields that column.

3. Create a Pivot grid from Reporting tools > Pivot Grid > Pivot Grid Wizard using this query as a data source.

4. Open the newly created Pivot grid from Reporting tools > Pivot Grid > Pivot Grid Viewer and it can identified that blank fields are enabled with drilling URL.

Cause

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
Symptoms
Cause
Solution
References


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