My Oracle Support Banner

Enhancement Request: Is It Possible To Have BI Report Results Not Add Extra Rows When Blob Fields Contain Carriage Return Characters? (Doc ID 2438688.1)

Last updated on JUNE 04, 2019

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

Running a report for P6 in BI Publisher and pulling the project notes, when saving to an Excel spreadsheet, an extra line is produced. This is causing formatting problems when the spreadsheet is opened.

EXPECTED BEHAVIOR

The data saved to Excel should produce the same results as when viewing the report in BI Publisher - no extra rows should be created.

STEPS

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

  1. Launch BI Publisher
  2. Select existing report / data model that has Project Notes blob field included
  3. Run the report in *xls format
  4. Observe the extra row at the top of each note

Cause

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
Symptoms
Cause
Solution
References


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