Retail Merchandising System (MOSC)

MOSC Banner

Primary_supp_ind change, is it generate new row in price_hist?

edited Aug 7, 2015 6:19AM in Retail Merchandising System (MOSC) Question

Hello,

1. My first question about price_hist table. ORMA use this table as a datasource about Retail\Unit cost data...

RMS uses cost at item-location combination, unit_cost from primary supplier\location relationship.

When i try to change primary supplier, there is no new records in price hist. As result, RMS i have unit_cost from new primary supplier, ORMA still have old unit cost....

My question is, how it should work?

2. Data model says that unit_cost of item_supp_country and item_supp_country_loc should be the same where primary_loc_ind = Y

But when, i change primary_loc_ind from loc where unit_cost - 30, to loc where unit_cost - 10, item_supp_country.unit_cost still have 30...

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