My Oracle Support Banner

Fusion BI Publisher - How To Set A Date Format In The Pivot Table Header In BI Publisher (Doc ID 2375623.1)

Last updated on MARCH 20, 2018

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Technology Management - Reports/Analytics

ACTUAL BEHAVIOR
---------------
How to set a date format in the pivot table header in BI Publisher

When designing a pivot table having a date column as a header, in the right frame or in the Header tab there is no option for the Date formatting.
So the date appears in the XML format
e.g.
2018-03-17T00:00:00.000+00:00
instead of
17/03/2018



EXPECTED BEHAVIOR
-----------------------
User should be able to format the date in the BIP layout screen

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. edit the layout of a template
2. create a pivot table
3. notice you cannot format the column data in the the BIP page layout editor --> pivot table header, or in the left navigation "Properties" area.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot format the date header on a pivot table.  This leads to a difficult to read, messy report layout.

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!


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