Check given item is existing in the T_ep_item, if item is not existing then add this item to the NPI as below and Save- User: t_sharma/welcome123
Step 2) Run shipment and booking collection for the future one week (Means we are not loading history and all, downloading item only) Step4: Check the item in the Demantra Staging table.
Select * from T_SRC_ITEM_TMPL;
Run the WF XX IFFCO Update Prod Sub Group -ITEM TMPL ----WF---2198 -- no need to take denorm back up Step5: Run the below procedure to publish the item in demantra or trigger 2336 workflow which has 2 steps. Step1-Replace Apostrophe procedure, Step 2 – EP_LOAD_ITEMS Procedure. OR Exec Ep_load_items;
Sql script to run Ep_load_items;
Begin Ep_load_items; End;
Step6: Check item in Demantra level table
select * from t_ep_item where item = '<Item Number>';
Update Unit of Measure of the item checking it in EBS Inventory. (Physical Attributes)
merge into dm.t_ep_item a
using (
select item_name,unit_weight from msc.msc_system_items where item_name in
(
select item from dm.t_ep_item
where last_update_Date>= sysdate-1
) group by item_name,unit_weight
) b on ( a.item=b.item_name ) when matched then update set a.ebsuom117=b.unit_weight, --UNIT_WEIGHT a.ebsuom128=(b.unit_weight/1000); -- UNIT_WEIGHT/1000 commit;
Combination Creation Step1: Demand Planner Tool -> Member Management.
A New window will open
Now from the right hand window click all left most Items like ‘Demand Class’ ,’Item’,’manufacturer,’Unused’ Step2: Now click on the ‘Filter’ Button ‘ Double click on the ‘Item’ yellow box. All the items will appear in the left bottom window. Now Double click on ‘Description’. It will sort the Item Code. Now select your target item and push it to the right. If you need to select multiple Items, select multiple items and push it to the right. Now click on ‘OK’. Now you’ll back to previous window. Step3: Now click on the Show Members button, Then ‘Demand Class Hierarchy ‘ ‘Item Hierarchy’ , ‘Manufacturer Hierarchy’ and ‘Unused Hierarchy’ will be pushed to the right window. Now select all the check boxes.
Step4: And click on the “Link to Location Button.
Step5: Now Location hierarchy will appear at the left window. Now click left most hierarchy like ‘general Location attribute 8’ ,’Organization’, ’site’, ’sales channel’. ‘Terrirtory’ and ‘Territory Retailer’. Now click on ‘Filter’.
Step6 In the Filter , since we need to create the combination at the Operating Unit , Choose operating Unit and double click on it. All the operating Unit will be listed in the bottom window. Now choose the target and push to Right. And then Click OK , you’ll be returned to previous window.
Step7: Now click on the ‘Show Members’ button and all the hierarchy will be pushed to left window. Now select all the check box of these 6 hierarchies. Step8: Now you are ready to create the combination. Now click on Create Combination button. Confirm it. Depending on the number of combinations it will take some time.
Step9: Once ‘Create Combination is completed, now click on ‘Insert Values’.
Step10: Confirm and after some time it will be completed.
