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 11.1.11.1.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

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

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