OTBI Analysis Export to CSV Missing Carriage Return Line feed for last row — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI Analysis Export to CSV Missing Carriage Return Line feed for last row

Submitted
2
Views
1
Comments
User_FXROD
User_FXROD Rank 1 - Community Starter
edited May 8, 2025 10:28PM in Oracle Transactional Business Intelligence Idea Lab

Organization Name

McAfee, LLC

Description

When exporting an OTBI BI Answers client payroll Analysis result to CSV, the last row in the Analysis result does not contain a carriage return character. This causes the McAfee Payroll system to fail, not allowing Incentive compensation commissions to be paid. 

On researching MOS we have found an OBIEE 12C Bug (28389680) that has been open since July 2018, that appears to be related. The client environment OTBI version is:

Is there any workaround in OTBI itself?

 


 

Use Case and Business Need

McAfee Payroll  system is expecting an CRLF for all csv files imported as part of monthly payroll.

This is a critical item that needs to be corrected in preparation for the Fusion Incentive Compensation go live implementation

More details

Guru - Thanks for reporting this issue. We'll research it.  - Greg

Original Idea Number: d4f12cf615

1
Up
1 votes

Submitted · Last Updated

Comments

  • Peter Bealls
    Peter Bealls Rank 1 - Community Starter

    I support this idea. We have middleware that works of windows not unix and is expecting the CRLF after each row. Currently reports only have LF. This cannot seem to be changed in the options for the OTBI report template.