- 3,681,514 Users
- 2,238,028 Discussions
- 7,831,260 Comments
- 31 On-Premises Applications
- 29 E-Business Suite
- 1.5K Endeca Experience Management
- 1.4K Siebel
- 10.7K PeopleSoft Enterprise
- 164 On-Premises Infrastructure
- 45 Analytics Software
- 4 Application Development Software
- 1.7K Cloud Platform
- 700.3K Database Software
- 17.4K Enterprise Manager
- 1 Hardware
- 23 Infrastructure Software
- 13 Integration
- 16 Security Software
oracle EBS R12 concurrent program Date Parameter with Time
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')
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
Please suggest what am i missing.
Appreciate your help.