Here is my query ..
We are dealing with ATO items, sales order will be entered and WO line progressing will done. I can see reservation of work order to sales order demand. I have seen that SO demand and WO supply is well captured. While doing data collection, mentioned that reservation = Yes. Even done 'complete' refresh data collection. Now when I will open ASCP workbench, I can see SO demand, but I am not able to work order which is created by SO line progressing in supply pegging. It is showing different WO and new planned order to fulfill complete SO qty.
Please advise check points to check. FYI - I have seen date belongs to 'MSC_ST_RESERVATIONS', 'MSC_ST_SALES_ORDERS', 'MSC_ST_SUPPLIES'. But not able to see data belongs to my SO. so believe that data collection is not capturing reservation but captured SO and work order demand.
I can see SO demand in msc_sales_orders, having reservation_type = 3 and 1 for same SO line id.
But I am not able to see in msc_reservation and this might b reason behind it not showing WO-SO link in pegging tree.
Any suggestion further ?
Run 'Refresh Collection Snapshots' by specifying : Refresh Mode=Complete, Snapshot_name=MTL_DEMAND_SN
After refresh is completed, run targeted collection for sales orders and reservations.
See if you then have the recod in msc_reservations.
'Refresh Collection Snapshots' is completed for MTL_DEMAND_SN. I can see demand in MTL_RESERVATIONS_SN and MTL_DEMAND_SN. In MTL_RESERVATIONS_SN, I can see supply as work order which are created by SO line progressing. This is because of items from MTL_DEMAND_SN are ATO items and work order will be created by SO line progressing.
Then data collection is completed in target with SO and reservation is included. I can see SO demand in MSC_DEMANDS but not able to see work order supply order data in MSC_RESERVATIONS. but I can see the same in msc_supplies.
So I can see that snap shot is working fine and also plan is capturing supply/demand data. So I believe that some environmental variable is missing from me ie something wrong at plan option / some incorrect value to profile option.
To re confirm that I have already enabled net WIP and net reservation for our organization. so please suggest apart from it if I missed something..
Yes, this is also my thinking. 'Net reservation' from plan option enables to reserve onhand supply to SO demand. Otherwise, PO / WO supply is not considered or honored. But not sure. so have come across such situation ? any metalink doc foer guide line to me ?