SOCS - Duplicate Records In Pricing Screen On SOCS (Doc ID 2977895.1)

Last updated on OCTOBER 06, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.