Duplicate Target Id Created when Item and Dept Overlap on Coupon

(Doc ID 2032152.1)

Last updated on AUGUST 17, 2016

Applies to:

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


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

When creating a coupon, the front end screens allow the user to add both specific items and entire departments.  When these overlap, duplicate records are generated in the PricingExtractCoupon.xml file for ORPOS. Only one record should exist for the item in PricingExtractCoupon.xml

Steps to Recreate:

  1. Create item level coupon
  2. Add items from a specific dept
  3. Add department level inclusion for the above item's department
  4. Save the above
  5. Run Orposcouponitemdnld.sql/batch_orpos_extract.ksh
  6. Notice the duplication in PricingExtractCoupon.xml


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