My Oracle Support Banner

The Sales_type Field on TRAN_DATA Table Populates As 'P' Even for Regular Sales (Doc ID 2132774.1)

Last updated on MARCH 13, 2019

Applies to:

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


The sales record, sales_type on TRAN_DATA table, with regular sales is populated as P (Promotion).

  1. Create items in RMS.
  2. Range the items to a store.
  3. Run Oracle Retail Price Management (RPM) newItemLocBatch.
  4. Create a emergency promo which starts and ends on the same day for the item.
  5. Advance vdate by 1
  6. Run RPM
  7. Run RPM
  8. Advance vdate by 1.
  9. Upload regular sales transaction for items.
  10. Note that the sales_type on TRAN_DATA table is populated as 'P' even for regular sales.


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.