My Oracle Support Banner

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 JUNE 07, 2021

Applies to:

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


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

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: Invalid parameters requested.

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

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)


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

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