Re: Concurrent Request Schedule
- From: Chuck Edwards <chuck@xxxxxxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Fri, 20 Feb 2009 10:46:07 -0800
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.
_____________________________
Other related posts: