EAP: ORA-01730: invalid number of column names specified SQL execute error for CREATE VIEW PS_VNDR_NAME1_VWLN Applying FMS 9.1 Bundle #35 (Doc ID 2265352.1)

Last updated on MAY 12, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When running Create Views Script while applying FMS 9.1 Bundle #35, the following error occurs:

ERROR

Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 32 Return: 1730 - ORA-01730: invalid number of column names specified
Failed SQL stmt: CREATE VIEW PS_VNDR_NAME1_VWLN (SETID, NAME1, LANGUAGE_CD, VENDOR_NAME_SHORT, VENDOR_ID) AS SELECT SETID , NAME1 , LANGUAGE_CD , VENDOR_NAME_SHORT FROM PS_VENDOR_LANG (200,0)
SQL Error. Error Position: 32 Return: 1730 - ORA-01730: invalid number of column names specified
CREATE VIEW PS_VNDR_NAME1_VWLN (SETID, NAME1, LANGUAGE_CD, VENDOR_NAME_SHORT, VENDOR_ID) AS SELECT SETID , NAME1 , LANGUAGE_CD , VENDOR_NAME_SHORT FROM PS_VENDOR_L



Changes

 

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