Demantra Solutions - EBS (MOSC)

MOSC Banner

How to synchronize the level Id's in MDP_MATRIX with Hierarchy changes to Items or Locations

edited Sep 8, 2014 3:55AM in Demantra Solutions - EBS (MOSC) 8 commentsAnswered

Hi,

In MDP_MATRIX table we have De-normalized list of all the location hierarchy id's and Item Hierarchy ids for a particular item and location combination.  We have a situation where there are some hierarchy changes (not levels but members re-alignment taking place). With this we are going to get the latest hierarchy data for items and locations (item and location at lowest level remains same, they are remapped to new levels). Now once we load it, the item hierarchy tables and location hierarchy tables are reflected with the changes, but the mdp_matrix is still pointing to old id's (id's that are

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