E-SEC: PT 8.53 Data Integrity Errors for Users Dynamically Assigned to Roles (Doc ID 1603722.1)

Last updated on JULY 27, 2022

Applies to:

Symptoms

ISSUE STATEMENT
---------------
After adding permission lists to a dynamic role we were getting the following messages intermittently when accessing the newly authorized components:
- You are not authorized to access this component (40,20)
- Data Integrity Error (124,85)
The problem that is occurring is that when there is a change to a Role that is dynamically assigned to some users, it is updating version for users who is statically assigned to the role, but not dynamically assigned to the role. For this reason, the user who is dynamically assigned to the role is getting errors like above.

 
ERROR
---------------
- You are not authorized to access this component (40,20)
- Data Integrity Error (124,85)
 

ENVIRONMENT
---------------
PeopleTools 8.53
 
STEPS TO REPLICATE
---------------
The issue can be reproduced with the following steps:
1. Create two users, USER1 and USER2
2. Create a role, called ROLE1 and make sure it is a Dynamic Role Rule given any query (that gives this Role to USER1 but not to USER2), and that it has any Permission List assigned to it (example PTPT1000).
3. Assign this role manually to USER2
4. Check the VERSION for the two users, USER1 and USER2
5. Run the Dynamic Role Rule process
6. Ensure that USER1 got the Dynamic Role Rule
7. Make a change to the role and add another Permission List to it
8. Check the VERSION for the two users, you will see that the user statically assigned to the role (USER2) has its VERSION incremented by 1, however, for the dynamically assigned user (USER1), the VERSION does not get incremented.

 
IMPACT
---------------
The problem with the VERSION not getting updated for USER1 is causing all kinds of errors for the user when they navigate through pages within PIA.

Changes

Cause

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