SQL Error in Campus Solutions 9.2 When Selecting View Unofficial Transcript or Generating Transcripts from Request Transcript Report (Doc ID 2202016.1)

Last updated on NOVEMBER 08, 2016

Applies to:

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

Symptoms

ISSUE STATEMENT
---------------
A SQL Error occurs when attempting to view Unofficial Transcript in Self Service (Page: SSS_TSRQST_UNOFF)

ERROR
--------------
A SQL error occurred. Please consult your system log for details

Process 7485 ABENDED at Step SSR_TSPRGLIB.RECINSRT.Step 10 (SQL) -- RC = 805 (108, 524)

CallAppEngine: Application SSR_TSRQST:AppEngine error (2, 653)
SSR_TSRQST_UNOFF.GLB.DERIVED_SSTSRPT.REPORT_REQUEST_PB.FieldChange PCPC:799 Statement:17

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.

ENVIRONMENT
---------------
DB Platform - N/A
Tools Version - 8.55.05
Application & Version - PeopleSoft Enterprise Campus Solutions release 9.2
System Name - Demo

STEPS
---------------
The issue can be reproduced with the following steps:
1. Navigate to Self Service > Academic Records > View Unofficial Transcript  or Records and Enrollment - Transcripts - Request Transcript Report and attempt to generate a transcript
2. Notice the above mentioned error occurs

IMPACT
---------------
Students unable to view transcripts in self service and Administrative Staff is unable to generate transcripts.

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