My Oracle Support Banner

Export to Excel Option Looses Original Column Format in the Spreadsheet (Doc ID 2308099.1)

Last updated on JANUARY 11, 2021

Applies to:

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


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

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.

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.

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

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


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.