SOCS - Duplicate Records In Pricing Screen On SOCS
(Doc ID 2977895.1)
Last updated on OCTOBER 06, 2023
Applies to:
Oracle Retail Store Operations Cloud Service - Version 23.1 to 23.2 [Release 23.1 to 23.2]Information in this document applies to any platform.
Symptoms
On : 23.1 version, LookUps
ACTUAL BEHAVIOR
---------------
When an item has a promotional event and a record of the same has moved to the ITEM_PRICE_HISTORY, the Item Look up > Pricing screen displays duplicate records for the Pricing event.
EXPECTED BEHAVIOR
-----------------------
Expect that the pricing event is only displayed once.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Data set up:
ITEM_PRICE
---------------------
"ID","STORE_ID","ITEM_ID","EFFECTIVE_DATE","END_DATE","PRICE_TYPE","STORE_REQUESTED","STATUS","PROMOTION_ID","PROMOTION_COMP_ID","MULTI_UNITS","MULTI_UNIT_RETAIL_CURRENCY","
"432503","79005","101150016","16-JUN-2023 00:00:00","23-JUN-2023 23:59:00","201","0","3","","","","","","","0","0","simple promo 061623","","","","","16-JUN-2023 00:04:25","","","","","96.775","MXN"
"428211","79005","101150016","12-JUN-2023 00:00:00","","202","0","3","","","","MXN","","","0","0","","","","","","12-JUN-2023 10:21:01","","","","","138.25","MXN","EA",""
ITEM_PRICE_HISTORY
-----------------------------------------
"ID","ITEM_PRICE_ID","STORE_ID","ITEM_ID","EFFECTIVE_DATE","END_DATE","PRICE_TYPE","PROMO_COMP_TYPE","MULTI_UNITS","MULTI_UNIT_RETAIL_CURRENCY","MULTI_UNIT_RETAIL","MULTI_UNIT_UOM
"196743","432503","79005","101150016","16-JUN-2023 00:00:00","23-JUN-2023 23:59:00","201","","","","","","0","","simple promo 061623","","","","0","16-JUN-2023 00:04:25","96.775","MXN","EA"
1. Login to SOCS
2. Select Tasks
3. Lookups >Item Lookup
4. Enter item id
5. Select Pricing
Expected: One Line per pricing event
Actual: Duplicate lines for promo pricing event
Due to this issue, users see duplicate lines for the same price event.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |