RE: Concurrent Request Schedule
- From: "Brian Matrose" <BMatrose@xxxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Fri, 20 Feb 2009 13:50:09 -0500
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@xxxxxxxxxx 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@xxxxxxxxxx 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: