'A SQL Error Occurred' Error on Individual Activity Manager Page When Logged in Using a Language Other Than the Base Language
(Doc ID 2284833.1)
Last updated on APRIL 22, 2019
Applies to:
PeopleSoft Enterprise CS Student Records - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
On : 9.0/9.2 version, Student Records Activity Management
SQL Error in INDIVIDUAL ACTIVITY MANAGER page when login in Spanish
ERROR
-----------------------
Error pops up on IAM page - A SQL error occurred. Please consult your log system for details
Error in the Trace -
Error Position: 111
Return: 904 - ORA-00904: "SSR_ACT_ID_ROOT": invalid identifier
Statement: select ssr_activity_id,ssr_act_id_seq_nbr,descr from
ps_ssr_iam_acrt2vl where emplid=:1 and institution=:2 and SSR_ACT_ID_ROOT=:3
AND LANGUAGE_CD = :4
Original Statement: %SelectByKeyRLR(:1)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to CS 9.2 Spanish portal
2. Navigate to Registros e Inscripciones > Gestor Actividad Individual > Gestor Actividad Individual (IAM)
3. Click a row from the Search page- output result
4. Notice the SQL Error message pops up
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 |