Promo Creates Price_hist Tran_type 9 Record for Excluded Items/Locs but Not Tran_type 4

(Doc ID 2075412.1)

Last updated on APRIL 11, 2016

Applies to:

Oracle Retail Price Management - Version 13.1.7 and later
Information in this document applies to any platform.


In Oracle Retail Price Management (RPM) 13.1.7, tran_type 4 records are not being created for items or locations that are excluded from a promotion.  Since a tran_type 9 was created for the exclusions at the start of the promotion, we expect tran_type 4 to be created at the end of the promotion.

Steps to Reproduce:

  1. Create a promotion for a skulist and zone.
  2. Exclude an item from the promotion.
  3. Exclude a location from the promotion.
  4. Run PriceEventExecution (PEE) and PriceEventExecutionRMS (PEE RMS) batches.
  5. Note that excluded items and locations have tran_type 9 PRICE_HIST records with the price not changed from the previous price.
  6. Advance VDATE until close of promotion.  Again run PEE, PEE RMS.
  7. Note that all item/locs have tran_type 4 records for close of promotion EXCEPT the excluded items and locations.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms