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 188.8.131.52.0 and later
Information in this document applies to any platform.
On RMB v184.108.40.206.0 against FW v220.127.116.11, 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?
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