Campus 9.0 Bundle 44 Installation Create Views Step Fails On View PS_SAD_BPV_CBK_SRC (Doc ID 2229473.1)

Last updated on APRIL 25, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9 [Release 9]
PeopleSoft Enterprise CS Contributor Relations - Version 9 to 9 [Release 9]
PeopleSoft Enterprise CS Academic Advisement - Version 9 to 9 [Release 9]
PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 to 9 [Release 9]
PeopleSoft Enterprise CS Financial Aid - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

Step "Run Create Views Script" of the Build and Alter section of the change assistant template for Campus 9.0 Bundle 44 fails.

It fails creating view: PS_SAD_BPV_CBK_SRC with the following error:

 

SQL0158N The number of columns specified for "PSDB2.PS_SAD_BPV_CBK_SRC" is not the same as the number of columns in the result table. SQLSTATE=42811

SQL:

CREATE VIEW PS_SAD_BPV_CBK_SRC (EXT_ORG_ID, ORG_LOCATION, HEGIS_CODE,
DESCR50, SAD_INT_CONTR_NLD, SAD_BPV_C_DESC_NLD, SAD_BPV_STREET_NLD,
NUM1, NUM2, SAD_BPV_PTC_FR_NLD, SAD_BPV_PTC_TO_NLD) AS SELECT
B.EXT_ORG_ID , B.ORG_LOCATION , B.HEGIS_CODE , ( SELECT
D.SCC_HEGIS_TYPE_NLD FROM PS_SSR_HEGISCD_NLD D WHERE D.HEGIS_CODE =
B.HEGIS_CODE) , A.DESCR , B.SAD_INT_CONTR_NLD , B.DESCR50 ,
C.ADDRESS3 , C.NUM1 , C.NUM2 , C.POSTAL , C.POSTAL FROM
PS_SAD_BPV_CTR_NLD B , PS_ORG_LOCATION A LEFT OUTER JOIN
PS_SAD_BPV_OLD_NLD C ON A.EXT_ORG_ID = C.EXT_ORG_ID AND
A.ORG_LOCATION = C.ORG_LOCATION AND C.ADDRESS_TYPE = 'BUSN' WHERE
A.EXT_ORG_ID = B.EXT_ORG_ID AND A.ORG_LOCATION = B.ORG_LOCATION AND
A.EFFDT=(SELECT MAX(EFFDT) FROM PS_ORG_LOCATION A1 WHERE
A1.EXT_ORG_ID=A.EXT_ORG_ID AND A1.ORG_LOCATION=A.ORG_LOCATION AND
A1.EFFDT<=CURRENT DATE) AND C.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM
PS_SAD_BPV_OLD_NLD A_ED WHERE C.EXT_ORG_ID = A_ED.EXT_ORG_ID AND
C.ORG_LOCATION = A_ED.ORG_LOCATION AND C.ADDRESS_TYPE =
A_ED.ADDRESS_TYPE AND A_ED.EFFDT <= CURRENT DATE);



PeopleSoft Enterprise Campus Solutions Community  Support Blog  Information_Centers  Maintenance_Advisor 

 

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