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
-
Guru,
If you cannot find a solution with BI Answer, please use BIP as workaround. BIP will give you line feed (LF) for each of the line in the csv file.
Thanks,
Adam0 -
Good idea.
0