My Oracle Support Banner

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 APRIL 04, 2019

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.