My Oracle Support Banner

How to Easily Setup a Promotion Where One Buys 6 Items Get 1 Item Free, Buy 12 Items Get 2 Items Free, Buy 65 Items Get 10 Items Free (Doc ID 2012889.1)

Last updated on FEBRUARY 24, 2021

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
Promotional Goods
by Multipler


Note: In the images bellow and/or the attached document, user details / company name / address / email / telephone number represents fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

How can one setup a modifier that provides free get quantity based on the following business requirements?
If customer buy 6 quantity of x product then he/she will get 1 item y free
similarly if customer buys 12 quantity then he/she will get 2 item y free
and if customer buy 65 quantity of x product then he/she will get 10 item y free

One would like to have a setup that is not resource intensive whereas it requires many ranges to be entered to
account for the buy items. For example does not want to have to enter buy   from 1 to 6 get 1 item free, buy 7 to 12 get 2 items free, etc.


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
 Setup Needed:
 1) Create the modifier header record
 2) Enter a record under the modifiers summary tab For Buy Item
 3) Select the Define Details Button to define the “get item” details.
 Test on Sales Order Lines with Various Ordered Quantities
 Enter buy item with quantity = 6, get a new line with get item for quantity = 1
 Enter buy item with quantity = 12, get a new line with get item for quantity = 2
 Enter buy item with quantity = 15, get a new line with get item for quantity = 2
 Enter buy item with quantity = 67, get a new line with get item for quantity = 10

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