XML Transcript Request Returns SQL Error - Process 0 Abended at step SSR_TSC_LIB.TestScor.Step30 RC = 805 (108,524)

(Doc ID 1456331.1)

Last updated on NOVEMBER 08, 2016

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 to 9 [Release 9]
Information in this document applies to any platform.


Request Transcript Report errors with the following:


Error "A Sql Error has occurred."
Error: "Process 0 Abended at step SSR_TSC_LIB.TestScor.Step30 (SQL) -- RC = 805 (108,524)"
Error: "CallAppEngine:Application SSR_TSRQST: AppEngine error (2,653)

Application & Version: CS 9.0 patched thru bundle 24
The issue can be reproduced with the following steps:
1. Add test score data for a student as follows:

 Test ID: ACT

Test Component: COMP

Data Source: ACT


Test ID: ACT

Test Component: COMP

Data Course: School

2. Setup the Define Transcript Type as follows on the Test Scores page:

Test ID ACT, Component Composit, Data Source American College Testing
Test ID ACT, Component Composite, Data Source School

3. Create and process a transcript report.


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