E-CA: In Doing an Application Upgrade, Script Createvw.dms Failed With "SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]'PS_CURRENCY_CD_VW' has more columns than were specified in the column list" (Doc ID 2225525.1)

Last updated on JANUARY 20, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On : 8.55 version, Upgrade

In upgrading FSCM 9.1 PT 8.50 to FSCM 9.2 PT 8.55, the script createvw.dms failed with the following error for CURRENCY_CD_VW:

ERROR
-----------------------
 - SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]'PS_CURRENCY_CD_VW' has more columns than were specified in the column list.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180
CREATE VIEW PS_CURRENCY_CD_VW (CURRENCY_CD, DESCR) AS SELECT currency_cd , effdt , eff_status , descr , descrshort FROM ps_currency_cd_tbl
Error: Unable to process create statement for CURRENCY_CD_VW


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the script at the relevant steps in the upgrade

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