Inconsistency between mdp_matrix and location
We updated several columns in T_SRC_LOC_TMPL and T_SRC_ITEM_TMPL and ran EP_LOAD_MAIN procedure.
After EP_LOAD_MAIN ends, we can see the following:
- Catalog tables (T_EP_LS1, T_EP_LS2, T_EP_LS3) have been updated with the new values
- LOCATION table columns (t_ep_ls1_ep_id, t_ep_ls2_ep_id, t_ep_ls3_ep_id) have been updated with the new values
- MDP_MATRIX table columns (t_ep_ls1_ep_id, t_ep_ls2_ep_id, t_ep_ls3_ep_id) have not been updated
For the same location_id, the columns (t_ep_ls1_ep_id, t_ep_ls2_ep_id, t_ep_ls3_ep_id) are different between LOCATION and MDP_MATRIX tables, which is inconsistent.
0