Export to Excel Option Looses Original Column Format in the Spreadsheet

(Doc ID 2308099.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.5.0.3.0 and later
Information in this document applies to any platform.

Symptoms

On RMB v2.5.0.3.0 against FW v4.3.0.1.0, export to Excel not working properly.

ACTUAL BEHAVIOR  
--------------------------------
On RMB UI, if data is stored with newline in a column, when export to excel is done, the data from one column moves to multiple column.

EXPECTED BEHAVIOR
--------------------------------------
Export to spreadsheet should be exact same as it shows up on UI.
This whole multi line string should be displayed in correct Column, not part of the string move to a different Column.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to the "Volume Accumulation Group" UI
2. Create a New Entity - Enter multi line description in VAG Description field
3. Save and a new transaction id added
4. Approve the transaction in Approve UI
5. Now from "Volume Accumulation Group" UI, use option 'Export to Excel'
6. Save the file and once open notice the column mismatch for the multi line texts

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the exported CSV file as a useful document.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms