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

Last updated on MARCH 22, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
When a project ID contains a trailing space ("Example "), the report returns blank output.

EXPECTED BEHAVIOR
-----------------------
The project data still shows in the report.

STEPS
-----------------------
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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get report data from projects that contain a trailing space.

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