Forum Stats

  • 3,840,297 Users
  • 2,262,582 Discussions
  • 7,901,203 Comments

Discussions

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

SDhanush
SDhanush Member Posts: 6
edited Jan 31, 2018 1:13AM in Developer Solutions

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

Answers

  • Jstanley-Oracle
    Jstanley-Oracle Member Posts: 15 Employee
    edited May 25, 2017 8:58PM

    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
    Kumar Nandan-Oracle Member Posts: 1 Employee
    edited Jan 31, 2018 1:13AM

    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