Oracle Retail Price Management (RPM) – Understanding Conflict Checking Process and Rules

Welcome again Oracle Retail fans. This article is the continuation of our parent article on RPM (RPM – Deep Dive Tutorial). In this article, we are going to talk in-depth about RPM Conflict Checking processing, various rules applied and validated and also their impacts. This article should give you one view of all details which is normally scattered in various RPM product documents. 

Conflict Check Overview

Conflict checking is done in RPM to ensure that rules are followed to avert potential pricing problems. Examples of conflict checks include ensuring that a given item/location does not have more than one retail value assigned for a given date, and ensuring that parameters of regular price change, clearance, and/or promotions are not causing the retail value of the item/location to go below zero.

The asynchronous conflict check process in RPM is a mechanism by which applications can execute long-running operations in the background while allowing work to be done simultaneously. Within the RPM application, asynchronous conflict check processing is always utilized in the following functional areas:

·         Price Changes

·         Clearances

·         Promotions

·         Worksheet

Conflict Check Rules

Conflict checking is made up of 18 rules that determine whether a price event can be approved or unapproved. The rules are broken up into three step processes.

1.    Conflict checking rules controlled by System Options

 Following are the conflict check rules that can be turned on or off by changing system options settings:

2.    Pre-RFR Insert Validator Conflict Checking rules

These rules are run before the effect of the new price event is added to the RPM_FUTURE_RETAIL (RFR) table. This is the first step in conflict checking. The price events (regular price changes, clearances, or promotions) that are proposed by the user are rejected before

they populate the future timeline. This conflict checking is required, and the user cannot choose whether to run these checks.

3.    Post-RFR Insert Conflict Checking Rules

These rules are “post-insert,” meaning that the effect of the new price event has been added to the RPM_FUTURE_RETAIL (RFR) table prior to running through these rules. If any of these areles is violated by the price event, all effects of the price event are removed from the RPM_FUTURE_RETAIL table. The RPM_CONFLICT_QUERY_CONTROL table provides the ability to add some configuration for the conflict checking.

Skipping Conflict Checks

Skipping Conflict Checking during Submit

Users have the option to skip the conflict checking process during the submit process if they do not need that for their business process. They can do this by checking the "Do not run Conflict Check for Submit" system option checkbox. If they do this, RPM does not perform the conflict checking process (and will not show conflicts if there are any) when the user performs a price event submit action. The price event status is switched to "Submit" immediately.

Skipping Conflict Checking during Complex Promotion Approval

Users can skip conflict checking process during complex promotion approval (and un-approval) by enabling the "Do not run Conflict Check for Complex Promotion Approval" system option checkbox. When this system option is checked, RPM does not perform the conflict checking process (and will not show conflicts if there are any) when users approve (or un-approve) a Complex promotion but it still inserts into the Future Retail GTT table and performs the explosion and rolls forward logic. It populates the Payload tables so that RPM can communicate this complex promotion to other systems (for example, through RIB or ORPOS extract).

It is important to note and understand that by disabling Conflict Check for Complex promotions, following functionalities are lost:

o    Overlapping promotions: Item/Location in the Complex promotion is not considered when validating the overlapping promotions.

o    Price Change Promotion Overlap/Clearance Promotion Overlap: Item/Location in the Complex promotion is not considered when validating these types of overlapping.

o    The Complex promotion information is not available in the Future Retail tables.

o    Deal cannot be attached to Complex promotions.

Although users can change this system option from one state to another in the System Options Edit screen at any time, however, it is not recommended. Flipping the system option (while having active or pending Complex promotions in the system) could produce unpredictable results, such as the following scenarios:

    i.    The "Do not run Conflict Check for Complex Promotion Approval" system option is checked. The user approves a Complex promotion, unchecks the system option, and un-approves the Complex promotion (or cancels/changes the end date after the promotion becomes active). RPM attempts to execute the conflict checking process but cannot find the related records in the Future Retail tables. The Complex promotion might fail un-approval.

   ii.    The "Do not run Conflict Check for Complex Promotion Approval" system option is unchecked. The user approves a Complex promotion. RPM executes the conflict checking process and updates the Future Retail tables. The user checks the system option and un-approves the Complex promotion (or cancels/changes the end date after the promotion becomes active). RPM un-approves (or cancels/changes the end date of) the promotion without executing conflict checking process. Related records in Future Retail tables are not updated.

  iii.    The "Do not run Conflict Check for Multi-Buy Promotion Approval" system option is checked. The user approves a Complex promotion, unchecks the system option, and approves another Complex promotion that is overlapping with the first promotion. During the overlapping constraint validation, RPM will not see the first promotion.

Conflict Check Processing Flow

The major components of conflict checking in RPM are performed by PL/SQL and are executed on the database server instead of the application server. When conflict checking is done synchronously, the system performs conflict checks immediately when Conflict Check is clicked from the Price Change, Promotions, or Clearances workspaces. It also happens when state changes occur that require conflict check. The system then displays a pop-up dialog showing the conflicts whenever conflicts are found.

Conflict checking is always done synchronously in the following situations:

o    Retail Service Layer (RSL) calls

o    Retail Integration Bus (RIB) calls

o    batches

o    auto-generated price changes

When conflict checking is done asynchronously, the conflict check processing happens in a background task or when the system is not busy performing other tasks. The user who initiated the action receives an alert once conflict checking is done. Conflict checking for location moves is expected to operate on extremely large volume of data. It is not acceptable for the user to have to wait for minutes to hours for processing of their request to complete. Thus, conflict checking for location moves is always done asynchronously.

The Conflict Check Results workspace allows User to review the results of background conflict checking for worksheets, price changes, promotions, and clearances. An alert appears in the Conflict column of the worksheet, price change, promotion, or clearance maintenance pane when conflict checking is complete.

Below is a screenshot for the Clearance Conflict Check:

Constraints are performed asynchronously at the same time as the conflict check. When the user executes an action that kicks off a conflict check, the user will indicate whether they want constraints checked. If constraints are checked, they will be handled just like conflict check errors. There is no longer a need to perform constraint checks first.

The asynchronous conflict check process is performed as follows.

1.     The client requests the application server to perform a process on a business object or set of business objects.

2.     The server's application service layer extracts information about the request (type of business object, identifying ID, and requested action).

3.     When RPM determines that a task is eligible for asynchronous processing:

a.     A JMS message is published to the queue that contains specific information about the task.

b.     A record is inserted into the TASK table. The task-specific information about the task is persisted as a Blob in the table. This task-specific information is a Java object that, when reading from the database, is capable of calling an RPM application service to perform asynchronous processing and generate an alert when the processing is completed.

4.     As soon as a message arrives in the queue, the container triggers execution of the RPMTaskMDB. RPMTaskMDB is a message-driven bean used to facilitate RPM's asynchronous processing capability. Message Driven Beans act as listeners to specified queues for messages.

5.     The task passes information to the application service layer.

6.     The application service layer performs a state transition on the requested business object (for example, approving a particular price change) based on the information passed by the task.

7.     The results of this transition (for example, success or failure messages, conflict details) are recorded in the RPM_CONFLICT_CHECK_RESULT table.

8.     The application service inserts a record into the ALERT table.

9.     The client periodically polls the Alerts application service which looks for new

10.  alerts in the ALERTS table.

Summary Note

This was all about conflict checks in RPM. At times, it is important to understand how conflict check process works in RPM to understand and avoid Business frustrations for any pricing events. .Hope this consolidated article on RPM Conflict check helps. Please do let me know in case of any question or comments.  Published: By: Nagesh Mishra - 12:14 PM

Oracle Retail Price Management (RPM) – Various Possible Promotions & Clearances Supported by RPM

Hello again Oracle Retail fans. This article is the continuation of our parent article on Oracle Retail Pricing Management (RPM – Deep Dive Tutorial). In any RPM Implementation or in regular support too, many a time, we come across to a situation where we ask ourselves that whether any particular type of Promotion or Clearance is supported by RPM or not. It is more frequently discussed particularly for Promotions. And that has prompted me to write this article.

I this article, I’m going to list down various possible types of Promotions and Clearances that RPM supports and can be created through the base application (out of the box). Please do let me know if I missed any specific scenario and needs to be added here. This article also answers, how to set up each of those promotions and clearances in RPM so you need not to look any further. 

Please do note that the promotions listed here are from RPM point of view, not for any downstream applications. If Oracle POS or any other POS, Store Applications are used, we need to check the integration compatibility and support viability of all below promotions according to those application's specifications.

I've listed down all scenarios  mainly into below 4 categories:

1.     Simple Promotions

2.     Multi-Buy Promotions

3.     Threshold Promotions

4.     Clearances

#	Promotion Type	POS Promotion Type	Example	The Price Management System Setup	Supported by RPM?
1	Simple	Fixed Price	Buy X, get X for $15	Fixed Amount	Yes
2	Simple	Percent Off	Buy X, get X for 10% off	% off	Yes
3	Simple	Amount Off	Buy X, get $10 off of X	Amount off	Yes
4	Multi-Buy	Buy N of X, Get Y at Z% off regular Price.	Buy two pairs of jeans, get a sweater at 50% off.	Buy Type = Qty, Reward %off, Buy Value = N, Reward List Type=Reward List	Yes
5	Multi-Buy	Buy N of X, Get Y at Z$ off regular Price	Buy two pairs of jeans, get $10 off of a sweater.	Buy Type = Qty, Reward Amount off, Buy Value = N, Reward List Type=Reward List	Yes
6	Multi-Buy	Buy N of X, Get Y at Z$ .	Buy two pairs of jeans, get a sweater for $20	Buy Type = Qty, Reward Fixed Amount, Buy Value = N, Reward List Type=Reward List	Yes
7	Multi-Buy	Buy $N of X, Get Y at Z% off regular Price	Buy $40 worth of jeans, get a sweater at 50% off.	Buy Type = Amount, Reward % Off, Buy Value = N, Reward List Type=Reward List	Yes
8	Multi-Buy	Buy $N of X, Get Y at Z$ off regular Price.	Buy $40 worth of jeans, get $10 off of a sweater.	Buy Type = Amount, Reward Amount Off, Buy Value = N, Reward List Type=Reward List	Yes
9	Multi-Buy	Buy $N of X, Get Y at Z$.	Buy $40 worth of jeans, get a sweater for $20	Buy Type = Amount, Reward Fixed Price, Buy Value = N, Reward List Type = Reward List	Yes
10	Multi-Buy	Buy N of All Items in X Item List, Get Y at Z% off regular Price.	Buy two pairs of jeans and shirt, get a sweater at 50% off.	Buy Type = All Reward %off, Buy Value = N, Reward List Type=Reward List	Yes
11	Multi-Buy	Buy N of All Items in X Item List, Get Y at Z$ off regular Price	Buy two pairs of jeans and shirt, get $10 off of a sweater.	Buy Type = All, Reward Amount off, Buy Value = N, Reward List Type=Reward List	Yes
12	Multi-Buy	Buy N of All Items in X Item List, Get Y at Z$ .	Buy two pairs of jeans and shirt, get a sweater for $20	Buy Type = All, Reward Fixed Amount, Buy Value = N, Reward List Type=Reward List	Yes
13	Multi-Buy	Buy N of All Items in X Item List, Get Cheapest in Y Free	Buy Four pairs of jeans and shirt, get cheapest free	Buy Type = All, Reward Cheapest Free, Buy Value = N, Reward List Type=Reward List	Yes
14	Multi-Buy	Buy N of All Items in X Item List, Get $M Value Y Free	Buy Four pairs of jeans and shirt, get $10 Cap free	Buy Type = All, Reward Cheapest Free, Buy Value = N, Reward List Type=Reward List, Reward Type=Amount, Reward Value=M or Buy Type = All, Reward % Off (100), Buy Value = N, Reward List Type=Reward List, Reward Type=Amount, Reward Value=M	Yes
15	Multi-Buy	Buy $N of All items in X Item List, Get Y at Z% off regular Price	Buy $40 worth of jeans and shirt, get a sweater at 50% off.	Buy Type = Amount, Reward % Off, Buy Value = N, Reward List Type=Reward List	Yes
16	Multi-Buy	Buy $N of All Items in X Item List, Get Y at Z$ off regular Price.	Buy $40 worth of jeans and shirt, get $10 off of a sweater.	Buy Type = Amount, Reward Amount Off, Buy Value = N, Reward List Type=Reward List	Yes
17	Multi-Buy	Buy $N of All Items in X Item List, Get Y at Z$.	Buy $40 worth of jeans and shirt, get a sweater for $20	Buy Type = Amount, Reward Fixed Price, Buy Value = N, Reward List Type = Reward List	Yes
18	Multi-Buy	Buy $N of All Items in X Item List, Get Cheapest in Y Free	Buy $100 worth of jeans and shirt, get cheapest free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List	Yes
19	Multi-Buy	Buy $N of All Items in X Item List, Get $M Value Y Free	Buy $100 worth of jeans and shirt, get $10 cap free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M Or Buy Type = Amount, Reward % Off (100), Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M	Yes
20	Multi-Buy	Buy N of X, Get Lowest Priced X at Z%off.	Buy 4 Jeans and get lowest priced jeans 10% off		No
21	Multi-Buy	Buy N of X, Get Lowest Priced Y at Z%off.	Buy 4 Jeans and get lowest priced shirt 10% off		No
22	Multi-Buy	Buy $N of X, Get Lowest Priced X at Z%off.	Buy $100 worth of Jeans and get lowest priced jeans 10% off		No
23	Multi-Buy	Buy $N of X, Get Lowest Priced Y at Z%off.	Buy $100 worth of Jeans and get lowest priced shirt 10% off		No
24	Multi-Buy	Buy N of A and N of B, Get Y at Z% off	Buy a cap and a glove, get a scarf 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward %off, Buy Value = N, Reward List Type = Reward List	Yes
25	Multi-Buy	Buy N of A and N of B, Get Y at $Z off	Buy a cap and a glove, get a scarf $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward Amount off, Buy Value = N, Reward List Type = Reward List	Yes
26	Multi-Buy	Buy N of A and N of B, Get Y for $Z.	Buy a cap and a glove, get a scarf for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Qty, Reward Fixed Amount, Buy Value = N, Reward List Type = Reward List	Yes
27	Multi-Buy	Buy N of A and N of B, Get Cheapest in Y for Free	Buy a cap and a tie get cheapest in glove free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List	Yes
28	Multi-Buy	Buy N of A and N of B, Get $M Value Y for Free	Buy a cap and a tie get $10 cap free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M Or Buy Type = Qty, Reward % Off (100), Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M	Yes
29	Multi-Buy	Buy N of A and N of B, Get Z% off	Buy a cap and a glove, get 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward %off, Buy Value = N, Reward List Type = All Buy List	Yes
30	Multi-Buy	Buy N of A and N of B, Get $Z off	Buy a cap and a glove, $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward Amount off, Buy Value = N, Reward List Type = All Buy List	Yes
31	Multi-Buy	Buy N of A and N of B, For $Z.	Buy a cap and a glove, for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Qty, Reward Fixed Amount, Buy Value = N, Reward List Type = All Buy List	Yes
32	Multi-Buy	Buy N of A and N of B, Get Cheapest Free.	Buy a cap and a glove, get cheapest free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = All Buy List	Yes
33	Multi-Buy	Buy N of A and N of B, Get $M Value of A and B Free	Buy a cap and a glove, get $10 item in Cap and Glove free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M Or Buy Type = Qty, Reward % Off (100), Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M	Yes
34	Multi-Buy	Buy N of A OR N of B, Get Y at Z% off	Buy a cap or a glove, get a scarf 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward %off, Buy Value = N, Reward List Type = Reward List	Yes
35	Multi-Buy	Buy N of A OR N of B, Get Y at $Z off	Buy a cap or a glove, get a scarf $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward Amount off, Buy Value = N, Reward List Type = Reward List	Yes
36	Multi-Buy	Buy N of A OR N of B, Get Y for $Z.	Buy a cap or a glove, get a scarf for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Qty, Reward Fixed Amount, Buy Value = N, Reward List Type = Reward List	Yes
37	Multi-Buy	Buy N of A OR N of B, Get Cheapest in Y for Free	Buy a cap or a glove, get cheapest in scarf free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List	Yes
38	Multi-Buy	Buy N of A OR N of B, Get Z% off	Buy a cap or a glove, get 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward %off, Buy Value = N, Reward List Type = All Buy List	Yes
39	Multi-Buy	Buy N of A OR N of B, Get $Z off	Buy a cap or a glove, $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward Amount off, Buy Value = N, Reward List Type = All Buy List	Yes
40	Multi-Buy	Buy N of A OR N of B, For $Z.	Buy a cap or a glove, for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Qty, Reward Fixed Amount, Buy Value = N, Reward List Type = All Buy List	Yes
41	Multi-Buy	Buy N of A OR N of B, Get Cheapest Free	Buy a cap or a glove, get cheapest free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = All Buy List	Yes
42	Multi-Buy	Buy N of A OR N of B, Get $M Value of A or B for Free	Buy a cap or a glove, get $10 item in Cap and Glove free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M Or Buy Type = Qty, Reward % Off (100), Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M	Yes
43	Multi-Buy	Buy $N of A and N of B, Get Y at Z% off	Buy $20 of a cap and a glove, get a scarf 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward %off, Buy Value = N, Reward List Type = Reward List	Yes
44	Multi-Buy	Buy $N of A and N of B, Get Y at $Z off	Buy $20 a cap and a glove, get a scarf $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward Amount off, Buy Value = N, Reward List Type = Reward List	Yes
45	Multi-Buy	Buy $N of A and N of B, Get Y for $Z.	Buy $20 a cap and a glove, get a scarf for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Amount, Reward Fixed Amount, Buy Value = N, Reward List Type = Reward List	Yes
46	Multi-Buy	Buy $N of A and N of B, Get Cheapest in Y for Free	Buy $50 a cap and a glove, get cheapest in scarf for free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List	Yes
47	Multi-Buy	Buy $N of A and N of B, Get $M Value of A and B Free	Buy $50 a cap and a glove, get $10 Cap or Glove free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward Type=Amount, Reward List Type = Reward List , Reward Value=M Or Buy Type = Amount, Reward $Off (100), Buy Value = N, Reward Type=Amount, Reward List Type = Reward List, Reward Value=M	Yes
48	Multi-Buy	Buy $N of A and N of B, Get Z% off	Buy $20 of a cap and a glove, get 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward %off, Buy Value = N, Reward List Type = All Buy List	Yes
49	Multi-Buy	Buy $N of A and N of B, Get $Z off	Buy $20 of a cap and a glove, $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward Amount off, Buy Value = N, Reward List Type = All Buy List	Yes
50	Multi-Buy	Buy $N of A and N of B, For $Z.	Buy $20 of a cap and a glove, for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Amount, Reward Fixed Amount, Buy Value = N, Reward List Type = All Buy List	Yes
51	Multi-Buy	Buy $N of A and N of B, Get Cheapest for Free	Buy $50 of a cap and a glove, get cheapest free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = All Buy List	Yes
52	Multi-Buy	Buy $N of A OR N of B, Get Y at Z% off	Buy $20 of a cap or a glove, get a scarf 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward %off, Buy Value = N, Reward List Type = Reward List	Yes
53	Multi-Buy	Buy $N of A OR N of B, Get Y at $Z off	Buy $20 of a cap or a glove, get a scarf $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward Amount off, Buy Value = N, Reward List Type = Reward List	Yes
54	Multi-Buy	Buy $N of A OR N of B, Get Y for $Z.	Buy $20 of a cap or a glove, get a scarf for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Amount, Reward Fixed Amount, Buy Value = N, Reward List Type = Reward List	Yes
55	Multi-Buy	Buy $N of A OR N of B, Get Cheapest in Y for Free	Buy $50 of a cap or a glove, get get cheapest free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List	Yes
56	Multi-Buy	Buy $N of A OR N of B, Get $M Value of A or B Free	Buy $50 of a cap or a glove, get $10 cap or glove free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward Type=Amount, Reward List Type = Reward List , Reward Value=M Or Buy Type = Amount, Reward $Off (100), Buy Value = N, Reward Type=Amount, Reward List Type = Reward List, Reward Value=M	Yes
57	Multi-Buy	Buy $N of A OR N of B, Get Z% off	Buy $20 of a cap or a glove, get 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward %off, Buy Value = N, Reward List Type = All Buy List	Yes
58	Multi-Buy	Buy $N of A OR N of B, Get $Z off	Buy $20 of a cap or a glove, $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward Amount off, Buy Value = N, Reward List Type = All Buy List	Yes
59	Multi-Buy	Buy $N of A OR N of B, For $Z.	Buy $20 of a cap or a glove, for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Amount, Reward Fixed Amount, Buy Value = N, Reward List Type = All Buy List	Yes
60	Multi-Buy	Buy $N of A OR N of B, Get Cheapest for Free	Buy $50 of a cap or a glove, get cheapest free	Buy Type = Amount, Cheapest Free, Buy Value = N, Reward List Type = All Buy List	Yes
61	Multi-Buy	Buy N of X, get the cheapest free	Buy four pair of shoes, get the cheapest pair free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = All Buy List or Each Buy List (when only single List)
62	Multi-Buy	Buy $N of X, get the cheapest free	Buy four pair of shoes, get the cheapest pair free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = All Buy List or Each Buy List (when only single List)
63	Multi-Buy	Buy $N of X, get $M X free	Buy four pair of shoes, get the $10 shoe free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward Type=Amount, Reward List Type = Reward List , Reward Value=M, Reward List Items contains same items as Buy List Or Buy Type = Amount, Reward $Off (100), Buy Value = N, Reward Type=Amount, Reward List Type = Reward List, Reward Value=M, Reward List Items contains same items as Buy List
64	Multi-Buy	Buy N of A, Get B of $Z or less for free	Buy one pair of jeans at regular price over $45 and get a T-Shirt regular priced at $25 or less for free	Buy Type = Qty, Reward 100% Off, Buy Value = N, Reward List Type=Reward List, Reward Type = Amount	May Be. This same scenario could be executed by building specific item lists and selecting them for the buy and get scenarios within RPM.
65	Multi-Buy	Buy $N of A, Get B of $Z or less for free	Buy one pair of jeans at regular price over $45 and get a T-Shirt regular priced at $25 or less for free	Buy Type = Amount, Reward 100% Off, Buy Value = N, Reward List Type=Reward List, Reward Type = Amount	May Be. This same scenario could be executed by building specific item lists and selecting them for the buy and get scenarios within RPM.
66	Multi-buy	Buy N of X1, N of X2, N of X3 for a flat price $Z.	Buy hamburger, Coke and fries for 5.00	Qualification Type = Multi-buy Multi-buy = Quantity (with AND connector) Reward Type = Fixed Price	Yes
67	Multi-buy	Buy N of X1, N of X2, N of X3 for $Z off of purchase.	Buy hamburger, Coke and fries, receive 1.00 off purchase	Qualification Type = Multi-buy Multi-buy = Quantity (with AND connector) Reward Type = Amount Off	Yes
68	Multi-buy	Buy N of X1, N of X2, N of X3 for Z% off of purchase.	Buy hamburger, Coke and fries, save 15% off purchase	Qualification Type = Multi-buy Multi-buy = Quantity (with AND connector) Reward Type = % off	Yes
69	Threshold	Buy N of X, get Z% off ( Threshold Level)	Buy any six pairs of jeans, get 10% off each of the jeans	Qualification Type = Threshold Level Threshold Type = Quantity Reward Type = % off	No
70	Threshold	Buy N of X, get Z% off (Item Level)	Buy six pairs of Levi's jeans, get 10% off each of the jeans.	Qualification Type = Item Level Threshold Type = Quantity Reward Type = % off	Yes
71	Threshold	Buy N of X, Get $Z off ( Threshold Level)	Buy six pairs of jeans, get $10 off each of the jeans	Qualification Type = Threshold Level Threshold Type = Quantity Reward Type = Amount off	No
72	Threshold	Buy N of X, get $Z off (Item Level)	Buy six pairs of jeans, get $10 off each of the jeans.	Qualification Type = Item Level Threshold Type = Quantity Reward Type = Amount off	Yes
73	Threshold	Buy N of X, Get items for $Z ( Threshold Level)	Buy two pairs of jeans and get them for $45 each	Qualification Type = Threshold Level Threshold Type = Quantity Reward Type = Fixed Amount	No
74	Threshold	Buy $N of X, get items for $Z  (Item Level)	Buy $100 worth of jeans and get them for $45 each.	Qualification Type = Threshold Level Threshold Type = Amount Reward Type = Fixed Amount	Yes
75	Threshold	Buy $N of X, get Z% off ( Threshold Level)	Buy $100 worth of jeans, get 10% off each pair of jeans	Qualification Type = Threshold Level Threshold Type = Amount Reward Type = % off	Yes
76	Threshold	Buy $N of X, get Z% off (Item Level)	Buy $100 worth of jeans, get 10% off each pair of jeans	Qualification Type = Item Level Threshold Type = Amount Reward Type = % off	Yes
77	Threshold	Buy $N of X, Get $Z off ( Threshold Level)	Buy $100 worth of jeans, get $10 off each pair of jeans	Qualification Type = Threshold Level Threshold Type = Amount Reward Type = Amount off	Yes
78	Threshold	Buy $N of X, Get $Z off  (Item Level)	Buy $100 worth of jeans, get $10 off each pair of jeans	Qualification Type = Item Level Threshold Type = Amount Reward Type = Amount off	Yes
79	Threshold	Buy N1 of X Get Z1% off, Buy N2 of X Get Z2% Off, Buy N3 for X Get Z3% Off	Buy 2 jeans, get 10% off, Buy 4 jeans get 15% off, Buy 6 jeans get 20% off	Qualification Type = Item Level Threshold Type = Quantity Reward Type = % off	Yes. Multilevel Threshold Promotion
80	Threshold	Buy N1 of X Get $Z1 off, Buy N2 of X Get $Z2 Off, Buy N3 for X Get $Z3 Off	Buy 2 jeans, get $5 off, Buy 4 jeans get $10 off, Buy 6 jeans get $15 off	Qualification Type = Item Level Threshold Type = Quantity Reward Type = Amount off	Yes. Multilevel Threshold Promotion
81	Threshold	Buy N1 of X Get Eac for $Z1, Buy N2 of X Get Each for $Z2, Buy N3 for X Get Each for $Z3	Buy 2 jeans, get each for $20, Buy 4 jeans get each for $18, Buy 6 jeans get each for $16	Qualification Type = Item Level Threshold Type = Quantity Reward Type = Fixed Amount	Yes. Multilevel Threshold Promotion
82	Threshold	Buy $N1 of X Get Z1% off, Buy $N2 of X Get Z2% Off, Buy $N3 for X Get Z3% Off	Buy $50 worth of jeans, get 10% off, Buy $100 worth of jeans get 15% off, Buy $200 worth of jeans get 20% off	Qualification Type = Item Level Threshold Type = Amount Reward Type = % off	Yes. Multilevel Threshold Promotion
83	Threshold	Buy $N1 of X Get Z1% off, Buy $N2 of X Get $Z2 Off, Buy $N3 for X Get $Z3 Off	Buy $50 worth of jeans, get 10% off, Buy $100 worth of jeans get 15% off, Buy $200 worth of jeans get 20% off	Qualification Type = Item Level Threshold Type = Amount Reward Type = Amount off	Yes. Multilevel Threshold Promotion
84	Finance	Buy N of X with promoted card, get promotional interest % for Z duration	Purchase $1,000 of Electronics using Visa and receive promotion percentage of 0%, with a duration of 18 months (for no interest payments if paid in full within 18 months).	Card Details Threshold Amount $ Promotion Amount % Duration in Months Items	No
85	Clearance	Items within clearance retail range $A-$B are set to fixed price of $A All clearance are considered as Price Change in ORPOS	Items within clearance retail 100-130$ are set to fixed price of 108$	Clearance	Yes
86	Clearance	Items within regular price $A-$B are set to fixed price of $N	Items within regular price 90-100$ are set to fixed price of $92	Clearance	Yes
87	Clearance	All clearance items are set to a fixed price of $N	All clearance items are set to a fixed price of $120.	Clearance	Yes
88	Clearance	Additional X% of all clearance items	Price Change (% off - 10%) on Clearance item (Clearance = 10$ Amount off)	Price Change on Clearance	Yes
89	Clearance	All clearance items in specific department is $X	All clearance items are set to a fixed price of $120.	Clearance	Yes

Please do let me know in case you have any question or comments. Also, let me know if any other specific scenario is missed here, I would definitely add.

Published: By: Nagesh Mishra - 11:52 AM