The Sales_type Field on TRAN_DATA Table Populates As 'P' Even for Regular Sales

(Doc ID 2132774.1)

Last updated on APRIL 11, 2018

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.


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