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


On : version, Technology Management - Reports/Analytics

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
instead of

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

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.

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.


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.