Incorrect Date Format in Excel Sheet Generated Via WebADI (Doc ID 828253.1)

Last updated on MARCH 07, 2017

Applies to:

Oracle Web Applications Desktop Integrator - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

When exporting the data consisting of date fields via web ADI the date format is being exporting incorrectly.

Symptom :1

You query an item (item search) with a display format that contains dates. Export the data to
excel and you will see that the dates have changed.

Expect the dates have the correct format. 

The issue can be reproduced at will with the following steps:
1. Item search to query the item.
2. Click on Export all items.
3. Excel sheet will appear with the wrong format of the dates.

 

Symptom :2

When exporting the Salary Management data via web ADI the date format is being exporting incorrectly. For Example in Oracle the date is 01-MAR-2008, but in the excel file this is being converted to 03-JAN-2008.

Expect the dates have the correct format.

The issue can be reproduced at will with the following steps:

1. Login as UK Simply Super HRMS Manager
2. Navigate to Enter and Maintain > Salary Management
3. In Query Mode Enter > Annual Salary in the Salary Basis Field > Query
4, Click on Export Data Icon
5. Select Excel 2000
6. Select <Customer> Salary Review
7. Open Spreadsheet
8. Enable Macros

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms