Alter Table PS_PV_CONN_CHNG_WS Error When Upgrading From FSCM 9.1 TO FSCM 9.2
Last updated on JANUARY 04, 2017
Applies to:PeopleSoft Enterprise SCM eProcurement - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
Upgrade from FSCM 9.1 application to FSCM 9.2. During the CA step Altering Tables, receive the following error:
ALTER TABLE PS_PV_CONN_CHNG_WS ADD BUSINESS_UNIT VARCHAR(5) NULL
Msg 4909, Level 16, State 1, Server GBPSFNDB2, Line 175
Cannot alter 'PS_PV_CONN_CHNG_WS' because it is not a table.
Application Designer shows PS_PV_CONN_CHNG_WS as a table, However, this is a view in the database. This table or view does not exist in the database prior to the upgrade attempt.
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