Oracle Needs to raise Purchase Order Automatically when the
Item Quantity down in Inventory, without using min-max?
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 |
If owner wants to self approve then what the set-ups required?
what is the purpose of item master organisations? can we define more than one item master?
We have 2 check boxes Purchase and purchasable in Purchase tab for Master Item attributes. What is the difference between them, and why can't we use make or buy if some one answers as we are purchasing from supplier we say purchasable....
3 Answers Cap Gemini, Jade Software,
Is it possible to create 5 levels of approval for sales order?
What are all the modules covered under SCM ?????? Will anybody explains me ??? Thanks in advance. Somu
How does Oracle apps come to know that entered order is back to back or Standard sales order if in both the cases item is ATO type?
I have approved purchase requisition and it's status is IN PROCESS and it will go next level they are also approved and WF notification has been approved and closed but still purchase requisition status is IN process.what is the reason? How can u resolve?this is the issue i faced in Oracle India.
pl explain diffent types of hirarchies available in purchasing . and i also needs main key points in R12 FOR mfg modules
New Item is manufactured and we can do internal transaction but this item would be ready for sale from August 1st. where do we update start date for this item to available in Sales order?
If customer is makes advance payment against to any SO, how to apply the amount while raising sales order in SO Form?
1 Answers Accenture, CSS Corp,
What is the use of INV-Receipts and PO-Reciepts,Just give me the Differences&When,At what Instances to use Them...?
what characters can i use in an item name(including special characters)???