E-PG: Pivot Grids With Tree Attached Not Showing Results Correctly
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms