My Oracle Support Banner

Daily Purge Is Not Deleting Item Records From PRICE_HIST Table. (Doc ID 801564.1)

Last updated on NOVEMBER 05, 2020

Applies to:

Oracle Retail Merchandising System - Version 12.0.9 to [Release 12.0]
Information in this document applies to any platform.


When dlyprg.pc runs, it does not remove PRICE_HIST records. Upon re-entry of the item, duplicate seed (TRAN_TYPE = '0') records are created. This causes the Retail Price Management (RPM) Price Batch to fail upon initial pricing of the item.

Steps To recreate:

  1. From rtkstrt,click items--> items
  2. Create parent and child item and approve it.
  3. Edit the child item and mark for deletion.
  4. Run the dlyprg batch program.
  5. Records with TRAN_TYPE 0 and 99 exists in PRICE_HIST table
  6. Edit the parent item and create the children with same item number which has been deleted.
  7. Check the duplicate records exists in PRICE_HIST table with  TRAN_TYPE = 0 for the same location which will cause the error while approving cost change in RPM system.


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.