My Oracle Support Banner

E-PG: Pivot Grid Chart Only - Tick Box to Toggle Sort Option On/Off (Doc ID 2520929.1)

Last updated on NOVEMBER 26, 2019

Applies to:

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


Currently when you look at pivot grids that are created as 'Chart Only' they all get a 'Sort Option' in the drop down menu of the cog icon.

The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Pivot Grid > Pivot Grid Viewer
3. Select the first report
4. Click on the Cog to see drop down menu items
5. The Sort Option cannot be removed from the menu
6. Go to Pivot Grid Wizard display options.
7. The Sort Option is not listed here.


 Sort Options is disabled for 'Pivot Grid Only' and 'Pivot Grid and Chart' views. So when using Pivot Grids with these options the Sort feature will no longer occur under the Pivot Grid Viewer page. The Sort feature only occurs for 'Chart Only' View option.

The purpose of this enhancement is to provide a feature for the users with the role PivotGridAdmin. Ideally, the Sort Option should be available on the 'Display Options' config page as it can be checked/un-checked.


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.