PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PS security tables can't be accessed in query manager even though query tree has it

edited Feb 15, 2018 5:06PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 6 commentsAnswered

Hello,

I am wondering if anyone has run into this :

We have a custom role with custom permission lists, one of which has a custom query tree with a SECURITY node, which has PSOPRDEFN, OPRFDEN2, and other security-related tables

This custom role is assigned to multiple users and batch IDs. The users with the custom role can pull up PSOPRDEFN in query manager just fine. However, one of the batch ID with that same custom role can't access PSOPRDEFN in query manager. In fact, that batch ID can't access any of the tables in the SECURITY node.

I've run sysaduit, and it doesn't have anything weird with that query tree. I've also run Query Access List Cache, Refresh SJT_CLASS_ALL, Refresh Trans. SJT tables, Refresh SJT_OPR_CLS, and version sync app engine. This is happening in our PRD, TST, QA, so I don't think it's a corrupted user profile.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center