Reporting View Generation Errors for PS_ADD_SCORECARD_RV: Incorrect Syntax, Identifier Not Found

(Doc ID 1531583.1)

Last updated on JUNE 01, 2017

Applies to:

Primavera Portfolio Management - Version 9.0SP1 to 15.1.0.0 [Release 9.0 to 15.1]
Information in this document applies to any platform.

Symptoms

When attempting to use PS_ADD_SCORECARD_RV,
the following error occurs.

ERROR
-----------------------
In SQL Server Management Studio:
PS_ADD_SCORECARD_RV 'Sani Mid Year Report', 'CWS_Conv_Sani_Mid_Year_Report', null
GO
Msg 207, Level 16, State 1, Procedure CWS_Conv_Sani_Mid_Year_Report, Line 1
Invalid column name 'PORTFOLIO_'.
Msg 4104, Level 16, State 1, Procedure CWS_Conv_Sani_Mid_Year_Report, Line 1
The multi-part identifier "C606.X_VALUE" could not be bound.

AND

PS_ADD_SCORECARD_RV 'SWM Mid Year Report', 'CWS_Conv_SWM_Mid_Year_Report', null
GO
Msg 102, Level 15, State 1, Procedure CWS_Conv_SWM_Mid_Year_Report, Line 1
Incorrect syntax near 'PORTFOLIO_ID'.

The error varies, depending upon the columns in the scorecard.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use PS_ADD_SCORECARD_RV.

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