PV_VER_LANG_VW Fails During Tools Upgrade

(Doc ID 2341641.1)

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.

Symptoms

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.



Changes

 

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