Oracle Order Management – Pricing based on quantity range without Price Break Feature

How to setup to make a price list line only eligible to a sales order if the line item quantity is at a certain value or range.

Does not want to use price break header functionality because if the item quantity is not in the range, then the pricing engine should look for a different price list.

Setup Steps:

Please follow the below Setup steps:

Navigation:

Oracle Pricing Manager Responsibility > Setup > Attribute Management > Context and Attributes

Query the Code as ‘PRICING ATTRIBUTE’ and Name as ‘Pricing Attribute’

Create a new record as below:
Code: B_CODE

Name: B_Qty_Pricing
Column Mapped: PRICING_ATTRIBUTE2 (Can be selected any attribute based on availability)
Value Set: QP: Number

  

Save after the above changes are done.

Navigation:

Oracle Pricing Manager Responsibility > Setup > Attribute Management > Attribute Mapping and Linking

Query the Pricing Transaction Entity as ‘Order Fulfillment’, Context Type as ‘Pricing Context’ and the Code as ‘PRICING_ATTRIBUTE’

  

Click on 'Link Attributes'
Add a new record as below:
Code: B_CODE
Level: LINE
Attribute mapping method: ATTRIBUTE MAPPING

Save after the above changes are done.

Click on Attribute Mapping (button) to define:
Application name = ‘Advanced Pricing’ for Request Type ‘ONT’
Under line level enter:
User Source Type: PL/SQL API
User Value String: OE_ORDER_PUB.G_LINE.ORDERED_QUANTITY

Save after the above changes are done.

From > Tools > Run the concurrent program ‘Build Attribute Mapping Rules’

Price List Definition:
Query the Price List line for an Item and add pricing attribute information as it will now be available in the list of values.
Add a second line for the same item and the quantity it applies to by entering the newly created pricing attribute. Remember, always add a line along with Pricing Attribute and then Save the record. 

Pricing attributes values in details for each price list line:

Recommended step:

Run the concurrent ‘QP: Maintains the denormalized data in QP Qualifiers’ in Oracle Pricing Manager Responsibility

Test Cycle:

Now create a sales order with different quantity matching the above pricing setup for the mentioned item to test the functionality built so far 

Reference:  How to Setup to Make a Price List Line Only Eligible to a Sales Order When the Line Item Quantity is at a Certain Value or Range [ID 414254.1]