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

Last updated on APRIL 27, 2023

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.

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

Applies to:

Goal

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!