Missing Item Price History Records When Seeding Data For Store Item Price History On SIOCS (Doc ID 3013356.1)

Last updated on MARCH 28, 2024

Applies to:

Goal

On : 24.0 version, Standalone Data Seeding

Missing Item Price History records when seeding data for Store Item Price History on SIOCS when uploading via CSV.

Found an issue when seeding Store Item Price History on SIOSC Stage 24.0.101.1: There are multiple rows of data with the same ITEM_ID, STORE_ID, PRICE_TYPE and REGULAR_PRICE_CHANGE_ID, but different effective_date are missing.

If you check idls_store_item_price_hst, all csv records are loaded on this table but missing some records on item_price_history. You can check by running the queries below:

select * from idls_store_item_price_hst where item_id in (<ITEM_ID>) and store_id= <STORE_ID> order by item_id,EFFECTIVE_DATE
 
select * from item_price_history where item_id in (<ITEM_ID>) and store_id= <STORE_ID> order by item_id,EFFECTIVE_DATE

It shows that only the most recent item price history changes have been added to the item_price_history table.
 

Solution

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