SQL Error In Individual Activity Manager Page

(Doc ID 2284833.1)

Last updated on JULY 26, 2017

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Student Records Additional Features

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 potal
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


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users encounters the disruption in accessing a delivered functionality

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms