My Oracle Support Banner

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:

Oracle Retail Enterprise Inventory Cloud Service - Version 24.0 and later
Information in this document applies to any platform.


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 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.


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

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