My Oracle Support Banner

Export To Excel from ORMB Looses Some Format (Doc ID 2779395.1)

Last updated on JUNE 07, 2021

Applies to:

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

Goal

On RMB v2.6.0.1.0 against FW v4.3.0.6, when I export data from RMB UI to Excel, format shown on screen is getting dropped when data is displayed in Excel sheet.
Followings are the example of this format mismatch:

- 00000053001192 exports to excel as 53001192. Leading zeros are dropped.
- 686561560945 exports to excel in scientific format 6.86562E+11.
- 2017‑05‑18 exports to excel as 5/18/2017.
- Number 16.20 on screen shows 16.2 on excel.

How to display them as is in Excel?

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.