Question { IBM, 15582 }
Oracle Needs to raise Purchase Order Automatically when the
Item Quantity down in Inventory, without using min-max?
Answer
Without using Min-Max formula, its not possible, because if
we would not consider min-max formula, than how we decide,
that inventory is going down.
With using Min-Max formula, Please create a procedure and
schedule it as Concurrent Request. Procedure will check
following condition...
1) Inventory down or not..
2) If yes then Insert the desire data into purchase order
interface table.
3) Submit the Order Import Concurrent Request program.