Date type parameter in Cloud SAAS ESS Job, conversion to different format in the xml output

SDhanush

Hello Team

In an ESS Job, I have a requirement to enter the Date type parameter as (dd/mm/yyyy), but in the xml output I get this value converted to below format automatically, please help

<p_date> 0029-09-05T00:00:00.000+00:00 <p_date>

for eg, if I enter the parameter value as 24/03/2017 in the xml tag, it gets converted to below different format

<p_date> 0029-09-05T00:00:00.000+00:00 <p_date>

This is in Cloud Release, SAAS, application with Version : Fusion R12.

Please Help me on this issue   

Regards

Dhanush

Jstanley-Oracle

Hi Dhanush,

I'm sorry nobody has replied earlier.

This question pertains to developing with Oracle FA Cloud services. You'll find more people who can answer it in the Community, or one of its sub-communities dedicated to the individual services.

Kumar Nandan-Oracle

You can try below approach :

In your data model, have parameter of type string instead of date and then use this parameter in query using canonical function something like this:

fnd_date.canonical_to_date(:effective_date) between effective_start_date and effective_end_date