Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Scheduling of a concurrent program with constant From date and To date as sysdate

edited Aug 17, 2018 9:23AM in Core Concurrent Processing - EBS (MOSC) 52 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center