My Oracle Support Banner

E-PG: Pivot Grids With Tree Attached Not Showing Results Correctly (Doc ID 2405697.1)

Last updated on JUNE 11, 2018

Applies to:

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


Pivot Grids with Tree attached not showing results correctly and the drill down shows duplicate rows for same transaction.

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

1. Go to Pivot Grid wizard and select delivered Pivot "AM_ACQ_BY_CAT"
2. On Step # 3, ensure Operating Unit column is selected as “Axis”. Attach the Tree: "OPERUNIT",  Tree Node: "ALL"
3. Ensure Operating Unit is selected as "Row Axis". In Step # 4, Select default view as "Pivot Grid and Chart"
4. Click on Next button to view the Pivot Grid. Pivot Grid results are displayed as per the Tree Hierarchy in the Row Axis and the cost(sum) is inflated.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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