Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OTBI Analysis Export to CSV Missing Carriage Return Line feed for last row
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
Comments
-
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.
0