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 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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms