App Engine UPD879831_A6 Gives ORA-01427 - PS_INSTALLATION_SR Record has Duplicate Rows (Doc ID 2165495.1)

Last updated on JULY 27, 2016

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 and later
Information in this document applies to any platform.

Goal

On : 9 version, Student Records Other


Getting error on UPD879831_A6 Step while applying the CS 9.0 Bundle# 26

PeopleTools 8.54.10 - Application Engine
Copyright (c) 1988-2016 Oracle and/or its affiliates.
All Rights Reserved
Program 'UPD879831_A6' Started (18030,2)
File: e:\pt85410b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 53 Return: 1427 - ORA-01427: single-row subquery returns more than one row
Failed SQL stmt: UPDATE PS_INSTALLATION_SA SET SSR_AC_DEC_DISPIND = ( SELECT SSR_GPA_DEC_IND FROM PS_INSTALLATION_SR)
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt85410b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 53 Return: 1427 - ORA-01427: single-row subquery returns more than one row
Failed SQL stmt: UPDATE PS_INSTALLATION_SA SET SSR_AC_DEC_DISPIND = ( SELECT SSR_GPA_DEC_IND FROM PS_INSTALLATION_SR) (200,0)

Process 42104 ABENDED at Step UPD879831_A6.DecIndUp.ACDecInd (SQL) -- RC = 1427 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 42104 ABENDED at Step UPD879831_A6.DecIndUp.ACDecInd (SQL) -- RC = 1427 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
 

Solution

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