Retail Merchandising System (MOSC)

MOSC Banner

Incorrect unit_retail and selling_unit retail in item_loc table

edited Jul 1, 2014 5:00AM in Retail Merchandising System (MOSC) 1 commentAnswered

Dear Team,

We have one issue here where item_loc is getting updated with wrong unit_retail and selling_unit_retail as 999.99.

The value is default value and we are not sure from where it is coming.

This is not happening for all stores. for example : For a particular item: out of 1100 stores ,1000 stores are having correct unit_retail and selling_unit_retail,

whereas some 100 stores are having incorrect unit_retail as 999.99.

Where item_zone_price is correct in rpm_item_zone_price.

Firstly we doubt that may these stores are not in correct zone, that the reason they are getting a default value.

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