Peopletools View PV_VER_LANG_VW Creation Fails During Tools Upgrade To PT856.01
(Doc ID 2295663.1)
Last updated on APRIL 03, 2023
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 |