Scheduling of a concurrent program with constant From date and To date as sysdate
Hi,
We are on R12.2.4 and we have the below requirement:-
We want to schedule "Collect Revenue recognition" program with Start date as "01-Dec-2016" and End date as Sysdate. i.e. every day when the program runs From date should be constant '01-DEC-2016' and To date should be sysdate
I had created a Request set and included the above program as a child program and changed the default date for From date as Constant value of '01-DEC-2016' and for To date, i have used the below SQL query as default value
select fnd_date.date_to_displaydate(TRUNC(sysdate)) from dual