Oracle Needs to raise Purchase Order Automatically when the
Item Quantity down in Inventory, without using min-max?
- 5 Answers
- 15581 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 15 Yes | 3 No |
Answer / pritesh
You can use the facility of Safety Stock and Mention the Qty to be maintained as min Qty. MRP will take care of these Qty and automatically create PR for the same in Inventory goes down below safety stock.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sandeep patel
This can be achieved through ADC(Automatic Document Creation)
Steps required :
1.Define an ITEM in the Otem Master with all the attributes of a Purchased Item.Under Purchasing Tab mention LIST PRICE of the item and Enable Use approved supplier.
2.Define Approved Supplier List for the Item.
3.Create a Blanket Purchase Agreement for the Item.
4.Assign Blanket Purchase Agreement to Approved Supplier List attributes
5.Define Sourcing rule.
6.Assign Sourcing rule to the Default Sourcing Assignment set.
When ever we are in need of stock create a Purchase Requisition and Approve it.We can find RELEASES create againist the item automatically
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / harirajaa
there is a concept called Sourcing rule, approved supplier list, can that come in any user instead of Min-Max planning, you can use the demand in MRP, even no need to check the inventory. Kindly let me know if i am wrong.
| Is This Answer Correct ? | 0 Yes | 9 No |
Where do we integrate the AR and OM?
IF user wants to ship the lines in single delivery when there are different delivery id created for a Sales order, then what process has to be followed
what is the difference between format trigger and action trigger?at what level can we write the format trigger frame or repeating frame or item?
At the time of PO receipt, how to change destination (One Inventory to Another Inventory) type ?
Pick and ship should be performed by application itself when i book the sales order.Is it possible in order management. I can do this by just using pick and ship action using transaction window but even i will not use transaction window also,Only i will book the sales order.Picking and shipping should be done by system automatically.
Where to find the ISO accounting entry details?
How to define vacation rules in Oracle Purchasing upon User Request?
What are the different types of RG Registers?
What is the Month End closing Process in INV, Purchasing and OrderManagement?
What is inter company Transaction and set ups?
What is the use of ADD to RECEIPT FILED in receipt localized? Then how to performing in SOURCE TYPE INTERNAL AND EXTERNAL?
Oracle Needs to raise Purchase Order Automatically when the Item Quantity down in Inventory, without using min-max?
Oracle Apps Technical 
