oracle EBS R12 concurrent program Date Parameter with Time — oracle-tech

    Forum Stats

  • 3,681,514 Users
  • 2,238,028 Discussions
  • 7,831,260 Comments

Discussions

oracle EBS R12 concurrent program Date Parameter with Time

User179952User179952 Posts: 15 Blue Ribbon

Hi,


In Oracle EBS i am registering a concurrent program where there is a need for a date parameter with time is needed. So i am using fnd_standard_datetime as the value set and i am using Default Type: SQL Statement and Default Value as below.

SELECT TO_DATE(TO_CHAR(MAX(process_date),'DD-MON-YYYY')||'22:59:59','DD-MON-YYYY HH24:MI:SS')

FROM table.

Above sql query is returning the value as 10/16/2020 10:59:59 PM.

Problem is the time 10:59:59 PM is not defaulting when trying to submit the concurrent program. The default value is displaying 16-OCT-2020 00:00:00.

How would i display the value as 16-OCT-2020 10:59:59 PM

OR

16-OCT-2020 22:59:59.

Please suggest what am i missing.

Appreciate your help.


Thank you

Ashok

Sign In or Register to comment.