My Oracle Support Banner

Late Sale Is Processed With Incorrect Sales Type for a Clearance Item That Is Active (Doc ID 2109601.1)

Last updated on MARCH 10, 2019

Applies to:

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


The late sales transaction for a clearance item where transaction_date < clearance_effective_date -1 is posted as "C" sales type in TRAN_DATA  table.

Steps to Reproduce:

  1. Create a new item.
  2. Run the NEWITEMLOC batch and interface the item to RPM.
  3. Create a clearance for vdate+1.
  4. Approve the clearance.
  5. Run the PRICEEVENTEXECUTIONBATCH and PRICEEVENTEXECUTIONRMSBATCH and verify the clearance information is updated ITEM_LOC table.
  6. Create a posupld file with the item with sales_date or transaction_Date < clearance Effective date -1.
  7. Run the below batches and verify TRAN_DATA.
    1. UPLOADSALES_ALL.KSH (Process Multiple POSU Files).
    2. SALESPROCESS.KSH (Main Processing of Staged Sale/Return Transactions).


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.