When Running UCAS Import Reference Data for SAD_UC_IMREF CvSchoolContact, Get Error ORA-01427 Single Row Subquery Returns More Than One Row
Last updated on DECEMBER 01, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms