Synchronize problem between tables
Hi all,
glad to know this community. we've found problems regarding to table synchronizing between table item_zone_price, item_loc, price_hist, as_itm_rtl_str@simds (table in RSIM DB), price_susp_head and price_susp_detail (other tables may be influenced) with field Unit_retail.
below are the list of the investigated case :
1. in item_zone_price for item : "12442056" zone_id : 1 showing "79,900" as unit_retail and selling_unit_retail
2. in item_loc for item : "12442056" we found only 1 record showing "79,900" as unit_retail which loc_type is W (warehouse), the other record showing "75,900" as unit_retail with loc_type is S(Store)
glad to know this community. we've found problems regarding to table synchronizing between table item_zone_price, item_loc, price_hist, as_itm_rtl_str@simds (table in RSIM DB), price_susp_head and price_susp_detail (other tables may be influenced) with field Unit_retail.
below are the list of the investigated case :
1. in item_zone_price for item : "12442056" zone_id : 1 showing "79,900" as unit_retail and selling_unit_retail
2. in item_loc for item : "12442056" we found only 1 record showing "79,900" as unit_retail which loc_type is W (warehouse), the other record showing "75,900" as unit_retail with loc_type is S(Store)
0