My Oracle Support Banner

Fusion Applications OTBI : Expected Close Date timestamp formatting is not consistent between BI Answers and the Fusion Application dashboards (Doc ID 2057616.1)

Last updated on SEPTEMBER 15, 2020

Applies to:

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

Symptoms

On : 11.1.9.2.0 version, Technology Management - Reports/Analytics

ACTUAL BEHAVIOR
---------------
When an analysis is added to the Fusion Application the date/time formatting applied to the Expected Close Date field is not being applied and the time component is showing in the resultset

EXPECTED BEHAVIOR
-----------------------
The Expected Close Date should only show a date component in the resultset, it should have no time component displayed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create a new analysis against Sales - CRM Pipeline
2. select the Revenue.Expected Close Date
3. modify the format on the column to use the '[FMT:Date]' format mask

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot accurately interpret the results being returned from the Sales Stage Wise Date analysis.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.