BOM Pricing

Overview

Beginning in Release 18C, Oracle CPQ provides a Configurable Price item that allows customers to define BOM prices, which can be different from the Parts database prices. This feature allows customers to deliver price incentives for items included within defined BOM structures.

Several BOM Mapping values and prices are impacted by the BOM Pricing enhancement. The following section provides BOM Price use cases and describes pricing behavior for the following items:

Configuration - the price value for the BOM item in the Configuration Bill of Materials
BOM Instance - the "configurablePrice" attribute in the BOM Instance JSON
Commerce - the Configurable Price value, List Price value, and the "_is_bom_price" attribute
Sales BOM - the "configurablePrice" attribute retrieved using the BML getBOM function
Manufacturing BOM - the "configurablePrice" attribute retrieved using the BML getBOM function

The following table lists the BOM Item Definition BOM Price with example price values. The pricing results are displayed for Configuration, BOM Instance, Commerce, Sales BOM, and Manufacturing BOM items.

BOM Item Definition BOM Price	Example	Configuration	BOM Instance	Commerce	Sales BOM	Manufacturing BOM
Positive Price Value	10	10	10	Configurable Price = 10	10	10
				List Price = 10
				_is_bom_price= true
Zero Price Value	0	Price Book Price	NA	Configurable Price = Price Book Price	No configurablePrice attribute	No configurablePrice attribute
				List Price = Price Book Price
				_is_bom_price= false

Note: Negative BOM item pricing is currently not supported and should not be used.

Notes:

When an Advanced BOM Mapping Rule returns a BOM Instance with a zero price, Configuration displays "0" upon request and Commerce Configurable Price displays "0" with _is_bom_price=true.
When an Advanced BOM Mapping Rule returns a BOM Instance without a configurablePrice attribute, the parts pricing takes effect with _is_bom_price=false.

Additional BOM Pricing Scenarios

In addition to the use case inputs, BOM Mapping status and Configuration BOM Mapping Rules will also impact BOM pricing. The following scenarios describe pricing behavior.

Scenario 1 -The BOM Item Definition BOM item has the Included In Base Price set to Y.

Scenario 2 - The BOM Item Definition BOM Price column is NOT mapped and a BOM Mapping Configuration Table Based Rule is defined.

If BOM Item Definition BOM Price column is not mapped, the "configurablePrice" attribute will not exist. The BOM Mapping Rules cannot return "configurablePrice", so the Parts database price is used.

Configuration	BOM Instance	Commerce	Sales BOM	Manufacturing BOM
Price Book Price	No configurablePrice attribute	Configurable Price = Price Book Price	No configurablePrice attribute	No configurablePrice attribute
Price Book Price	No configurablePrice attribute	_is_bom_price=false	_is_bom_price=false	No configurablePrice attribute

Commerce Pricing

There are five price columns displayed for items for Commerce. The following table lists the pricing items that are evaluated to determine price values for the following items:

Item Price - variable name: _price_item_price_each
Configurable Price - variable name: _price_configurable_price
List Price - variable name: _price_list_price_each
Pricing Rule Price - variable name: _pricing_rule_price_each
Unit Price - variable name: _price_unit_price_each

Name	Parts	Recommended Part	BOM Part	Model	Recommended Model
Item Price	Price Book Price Part Base Price	Price Book Price Part Base Price	Part Base Price Price Book Price	Model Base Price Pricing Rules Attribute Value Pricing	Model Base Price
Configurable Price	no value	Recommended Item Price	BOM Item Price (Defined in BOM Item Definition Data Table or using BOM Mapping Rule Advanced BML)	Item Price	Recommended Item Price
List Price	User Input Item Price	User Input Configurable Price Item Price	User Input Configurable Price Item Price	User Input Item Price	User Input Configurable Price Item Price
Pricing Rule Price	Customer Specific Pricing	Customer Specific Pricing	Customer Specific Pricing	no value	no value
Unit Price	User Input Customer Specific Pricing List Price	User Input Customer Specific Pricing List Price	User Input Customer Specific Pricing List Price	User Input Customer Specific Pricing List Price	User Input Customer Specific Pricing List Price

Notes:

The user input is evaluated first for List Price and Unit Price only when the Commerce Line-level "_price_override_price" attribute is set to "true".
When a BOM item Included In Base Price is set to Y, Configurable Price, Pricing Rule Price, and Item Price values are ignored. The List Price, Unit Price and Sub-total values will be "0".

Configuration Pricing

There is one price column displayed for items in Configuration. The following table lists the pricing items that are evaluated to determine the Configuration price value.

Recommended Part	BOM Part	Mandatory Part	Recommended Model
Part Base Price Parts Price Book Price Recommended Item Price Pricing Rule from the Rating Engine or Customer Specific Pricing	Parts Base Price Parts Price Book Price BOM Item Price Pricing Rule from the Rating Engine or Customer Specific Pricing	Parts Base Price Parts Price Book Price Pricing Rule from the Rating Engine or Customer Specific Pricing	Model Base Price Attribute Value Pricing Pricing Rule from the Rating Engine or Customer Specific Pricing

Configurable Price Item

Introduced in Release 18C, the "configurablePrice" item is used to reference BOM Prices. The "configurablePrice" item is available for Advanced BML within Configuration BOM Mapping Rules and the following BML functions: getbom, savebom, convertbomtoflat, and convertbomtohier. The following examples show the "configurablePrice" item behavior for several BOM Pricing use cases.

Positive Price Value Example

In the following example, a positive price value is provided in the BOM Item Definition Data Table.

{
   "partNumber": "BOM Parent 1",
   … },
   "explodedQuantity": 1,
   "category": "sales",
   "variableName": "BOM Parent 1",
   "currencyCode": "USD",
   "configurablePrice": 5,
   "definition": {
   … },
   "children": [{
         "partNumber": "part8",
         "quantity": 1,
         "isModel": false,
         "explodedQuantity": 1,
         "variableName": "defLineItemPart8",
         "configurablePrice": 300,
         "definition": {
         … }
      }
   ]
}

Zero Price Value Example

In the following example, a zero "0" price value is provided in the BOM Item Definition Data Table, which indicates that there is no BOM pricing override and the parts pricing will take effect. The "configurablePrice" node is absent in the configuration BOM instance.

{
   "partNumber": "BOM Parent 1",
      … },
   "explodedQuantity": 1,
   "category": "sales",
   "variableName": "BOM Parent 1",
   "currencyCode": "USD", 
   "definition": {
      … },
   "children": [{
         "partNumber": "part8",
         "quantity": 1,
         "isModel": false,
         "explodedQuantity": 1,
         "variableName": "defLineItemPart8",
         "configurablePrice": 0,
         "definition": {
            … }
      }
   ]
}

Unmapped BOM Price Column Example

In the following example, the BOM Price column from the BOM Item Definition Data Table is not mapped.

{
   "partNumber": "BOM Parent 1",
      … },
   "explodedQuantity": 1,
   "category": "sales",
   "variableName": "BOM Parent 1",
   "currencyCode": "USD",
   "definition": {
      … },
   "children": [{
         "partNumber": "part8",
         "quantity": 1,
         "isModel": false,
         "explodedQuantity": 1,
         "variableName": "defLineItemPart8",
         "definition": {
            … }
      }
   ]
}

User Defined Currency Example

In the following example, the User-defined currency is different from the Site Base currency.

{
   "partNumber": "BOM Parent 1",
      …
   },
   "explodedQuantity": 1,
   "category": "sales",
   "variableName": "BOM Parent 1",
   "currencyCode": "EUR",
   "configurablePrice": 1.25,
   "definition": {
      …
   },
   "children": [{
         "partNumber": "part8",
         "quantity": 1,
         "isModel": false,
         "explodedQuantity": 1,
         "variableName": "defLineItemPart8",
         "configurablePrice": 75,
         "definition": {
            …
         }
      }
   ]
}