My Oracle Support Banner

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 01, 2017

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

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