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 MARCH 17, 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.


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 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 and notice that RPM_ORPOS_CMPLX_PROMO_PUBLISH table is populated.
  7. Run, 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.





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
 File Versions Affected

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