My Oracle Support Banner

Date Format Is Different In Export To Excel Option (Doc ID 2596708.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

On : 2.7.0.1.0 version, BI - Billing

ACTUAL BEHAVIOR
---------------
Date format is different in Export to excel option on view bill screen.

Wrong format: 07/01/2019

EXPECTED BEHAVIOR
-----------------------
In excel sheet, date format should be the same as in view bill screen for all dates.

Correct Format: 01-07-2019

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Account context menu -> Go to View Bills;
2. Broadcast the bill and then broadcast a product;
3. Click 'Explore zone menu' and select 'Export to excel';
4. Check Excel file and notice that date format is different in excel sheet for some dates.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the correct date in the excel file generated.

Cause

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
Symptoms
Cause
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.