DM_SITE_CODE is null in T_SRC_SALES_TMPL after model upgrade
Hi All,
We have upgraded our model from Weekly to Monthly system. We have hit a issue while collecting shipment/booking history from EBS. The collections complete normally without any error but we cannot see the DM_SITE _CODE in T_SRC_SALES_TMPL.
We are seeing that the DM_SITE_CODE has the values initially but later the DM_SITE CODE is null in the Table T_SRC_SALES_TMPL when 'Populate Staging Table' completes.
Interestingly _we can see the DM_SITE_CODE in T_SRC_LOC_TMPL.
Not sure where to start debugging. Any ideas why the DM_SITE_CODE should become null.?