My Oracle Support Banner

Reporting View Generation Errors for PS_ADD_SCORECARD_RV: Incorrect Syntax, Identifier Not Found (Doc ID 1531583.1)

Last updated on JUNE 21, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.