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 laterInformation in this document applies to any platform.
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
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
Goal |
Solution |
References |