Discrepancies Observed In The Format Of Date Columns In Export Files

(Doc ID 2250895.1)

Last updated on APRIL 02, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

We need to send data extracts for Accounts, Lead, Opportunity, Contact, Product, Employee Resource,etc to data warehouse. As per their data architecture, they need the date columns to be having a specific format.
Expected formats are as below:-
1. YYYY-MM-DD
2. YYYY- M-DD
3. DD.MM.YYYY and a few others.
On a sampling basis, we tried taking extracts by selecting the available format from the Date format drop down. On setting it to YYYY-MM-DD from the drop down, the generated extract contained data in the format M/DD/YYYY. Not only are the parameters represented in a different format but also the separators are not the same. Instead of "-", "/" is present in the data extract. This occurs in the case of other options available within that drop down too.
 

Solution

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