Opportunity Summary and List Reports Error: "Error - PMV-ERROR:ParameterValidator: Error :java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement"

(Doc ID 1527444.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Sales Intelligence - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


Cannot run Opportunity Summary and Opportunity List Report in Sales Manager Dashboard.


Error - PMV-ERROR:ParameterValidator: Error :java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement

Steps to Reproduce

  1. Responsibility: Sales Manager
  2. Navigation: Sales Manager Dashboard
  3. Select Reports under shortcuts
  4. Select Opportunity Summary OR Opportunity List Report 
  5. Error is displayed



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