UCAS Applicant Import Uses Live ODBC Link even when Live Flag is Disabled

(Doc ID 2100171.1)

Last updated on JULY 29, 2016

Applies to:

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


When running an import from staging only as the test system does not have a live ODBC link to UCAS, the 'Import Live' flag on the run control is disabled at Recruiting and Admissions > UCAS > Import Applicants > Import Applicant Data and run the process.

However, the process crashes as it is attempting to import data from the ODBC link, even though not running a live import.

Error Message:

SQL error. Function: SQLExec Error Position: 49 Return: 2019 - ORA-02019: connection description for remote database not found Statement: select running from cvrefresultsrefreshcontrol @ UCAS Original Statement: %sql( SAD_UC_CVREFRESHCONTROL ,UCAS)


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