ERROR APPLYING MAINTENANCE PACK 6 FOR CS 9 (Doc ID 960914.1)

Last updated on MARCH 06, 2017

Applies to:

PeopleSoft Enterprise CS Contributor Relations - Version 9 to 9 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 14-Jan-2013***

Symptoms

An error is returned when running UPD701903_07.dms while applying Maintenance Pack 6.

The log from the error shows:
Error: SQL execute error for INSERT INTO PS_AV_ACTN_GIFT ( INSTITUTION , BUSINESS_UNIT, COMMITMENT_TYPE, EMPLID , EXT_ORG_ID , CNST_ACTN_NO , SESSION_NO , GIFT_NO , SCC_ROW_ADD_OPRID , SCC_ROW_ADD_DTTM , SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM ) SELECT A.INSTITUTION , B.BUSINESS_UNIT , 'PL' , A.EMPLID , A.EXT_ORG_ID , A.CNST_ACTN_NO , A.SESSION_NO , A.GIFT_NO , A.SCC_ROW_ADD_OPRID, A.SCC_ROW_ADD_DTTM, A.SCC_ROW_UPD_OPRID, A.SCC_ROW_UPD_DTTM FROM PS_AV_CNST_ACTN A,
PS_AV_PLEDGE_DTL B WHERE A.INSTITUTION = B.INSTITUTION AND (A.EMPLID = B.EMPLID OR A.EXT_ORG_ID = B.EXT_ORG_ID) AND A.SESSION_NO = B.SESSION_NO AND A.GIFT_NO = B.GIFT_NO AND A.SESSION_NO <> ' ' AND A.GIFT_NO <> ' '
ORA-00904: "A"."GIFT_NO": invalid identifier
Ended: Tue Oct 27 11:52:09 2009
Unsuccessful completion

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