E-SEC: When Modifying the User Description, in a Language Other than the Base Language, the Change Is Reflected in PSOPRDEFN and PS_ROLEXLATOPR, but not in PS_ROLEXLATOPR_LNG
(Doc ID 2715485.1)
Last updated on SEPTEMBER 30, 2020
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.
When modifying the User Description, in a language other than the Base Language, the change is reflected in PSOPRDEFN and PS_ROLEXLATOPR, but not in PS_ROLEXLATOPR_LNG.
The issue can be reproduced at will with the following steps:
[Using Canadian French for User Language, as an example. Base Language is English].
With the system in Canadian French:
1. Navigate to Utilitaires PeopleTools > Gestionnaire sécurité > Profils utilisateur > Profils utilisateur (PeopleTools > User Profiles > User Profiles).
2. Open the User ID and go to the Code (ID) tab.
3. Modify the User Description under 'Description utilisateur'.
5. Inspect tables PSOPRDEFN, PS_ROLEXLATOPR and PS_ROLEXLATOPR_LNG in the backend.
Update was done, as expected, in PSOPRDEFN and PS_ROLEXLATOPR, but not in PS_ROLEXLATOPR_LNG.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document