Retail Price Management (MOSC)

MOSC Banner

Records for both(zone and store) are getting created in 'RPM_PROMO_ITEM_LOC_EXPL' table when the pro

edited Jul 15, 2016 5:01AM in Retail Price Management (MOSC) 5 commentsAnswered

I have doubt  how data been getting rolled up in rpm_promo_item_loc_expl and rpm_future_retail.Can anyone explain what is the logic behind the below Scenario?

Scenario 1:

1.Create one Zone.

2.Add two location.

3.Create promotion at zone level.

4.Approve it

5.RPM_PROMO_ITEM_LOC_EXPL and RPM_FUTURE_RETAIL has location level information as well as zone level.

Why both(Zone and Store) the records are getting created in rpm_promo_item_loc_expl and rpm_promo_future_retail tables.

Scenario 2:

1.Create One Zone

2.Add three location

3.Create Promotion at 2 location

4.Approve it

5. Store level information records are creating in

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center