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 FEBRUARY 21, 2023
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.11.1.0 and laterInformation 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 |