PV_VER_LANG_VW Fails During Tools Upgrade
Last updated on DECEMBER 20, 2017
Applies to:PeopleSoft Enterprise SCM eProcurement - Version 9.1 to 9.2 [Release 9]
PeopleSoft Enterprise PT PeopleTools - Version 8.56 to 8.56 [Release 8.4]
Information in this document applies to any platform.
PeopleSoft Tools 8.56 and above does not support Verity; all the related Verity PeopleTools records have been removed as of PeopleTools 8.56. PeopleSoft eProcurement customers who are still on application release 8.9/9.0/9.1 and performing a PeopleTools-only upgrade to PT 8.56 or later might encounter the following errors due to the missing Verity records / fields.
Creating View PV_VER_LANG_VW Invalid column name 'VERITY_LOCALE'.
CREATE VIEW PS_PV_VER_LANG_VW (LANGUAGE_CD, VERITY_LOCALE, VERITY_VALS, INDEXNAME) AS SELECT A.LANGUAGE_CD , A.VERITY_LOCALE , B.LANGUAGE_MAP , B.INDEXNAME FROM PSLANGUAGES A , PSSIDXLANGUAGE B WHERE A.LANGUAGE_CD = B.LANGUAGE_CD AND A.INSTALLED = 1
Error: Unable to process create statement for PV_VER_LANG_VW
In addition to the record view creation error, there might also be issues with running Application Engine Programs that uses records which contain the VERITY_LOCALE field, such as PV_SRCH_RUN_AET / SAC_IDX_RUN_AET.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms