Error in Run SQL Script ssexp_src.sql: DatabaseToolException (Column Names in Each View or Function Must Be Unique. Column Name 'CNTR_TO_VENDOR' in View or Function 'MMMT_VIEW' is Specified More Than Once.)

(Doc ID 2360876.1)

Last updated on FEBRUARY 15, 2018

Applies to:

Primavera Contract Management - Version 14.0 and later
Information in this document applies to any platform.

Symptoms


ERROR

Error in Run SQL Script ssexp_src.sql: DatabaseToolException (Column names in each view or function must be unique. Column name 'CNTR_TO_VENDOR' in view or function 'MMMT_VIEW' is specified more than once.)

STEPS

The issue can be reproduced at will with the following steps:
1. Run 14.2 dbconfig
2. Receive error above.

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot upgrade to 14.2 successfully.

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