My Oracle Support Banner

E-SEC: Related Language Record PSROLEXLATOPRVW Incorrect, Throwing "Error: "Failed SQL stmt: SELECT ROLEUSER,DESCR FROM PS_ROLEXLATOPR_LVW WHERE OPRID=:1 AND LANGUAGE_CD = :2" in Non-English Language (Doc ID 2846369.1)

Last updated on JUNE 23, 2022

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.

Symptoms

User when login with DUT/Non-English language getting below error in application server log file and login page when tried to logon PeopleSoft with incorrect password.

Issue seen in PT 8.59 and PT 8.60 but not replicated in PT 8.58.


Error:
Error: "Failed SQL stmt: SELECT ROLEUSER,DESCR FROM PS_ROLEXLATOPR_LVW WHERE OPRID=:1 AND LANGUAGE_CD = :2"


Application server log:

PSAPPSRV.17170764 (192) [2021-12-15T10:35:39.718 GetCertificate] 5lZHdsbB5XUHgg 2357906611499266049 - (3) Returning context. ID=***, Lang=ZHT, UStreamId=103539718_17170764.192, Token=****** 02.35.39.432720/PS/ZHT//R4lEHcAxJNaJB5oZ27DoYhllKE=
PSAPPSRV.16711984 (204) [2021-12-15T10:38:28.449 GetCertificate] z5V5E8Cc0TJoAw 8671594880611019777 - (3) File: /vob/peopletools/src/pspcm/pcmobuf.cppSQL error. Stmt #: 2933  Error Position: 52  Return: 904 - ORA-00904: "OPRID": invalid identifier
Failed SQL stmt: SELECT ROLEUSER,DESCR FROM PS_ROLEXLATOPR_LVW WHERE OPRID=:1 AND LANGUAGE_CD = :2
PSAPPSRV.16711984 (204) [2021-12-15T10:38:28.449 GetCertificate] z5V5E8Cc0TJoAw 8671594880611019777 - (0) Exception happend in CScrollObjRef::Fill method(), pszWhere=WHERE OPRID = :1
PSAPPSRV.16711984 (204) [2021-12-15T10:38:28.463 GetCertificate] z5V5E8Cc0TJoAw 8671594880611019777 - (3) PeopleSoft ID and Password authentication failed. Invalid password for user ****@<ip>



Steps to replicate the issue

  1. Change the language to DUT/Non-English. Navigate to PeopleTools > Utilities > International > Reset Session Language > Change to Chinese or any language. Save and re-login.
  2. Try to login with incorrect password.
  3. Get above error in login page and application server log file 

Other Steps to Replicate:

      1. Log into PIA (DUT/Non-English)
      2. Navigate to PeopleTools > Security > User Profile > Copy User profile.
      3. Open an existing user profile and fill the required fields to create a user.
      4. Hit the Save button.
      5. Instead of showing the user profile page, it shows a message (no matching value found)
      6. In the Application server log above mentioned error is captured.

 

Changes

 NA

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.