When Running UCAS Import Reference Data for SAD_UC_IMREF CvSchoolContact, Get Error ORA-01427 Single Row Subquery Returns More Than One Row
(Doc ID 2334786.1)
Last updated on OCTOBER 09, 2018
Applies to:PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.
In running the delivered SAD_UC_IMREF cvSchoolContact update process, an existing school code is causing the subquery to not make use of the contactid field and returns multiple rows based on the contact code. The following error is encountered:
ORA-01427: single-row subquery returns more than one row
The issue can be reproduced at will with the following steps:
1. Go to Set Up SACR > Product Related > Recruiting and Admissions > UCAS > Import Reference Data.
2. Run the Import Reference Data Application Engine (SAD_UC_IMREF) process to import the reference data.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document