My Oracle Support Banner

Multi-Buy Promotion Un-approval and Re-approval Causes Item Classification to Be Empty (Doc ID 1953864.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Retail Price Management - Version 14.0.1 to 14.0.2 [Release 14.0]
Oracle Retail Price Management - Version 14.1 to 14.1.2 [Release 14.1]
Information in this document applies to any platform.

Symptoms

When the 'buy' list (subclass level) in an approved multi-buy promotion is changed to be same as the 'get' list and re-approved, the ItemClassification file generated by RPMtoORPOSPublishExport.sh batch does not have a reference to the Target ID (get list) referenced in the PricingExtract file.


Steps to Recreate:

  1. Create a multi-buy promotion of type BuyNofXgetYatZ%off. Make sure to choose buy and get lists at subclass level.
  2. Approve the promotion.
  3. Unapprove the promotion (worksheet).
  4. Change buy list to be same as of get list.
  5. Re-approve the promotion.
  6. Run RPMtoORPOSPublishBatch.sh and notice that RPM_ORPOS_CMPLX_PROMO_PUBLISH table is populated.
  7. Run RPMtoORPOSPublishExport.sh, which generates ItemClassification file and PricingExtract file.
  8. Get the Target ID from PricingExtract file and notice that ItemClassification file does not have a reference to Target ID.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Release
 Patch
 Bug
 File Versions Affected
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.