OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Creating and Scheduling Request Sets for AP weekly jobs

Home » Applications » Oracle Fusion Apps & E-Business Suite » Creating and Scheduling Request Sets for AP weekly jobs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating and Scheduling Request Sets for AP weekly jobs [message #140224]

Sun, 02 October 2005 22:38

sambireddyn
Messages: 48
Registered: May 2005
Location: Andhra Pradesh

Member

Hi

I am trying to create several AP jobs to run in a request set and schedule it . The problem I am having is that a couple of the jobs require a 'From Accounting Date' to be entered each time the job is run, (it also requires a 'To Accounting Date' parameter). Since we want this to be automated, how can this date parameter be updated systematically. It is for the AP job "Posted Invoice Register" and "Posted Payment Register".

Any suggestions/help would be appreciated.

Thanks,
SambiReddy.

Report message to a moderator

Re: Creating and Scheduling Request Sets for AP weekly jobs [message #140250 is a reply to message #140224]

Mon, 03 October 2005 04:01

manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC

Senior Member

You can take help of checkbox "Increment Date Parameter Each Run" to increment Accounting date. But this is very generic answer. How often you want to run this concurrrent program? Based on that answer may be different.

Report message to a moderator

Re: Creating and Scheduling Request Sets for AP weekly jobs [message #140261 is a reply to message #140224]

Mon, 03 October 2005 05:03

sambireddyn
Messages: 48
Registered: May 2005
Location: Andhra Pradesh

Member

Hi manwadkar

Thanks for your reply,
I want to schedule it for every week.
What can be done to do so?
Your help will be appreciated.

Thanks,
SambiReddy

Report message to a moderator

Re: Creating and Scheduling Request Sets for AP weekly jobs [message #140514 is a reply to message #140261]

Tue, 04 October 2005 09:54

mchittib
Messages: 87
Registered: September 2005

Member

to_date := 'select to_char(sysdate,'DD-MON-YY') from dual';
result := FND_REQUEST.SET_OPTIONS (’YES’);
result := FND_REQUEST.SET_REPEAT_OPTIONS (’10:00’);//whenever u want to schedule it(10:00 am scheduled everyday)
req_id := FND_REQUEST.SUBMIT_REQUEST (’CUS’,
’CUSPOST’, ’Custom Posting’,
’01-SEP-05 00:00:00’, FALSE,
... args(to_date etc) ...);

Report message to a moderator

Previous Topic:	Getting started
Next Topic:	11.10 What's New

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 09 04:40:16 CDT 2024