My Oracle Support Banner

Spaces In RMS Coupon Barcode creating duplicate entries in Retail Insight Application (Doc ID 2321679.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.


Spaces in Coupon Barcode impacting Retail Insight(RI).

Encountered an issue where spaces in the Coupon Barcode resulted in dual entries being created in RI for the same coupon bar code.


 Steps to Reproduce:

  1. Login to Application and Navigate to Tasks - > Price - > create coupon.
  2. Create the coupon with trail spaces in the barcode.
  3. Check the data in the table POS_COUPON_HEAD.Observe that spaces are still exist.
  4. Create a RESA Sales transaction for this barcode without trailing space. 
  5. During integration of sales to RI , the coupon from ReSA did not match the coupon in POS_COUPON_HEAD, thus 2 coupon reference numbers were created in RI.
  6. One interfaced from RMS POS_COUPON_HEAD (with space) and another auto generated due to ReSA Sales Transaction (without space).
  7. This led to data corruption in RI, coupon details could not be viewed and the sales could not be associated to the Coupon.



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.