Encounter A SQL Error Occured When Selecting One Person Temporary ID for UCAS Transaction Using Transaction Management Process
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.
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