My Oracle Support Banner

Clearance Sales Showing As Regular Sales In TRAN_DATA_HISTORY Table (Doc ID 2427993.1)

Last updated on MARCH 05, 2019

Applies to:

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


Clearance sales showing as regular sales, For the majority of stores in the RMS clearances sales are showing up as regular priced sales (sales_type=R instead of C) in TRAN_DATA_HISTORY.

Steps to re-create:
1. Create an item and range it to a location.
2. Place the item for Clearance on the same day. Notice that price_hist has entries for both tran type 0 and 8.
3. Upload a Sale data for this item.
4. Notice that when an item is Clearance, sales_type is posted as Regular than Clearance.




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.