FBL Upload Date Formats Are Not Consistent (Doc ID 2022781.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.9.2.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Goal

FBL upload date formats are not consistent.

Created few custom fields with date format.
Trying to upload data for leads and opportunity, while loading leads data , gave mm/dd/yyyy format for date field types and load successful.

for opportunity:
the same (mm/dd/yyyy) date format using FBL is error out saying its not in the format (dd/mm/yyyy).

1. So would like to know what standard date format is accepted by OSC, when a custom field of type date is created.
2. Why FBL is showing error even when gave mm/dd/yyyy format.

Provide a standard format across all objects, for FBL.
 

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