My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.