E-UPG Error When Creating View PTIASPRPTPMOLVW During 8.56 Tools Upgrade. (Doc ID 2303113.1)

Last updated on AUGUST 31, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 to 8.56 [Release 8.4]
Information in this document applies to any platform.

Symptoms

On : 8.56 version, Tools Only Upgrade

When running "Creating Updated PeopleTools Views" step ,
the following error occurs.

ERROR
-----------------------
Error: PTIASPRPTPMOLVW - SQL Error. Error Position: 32 Return: 1730 - ORA-01730: invalid number of column names specified
 
 CREATE VIEW PS_PTIASPRPTPMOLVW (PTIASPPKGGUID, OBJECTTYPE, DESCR254, OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3, OBJECTVALUE4) AS SELECT C.PTIASPPKGGUID , A.OBJECTTYPE , B.DESCR254 , A.OBJECTID1 , A.OBJECTVALUE1 , A.OBJECTID2 , A.OBJECTVALUE2 , A.OBJECTID3 , A.OBJECTVALUE3 , A.OBJECTID4 , A.OBJECTVALUE4 , A.UPGRADEACTION , A.PTIASPUPGACTION , A.PTIASPTAKEACTION FROM PS_PTIASPRPTMOL A , PS_PTIASPINTCODES B , PS_PTIASPPKGBUGS C WHERE A.OBJECTTYPE = b.PTIASPINTVALUE AND B.PTIASPLOOKUPCODE = 'OBJTYPE' AND A.PTIASPRPTNO=C.PTIASPRPTNO






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