Issue With Delivered Query Access Trees Which Are Missing Access Groups. (Doc ID 2292053.1)

Last updated on JULY 31, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


ISSUE
---------------
Using QUERY_TREE_HR query access tree and found that there are several nodes that link to access groups that do not exist . Missing PiVot Grid access type and unable to add PiVot Grid access type .


PUPIVOT_GRIDS, should be removed and instead PIVOTGRID should be added . There are some non-exixting access type which should be removed. Users cannot insert the access type PIVOTGRID which is available in Application designer.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. PeopleTools> Security>Query Security>Query Access Manager


Cause

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 hundreds of Community platforms