This content has been marked as final. Show 5 replies
You can insert records into po_headers_interface (with document_type_code=quotation) and in po_lines_interface.
And then run "Import price catalogs" request with appropriate parameters.
It will create quotes, create ASL, assign quote to the ASL, create SR and assign SR to the default sourcing rule assignment set.
You can also look at http://arunrathod.blogspot.com/2008/10/script-to-load-single-record-for-mrp.html
Hope this answers your question,
Thanks a lot I will have a look at it.
I prefer to use the API mentioned.
However this is in Oracle Manufactirung and we dont use that module instead I want to define them in Oracle Purchasing.
can I still do it in Purchasing using the same API.
Further as per the document there are 3 entities
01) Sourcing Rule/Bill of Distribution
02) Receiving Organization
03) Shipping Organization
Do I need to define all 3 in order to make it work?
Thanks and Regards,
You can use the API even if you don't use Mfg.
You have to define the sourcing rule
You need to enter shipping organization if the SR is obtaining material from another inventory org. Otherwise, you need to enter vendor details.
I believe you can leave receipt org id blank.
Hope this helps,
Thanks Sandeep for your feedback.