HRC_SESSION_UTIL.get_user_personid: User Name Change Impact on download Self-Serve Letters

Ashok Kumar Sharma

We encountered an issue where a rehire action caused a user's username to change from XXXXXX to YYYYYY. Post this change, the user receives the following error message when attempting to download Self-Serve Letters

Error Message:

Unauthorized Access: Either you do not have the privilege, or you have not signed in.

We have the following condition at the end of the BIP report:

WHERE person_id = HRC_SESSION_UTIL.get_user_personid

After the testing we found that when we reverted teh username back to XXXXXX (Old one) in the test environment, the issue was resolved. However, keeping the username as YYYYYY consistently results in the error.

Additional Details:

• The user's Active Directory(AD) account is associated with YYYYYY, preventing us from switching the username from YYYYYY to XXXXXX in PROD. I mean we cannot switch user name to old user name to resolve the issue in PROD as it will cause login issues.
• The issue seems related to the get-user_personid function