Concurrent request scheduling from Backend
It’s quite an interesting way that’s used to implement concurrent request schedules in Oracle Applications. In this post I’ll describe how “Periodic” and “On Specific Day” type of schedules are stored in the Database and if you will be patient enough to read all the story, I’ll give you a query that can be used to report all the request schedules in the environment. I’ll pay attention to the repeating schedules only as requests submitted for one-time execution are not too interesting, basically, they use the fnd_concurrent_requests.requested_start_date field to store the time the request has to be executed. This field is used in repeating schedules to specify the time of next execution. There are just 2 normal types of repeating schedules. 1. Periodic - the request is submitted for execution in pre-defined intervals of specified number of months, weeks, days, hours or minutes. Defining a 'periodic' schedule 2. On...