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.
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:
- 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
The issue can be reproduced at will with the following steps:
1. Run the script at the relevant steps in the upgrade
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms