My Oracle Support Banner

Fixed Price Multi-Buy Promotion Created via Injector using the Item List causes conflict (Doc ID 2603590.1)

Last updated on APRIL 14, 2021

Applies to:

Oracle Retail Price Management - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to create fixed Price Multi-Buy Promotion Created via Injector using the Item List (BuyList) causes conflict during approval process the following conflict error occurs as "selling_uom_not_unique".

Steps To Reproduce:

  1. Create Stage data in RPM_STAGE_MULTIBUY_HEADER, RPM_STAGE_MULTIBUY_BUYLIST and RPM_STAGE_MULTIBUY_RWDLIST for Multi-Buy Fixed Price complex promotion eg. "Buy 3 for 100 USD" with Auto-Approval as 1.
  2. Maintain RPM_STAGE_MULTIBUY_RWDLIST.CHANGE_SELLING_UOM as NULL.
  3. Run the Injector Batch and Observe that Promotion is created in system but failed to approve and goes in Conflict check with RPM_CON_CHECK_ERR.MESSAGE_KEY as "selling_uom_not_unique".

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
Cause
Solution
References


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