Error: "Invalid Parameters Requested" and P6 Report Fails When Selecting Code Values That Contain a Comma in a Parameter (Doc ID 2256731.1)

Last updated on JULY 19, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.4.0.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 8.4.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run reports in P6 Web, the following error occurs.

ERRORS
P6 On Screen Error:
"Errors have been encountered while running the report. To resolve, contact your administrator."

P6 Log Error:
PublicReportService::generateReport for reportAbsolutePath [/P6Reports/<report path>/<report name>] failed: due to oracle.xdo.server.ServerException: oracle.xdo.servlet.data.DataException: Invalid parameters requested.

BI Publisher Log Error:
Illegal parameter value: <parameter>=<value before the comma>

STEPS TO DUPLICATE
The issue can be reproduced at will with the following steps:

  1. Create a code (Project, Resource, or any type of Activity Code) with a comma in the name (Example: "Who, What")
  2. Assign the code (Project Code to a Project / Resource Code to a Resource, assign the Resource to an Activity under a Project / Activity Codes to an Activity under a Project)
  3. Publish all Global Scheduled Services and the Project containing the code assignment
  4. Run a report using the code as a parameter selection from P6 Reports
  5. View the P6 log "Invalid parameters requested'
  6. View the BI Publisher log "Illegal parameter value" (Example: Illegal parameter value: p_res_code=Who)

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