Introduction

Those who are from an EBS background have been accustomed to submitting an XMLP Report from SRS Window which gives us the privilege of using a custom Data Type Value set in a Concurrent Program Parameter where-in we can enforce end users to pass Date values in a specific format. It may be dd/mm/yyyy, mm/dd/yyyy, dd-mm-yyyy, dd-mon-yyyy or any other date format. In a standalone BI Publisher or even the same which is embedded within another application (say Oracle Fusion Application, for example) the default format which is used for any date type parameter is a Java Date Type parameter (MM-dd-yyyy). Business users however are used to using specific date formats applicable as per their regional settings, and as such, there is a genuine need of allowing other date type format too in the parameter. This article is intended to address the same specific issue, here we would try to demonstrate how we can change the default date format from a Java Format (MM-dd-yyyy) to any other format.

In this example we would demonstrate how to get the date value in say dd-MM-yyyy.

As a pre-requisite we would refer to one of the previous article which has a Date Type Parameter (pCalculationDate). We would try to change the Date format for the same parameter and try to understand the impact of the same. Also, we would have a look at the results too.

So now let’s try to check the below two screenshots and try to understand the same.

Date Format String

Each BI Publisher Parameters property section has the following properties for a Date Type Parameter:

We can see clearly that in the Date Format String has been changed to dd-MM-yyyy

And let-us see the results too:

Like we have used dd-MM-yyyy you may also use any other format like dd.MM.yyyy, dd/MM/yyyy

Do give a try and feel free to revert in case you face any issues.

Good Luck and have a nice day!

Ashish Harbhajanka

Add comment