Re: Concurrent Request Schedule

Good point. Check out Metalink note 221542.1. It contains some sample code for submitting request sets via pl/sql. Possibly the file delivery script could be modified to call something like this once the file has been successfully delivered? 

Chuck Edwards
Blue Gecko, Inc
http://www.bluegecko.net/oracle-apps-dba


On Feb 20, 2009, at 10:50 AM, Brian Matrose wrote:
This would be easy to do if it was a single concurrent request but its much more difficult with a request set. 

Brian Matrose
Information Technology Specialist 4
FIT Group
15 Computer Drive West
Albany, New York 12205
518-437-3532
From: ora-apps-dba-bounce@xxxxxxxxxxxxx [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx ] On Behalf Of Chuck Edwards 
Sent: Friday, February 20, 2009 1:46 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: Concurrent Request Schedule
It might be a good idea to leverage the script that places the file on the server to kick off the concurrent request set. After all, that script knows when the file is ready, so just have it kick off the concurrent program using CONCSUB as soon as it places the file. That way no one has to launch anything manually, and the file is processed as quickly as possible. 


Chuck Edwards
Blue Gecko, Inc
http://www.bluegecko.net/oracle-apps-dba


On Feb 20, 2009, at 10:31 AM, Brian Matrose wrote:


I have a question on concurrent requests.

Here is the scenario.
1. Everyday we receive a file from an outside company. We have a script that runs in the morning that grabs the file and places it on our Oracle Financials server for processing.
2. The financials users have a concurrent request set, that they want to schedule everyday to process the file.
If we can guarantee that the file is available at the same time every morning we have no problems.
Ex. We receive the file at 6:00 AM and transfer it to the Oracle Financials server and the Financials User schedules to run their concurrent request set each morning at 6:30.
Our problem occurs if for some reason we don’t receive the file until 6:45 AM or even later. We have suggested that the user schedule the request for every hour so that if we host the file late, the next running of the concurrent request would process it. Their issue is that they don’t want numerous concurrent requests filling up their view request screens because it would be too confusing. So my question is, is their any way to schedule a request set to run only until it completes successfully and than stop running until the next day. 

Thanks


Brian Matrose
Information Technology Specialist 4
FIT Group
15 Computer Drive West
Albany, New York 12205
518-437-3532
This e-mail transmission contains confidential information that is the property of the sender. If you are not the intended recipient, you are notified that any retention, disclosure, reproduction or distribution of the contents of this e-mail transmission, or the taking of any action in reliance thereon or pursuant thereto, is strictly prohibited. No warranty is given by NYSIF that this e-mail is free of viruses, interception or interference. NYSIF disclaims liability for any unauthorized opinion, representation, statement, offer or contract made by the sender on behalf of NYSIF. NYSIF's delegation of authorities, setting out who may make representations or contract on behalf of NYSIF, is available by contacting NYSIF at mailadm@xxxxxxxxx . Jurisdiction for all actions arising out of dealings with NYSIF shall lie only in a court of competent jurisdiction of the State of New York. 





_____________________________
This e-mail transmission contains confidential information that is the property of the sender. If you are not the intended recipient, you are notified that any retention, disclosure, reproduction or distribution of the contents of this e-mail transmission, or the taking of any action in reliance thereon or pursuant thereto, is strictly prohibited. No warranty is given by NYSIF that this e-mail is free of viruses, interception or interference. NYSIF disclaims liability for any unauthorized opinion, representation, statement, offer or contract made by the sender on behalf of NYSIF. NYSIF's delegation of authorities, setting out who may make representations or contract on behalf of NYSIF, is available by contacting NYSIF at mailadm@xxxxxxxxx . Jurisdiction for all actions arising out of dealings with NYSIF shall lie only in a court of competent jurisdiction of the State of New York. 





_____________________________

Other related posts: