UCAS Applicant Import Uses Live ODBC Link even when Live Flag is Disabled
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.
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