My Oracle Support Banner

Reports Fail if Project ID Field Has a Trailing Space (Doc ID 2244466.1)

Last updated on APRIL 06, 2020

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 a project ID contains a trailing space ("Example "), the report returns blank output.

The project data still shows in the report.

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

  1. Log in to BI Publisher
  2. Browse to Catalog
  3. Select and open the report
  4. Use the search feature to select a Project ID that contains trailing spaces and select Apply
    1. If the project id has no trailing space, the report comes back with data. If the Project ID does have a trailing space, it comes back with no data. No errors are issued.
  5. Go into P6, update the Project ID to remove the trailing blank.
  6. Republish the project.
  7. Go back into BI Publisher and run the report
  8. Use the search feature to select the Project ID and select Apply.
    1. Report produces data.


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.