When applying MP6 CS/HRMS ver 9.0 Application Engine UPD701900_A1 fails (Doc ID 1253076.1)

Last updated on NOVEMBER 23, 2015

Applies to:

PeopleSoft Enterprise CS Student Administration - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms


When applying Maintenance Pack 6 (MP6) for Campus Solutions/HRMS version 9.0, Application Engine UPD701900_A1 fails with the following error:

PSAESRV started service request at 09.27.19 2010-10-18

Program 'UPD701900_A1' Started (18030,2)

'DRIVER' 'Step030' 1 INST rows inserted into 'UPG_SFAAL_TAO' (18030,4)

'HERALVL' 'Step020' 0 rows updated on 'SFA_ASG_AL_TBL' (18030,3)

File: X:\PSFT\\aedebug.hSQL error. Stmt #: 1617 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_SFA_ASG_AL_TBL) violated
Failed SQL stmt:INSERT INTO PS_SFA_ASG_AL_TBL (INSTITUTION , AID_YEAR , ACAD_CAREER , ACAD_PROG , ACAD_PLAN , LEVEL_LOAD_RULE) SELECT A.INSTITUTION , B.AID_YEAR , A.ACAD_CAREER , A.ACAD_PROG , A.ACAD_PLAN , A.LEVEL_LOAD_RULE FROM PS_SFA_ASG_AL_TBL A , PS_AID_YEAR_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND B.AID_YEAR <> A.AID_YEAR

Process 3799825 ABENDED at Step UPD701900_A1.HERALVL.Step030 (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s



Cause

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