My Oracle Support Banner

Oracle Fusion BIP: How to change the date Format in OTBI analysis so that it keeps the formatting in BI Publisher Reporting. (Doc ID 2184776.1)

Last updated on JULY 22, 2024

Applies to:

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

Goal

On : 11.1.11.1.0 version, Technology Management - Reports/Analytics

Business Requirement:

 

You created a BI Publisher Data Model based on an Analysis data set.  Then you created a report based on this data model.

The date columns in the BI Analysis are formatted as 'dd/mm/yyyy'.

However, when when run the report in XML or CSV format, the dates are converted to 'yyyy-mm-dd' format.

Unfortunately, the RTF template is not used when the report is generated with CSV or XML format.

So how can you pass the 'dd/mm/yyyy' date format to your CSV or XML output file.

 

 

Solution

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
Goal
Solution
References


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