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.

Symptoms

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

Error 

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



 

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