Peopletools View PV_VER_LANG_VW Creation Fails During Tools Upgrade To PT856.01 (Doc ID 2295663.1)

Last updated on AUGUST 09, 2017

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

During  tools upgrade of FSCM 9.2 database from 8.53 to 8.56 808R1, the view PV_VER_LANG_VW failed with following error 

Creating View PV_VER_LANG_VW
- SQL Error. Error Position: 0 Return: 8010 - [Microsoft][ODBC Driver 11
for SQL Server][SQL Server]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

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