My Oracle Support Banner

Vendor Funded Promotions (POSUPLD.PC) Books Sales Under Wrong Sales_type in RMS (Doc ID 2241201.1)

Last updated on AUGUST 25, 2022

Applies to:

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


Find that POSUPLD.PC batch books sales under wrong sales_type. This issue occurs every time when there are multiple tran_type entries on same action_date in PRICE_HIST (for example - tran_type 4 and 8 entries with same action_date).

Steps To Recreate:

  1. Have an item/loc where clearance and promotion both are active and both are going to end on same date. (In this case: Promotion DETAIL_END_DATE = 4th OCT 2015 and Clearance RESET_DATE = 5 Oct 2015).
  2. On 4th nightly batch, we get two price_hist entries one tran_type 4 and other tran_type 8 with action date as '5-OCT-15'.
  3. Now post a sale by POSUPLD.
  4. Notice the sale has been booked as Clearance sale however the item is neither on Clearance nor on Promotion.


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.