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

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

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.



Changes

 

Cause

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