This content has been marked as final. Show 8 replies
The MSC_ST tables are only populated during collections. After the ODS load they are purged.
You would need to check msc_sales_orders / msc_reservations / msc_demands / msc_supplies
Please check if chose 'Yes' for Net reservations, wip jobs during collections.
Also, the ASCP plan should have the net reservations, net wip jobs checked.
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 ?
I have selected 'Net reservation' and 'Net WIP' from Plan option. Still I having this problem. So pls advise ..
Thanks / Dipak
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..
one thing to bear in mind is that ASCP supports only Sales Order Reservations, it does not support work order reservations (or any other reservation type for that matter)
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 ?