|
Re: plz tell me the complete details that how to create workflow process examine ny database table?? [message #110795 is a reply to message #109805] |
Thu, 10 March 2005 06:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
adragnes
Messages: 241 Registered: February 2005 Location: Oslo, Norway
|
Senior Member |
|
|
It is hard to answer this as you ask for so much and are so vague on the details. Complete details you will not get unless you actually want to pay someone for doing your work for you. ![Wink](images/smiley_icons/icon_wink.gif)
However, I can point you in the right direction. What you want to achieve might actually be easier to achieve using Oracle Alerts. See the Oracle Alerts User's Guide for details. From the the user's guide:
Quote: |
Oracle Alert facilitates the flow of information within your organization by letting you create entities called alerts to monitor your business information and to notify you of the information you want. You can define one of two types of alerts: an event alert or a periodic alert.
|
If you want to use Workflow since you want to do more than just send a simple email on a periodic basis if certain conditions are satisfied, then you would have to create a concurrent program that starts your new workflow when certain conditions are met and run it on a periodic basis.
See
- the Oracle Applications System Administrator's Guide , chapter Coding Oracle Tools Concurrent Programs for how to create concurrent programs;
- the Oracle Workflow Developer's Guide for how to create the new workflow; and
- the Oracle Workflow API Reference, the chapter on the Workflow Engine APIs for how to create a workflow item, to start a process in it and how to set values for item attributes.
Good luck!
--
Aleksander Dragnes
|
|
|