My Oracle Support Banner

Duplicate Records Created In PRICE_HIST Table, When The Same Item Is Deleted And Created Again (RMS Version 13.0.X) (Doc ID 989341.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Retail Merchandising System - Version 13.0.2 and later
Information in this document applies to any platform.


In version 13 of Retail Merchandising System (RMS), when a child item is deleted and later re-added (with the same item_id), PRICE_HIST table records duplicate entries for the child item with TRAN_TYPE of '0'. This results in Retail Price Management (RPM) batch failing.

Steps to recreate :
1. Create an item.
2. Create two child items for the item.
3. Assign two stores to the item.
4. Check the item_master table. The items are in 'A' status. Check the PRICE_HIST table.
5. Three records are created for each of the items - all with tran_type '0'.
6. Go to ITEM MASTER screen and delete one of the child items.
7. Run the DLYPRG batch. The item is deleted from the item_master table.
8. Check the PRICE_HIST table. Three more records are created for item which was deleted. This time, the tran_type is 99.
9. Go back to ITEM MASTER screen and create the same item (same ITEM_ID) again and add it as child item for the parent item.
10. Check PRICE_HIST table again. Three more records with TRAN_TYPE of 0 are created for the item.




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.