E-UPG: Creating Updated PeopleTools Views Column Errors

(Doc ID 2410358.1)

Last updated on JUNE 12, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

On : 8.56 version, Upgrade

Creating Updated PeopleTools Views Errors

Running the tools upgrade on the HCM 9.1 to 9.2 Image 24 from 8.54.35 to 8.56.08. During the Creating Updated PeopleTools Views, getting the following errors.

ERROR
-----------------------

Error: PSCPQCRITERIAVW - SQL Error. Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/AIX64] SQL0158N The number of columns specified for "PSOFT.PSCPQCRITERIAVW" is not the same as the number of columns in the result table. SQLSTATE=42811
 (SQLSTATE 21S02) -158
 
 CREATE VIEW PSCPQCRITERIAVW (OPRID, CPQNAME, CRTNUM, COMBTYPE, NEGATION, LPARENLVL, RPARENLVL, CPQQRYALIAS, QRYFLDNAME, CPQLCRTEXPNUM, CONDTYPE, CPQQRYALIASRIGHT, CPQQRYFIELDRIGHT, EXPRTYPE, EXPRESSIONTEXT, CPQR1CRTQRYALIAS, CPQR1CRTFLDNAME, CPQR1CRTEXPNUM, CPQR2CRTQRYALIAS, CPQR2CRTFLDNAME, CPQR2CRTEXPNUM) AS SELECT OPRID ,CPQNAME ,CRTNUM ,COMBTYPE ,NEGATION ,LPARENLVL ,RPARENLVL ,CPQQRYALIAS ,QRYFLDNAME ,CONDTYPE , ' ' , ' ' ,EXPRTYPE , ' ' , CPQR1CRTQRYALIAS , CPQR1CRTFLDNAME , CPQR1CRTEXPNUM , CPQR2CRTQRYALIAS , CPQR2CRTFLDNAME , CPQR2CRTEXPNUM FROM PSCPQCRITERIA WHERE 1=0

Error: PTIASPRPTPMOLVW - SQL Error. Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/AIX64] SQL0158N The number of columns specified for "PSOFT.PS_PTIASPRPTPMOLVW" is not the same as the number of columns in the result table. SQLSTATE=42811
 (SQLSTATE 21S02) -158
 
 CREATE VIEW PS_PTIASPRPTPMOLVW (PTIASPPKGGUID, OBJECTTYPE, DESCR254, OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3, OBJECTVALUE4) AS SELECT A.PROJECTNAME , A.OBJECTTYPE , B.DESCR254 , A.OBJECTID1 , A.OBJECTVALUE1 , A.OBJECTID2 , A.OBJECTVALUE2 , A.OBJECTID3 , A.OBJECTVALUE3 , A.OBJECTID4 , A.OBJECTVALUE4 , CASE WHEN (A.UPGRADEACTION) = 0 THEN '0' ELSE CASE WHEN (A.UPGRADEACTION) < 0 THEN '-' ELSE '' END END CONCAT CAST(REPLACE(RTRIM(REPLACE(REPLACE(REPLACE(LTRIM(REPLACE(RTRIM(CHAR(ABS(A.UPGRADEACTION))),'0', ' ')),' ','0'),',','.'),'.',' ')),' ','.') AS VARCHAR(40)) AS PTIASPUPGACTION , A.TAKEACTION AS PTIASPTAKEACTION FROM PSPROJECTITEM A , PS_PTIASPINTCODES B , PS_PTIASPPKGS C WHERE A.O


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Do tools upgrade on the HCM 9.1 to 9.2 Image 24 from 8.54.35 to 8.56.08.
2. create views

Note:   This may also look like this:

Error: PSCPQCRITERIAVW - SQL Error. Error Position: 29 Return: 1730 - ORA-01730: invalid number of column names specified

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