Fusion OTBI - Date Field Null - In Analysis - Display Output 0--0

(Doc ID 2280792.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Fusion Purchasing Cloud Service - Version and later
Oracle Fusion Application Toolkit Cloud Service - Version and later
Information in this document applies to any platform.


For some of the date fields value is being displayed as 0-0 when actual value is Null.

Steps to Reproduce:

1) Create any Analysis and include a date field in it.
2) In the date field > Column Properties > Data Format > 

            Update "Custom Date Format" = D-MMM-YYYY

3) Save and check the output


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