Demantra Solutions - EBS (MOSC)

MOSC Banner

Inconsistency between mdp_matrix and location

edited Dec 11, 2012 4:42PM in Demantra Solutions - EBS (MOSC) 1 commentAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center