Encounter A SQL Error Occured When Selecting One Person Temporary ID for UCAS Transaction Using Transaction Management Process

(Doc ID 2109021.1)

Last updated on FEBRUARY 23, 2016

Applies to:

PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 and later
PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.


When attempting to process one UCAS Transaction through the Transaction Management Process for One Person Temporary ID, a sql error is returned on click of lookup for Temporary ID.

Error Message:
A SQL error occured. Please consult your system log for details.

Steps to Reproduce:
1. Logon to CS 9 as superuser and navigate to Menu > Student Admissions > Application Transaction Mgmt > Transaction Management Process.
2. Add new Run Control.
3. Select Transaction Name as UCAS.
4. Select ID Selection as “One Person Temporary ID”
5. Select look up for Temporary ID - throws SQL Error message.


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