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 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version and later
Information in this document applies to any platform.



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.


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


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


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.