Best Approach for creating Server Agent Process

Hi All,

We are developing web application on Oracle DB 10g and Oracle Apps Server (ADF) on RH Linux. We have requirement as follow :

Users from all locations will input orders via web. Then there should be a process run on server (by itself) to check for ANY newly created Orders, then check the stock availability & credit status of the customer, base on that, create Invoice for that Order.

So while users are doing Order entries, parallelly a process run a server to process their orders. After they are done, they can check the status of all the orders they have entered, whether it has become invoice or there is any stock or credit limit status.

What is the best approach to do this server side process ?

Thank you for your help,
xtanto Received on Thu Jun 12 2008 - 21:24:34 CDT