| Concurrent Request - How to Create / Update schedules using a plsql program [message #280454] |
Tue, 13 November 2007 12:32  |
sammydude
Messages: 34
Registered: November 2007
|
Member |
|
|
Hi ,
In oracle apps => concurrent requests window we have the option to schedule a request and save the schedule also.
I have a requirement. By using a plsql script I have to create a schedule, attach it to a concurrent request so that it runs periodically. Also I should be able to update and cancel an existing schedule.
I have to create around 4 functions (create schedule, submit request, update schedule and cancel schedule). Can I use fnd_request package routines ? If yes, which ones ?
Pls suggest.
P.S : I tried to use Fnd_Request.Set_Repeat_Options. It creates a default release class on its own and so I am unable to specify a schedule name.
Thanks,
Sam
|
|
|
|
| Re: Concurrent Request - How to Create / Update schedules using a plsql program [message #280915 is a reply to message #280454] |
Thu, 15 November 2007 03:08  |
tarmenel
Messages: 63
Registered: February 2007
Location: Israel
|
Member |
|
|
|
I think you're on the right track to submit the concurrent using fnd_request and I'm sure you can schedule it using the set repeat options. Just need to search a bit on metalink. As for the canceling and updating you may need to do this directly to the fnd_concurrent_requests table. Post some code so then we may be able to help further. If you find the answers it would also be great for future reference.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
