My Oracle Support Banner

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.

Symptoms

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'.

4. Save.

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.



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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