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