Oracle Apps Version - 18.104.22.168
Mfg - Discreate manufacturing module along with P2P and OTC..No Projects Module.
Soft Pegging enabled on Items..
we have created a SQL to link SO and PO using MRP_Full_Pegging Table,what are issues you see with this logic..would it always give me correct mapping between SO and PO
msd.mps_transaction_id = mgr.DISPOSITION_ID
and msd.inventory_item_id = mgr.inventory_item_id
and mtl.inventory_item_id = mgr.inventory_item_id
and msd.source_sales_order_Id = mso.sales_order_id
and msd.organization_id = XXX -- pl use you inv org id
and poll.po_header_id = pohll.po_header_id
and mr.inventory_item_id = mtl.inventory_item_id
and mr.compile_designator like '%XXX%' -- pl use MRP plan name
and rownum <100 -- just to limit result set
Order By ohll.order_number desc;
Appreciate your feedback and inputs to make necessary corrections to make it accurate and complete.
First of all - we appreciate that you have spent the effort to write a query and then are asking for feedback instead of simply
* "How do I do this? Please reply asap".*
1) I don't see any outer joins. If a sales order does not have a PO created yet, the sales order won't show up in your query.
2)ASCP has msc_full_pegging that is useful to join SO and PO. MRP has mrp_full_pegging. Can you try to use that? Use it to join mgr and mr.
Hope this helps,
Yes Sandeep,i can modify SQL to use full pegging table.thank you.
But the PO and SO are losely coupled right..lets take one example..support there are 10 SO's and demand for Item A is 100 ..each SO demand is 10..means there would be 10 PR creation after running the MRP..
Buyer after looking at all the 10 requisitions/PR's for same ItemA,he might have converted only 1 PR and modify qty to 100..in that case rest of 9 PR's are cancelled.So how do i map PO to cancelled PR's SO's??
I am just a beginner..new to MRP..just trying to build pegging report.
Yes - the mrp pegging is loose and transient (i.e. it may differ from one mrp run to the next)
The report you have will be only as accurate as the last plan run.
In your case, after 9 PR are cancelled and 1 is changed to 100, you will run another MRP plan next day.
And you will run the report and you will see that the 10 SO are pegged to one PR.
Hope this answers your question
Independent Techno-functional Consultant
I tried writing the query to find the supply and demand details in ASCP Planning.
In our scenario we created a sales order '5110416.AT PROJECT.ORDER ENTRY(6.1)' and launch the plan. It has created the plan order and after releasing it has created the internal requisition and then Internal sales order. But the supply sales order number is not populated in order_number column of msc_supplies.
Please help me if I am missing some thing. Just for your info I have run the plan again and then also its not updated. Below is the query which I have written. This is very critical for me. Please advice.
AND MD.ORDER_NUMBER='5110416.AT PROJECT.ORDER ENTRY(6.1)'
Thanks in advance.