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

Symptoms


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:


ERROR
-----------------------
ORA-01427: single-row subquery returns more than one row


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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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