Pricing Engine Price Attributes

Overview

Oracle CPQ supports additional a set of canonical Pricing Engine Pricing Attributes in the Oracle CPQ pricing module to enable Pricing Engine features CPQ provides several standard attributes automatically, including Quantity, In addition to the Account Name and Part Number available in prior releases, these may be supplemented by any additional Commerce, or Parts or Configuration custom attributes can be used to define pricing profiles for deriving list prices that you wish to use in defining conditions for Pricing Rules or Price Models Pricing Engine Attributes are mapped to the specific attribute you wish to use in Commerce, Parts or Configuration, so that consistent pricing will be applied to all consumers of pricing.

The pricing portal calculates prices for Configuration, Invocation, Commerce, Reconfigure, and Calculate Price REST API web services using the Pricing Engine Models and Rules. When creating a quote within CPQ, existing integration functionality can be used to send contract and subscription data to external applications such as Oracle Enterprise Contracts. These applications invoke the Calculate Price REST API to retrieve pricing information from CPQ.

Administrators create Pricing Attributes and map source attributes in a Commerce process or in Part/Item data to be used in the Pricing Engine. After mapping, Pricing Attributes are available in defining Pricing Rules and Pricing Models and will automatically populate the values referenced in conditions and functions. Pricing Rules are linked to applicable Price Models that apply prices to individual parts.

Pricing Engine Price Attribute Pages

ClosedPrice Attributes List Page - This list page allows administrators to view the pricing attributes Pricing Entity (Header or Line), Name, Variable Name, Data Type, and Type without opening individual Pricing Attributes details. The array type attributes are appropriately labeled in the Data Type column on the Pricing Attributes list page.

Pricing Attributes list page

Item Description

1

 Navigate to Pricing Portal.

2

 Add a new Pricing Attribute or Manage Columns for the Pricing Attributes list.

3

Enter search criteria to filter Pricing Attributes results, which remain persistent while navigating within Pricing Attributes.

4

Sort Pricing Attributes using the Pricing Entity, Name, Variable Name, Data Type, or Type column headers.

5

 Edit an existing Price Attribute by clicking on the appropriate Name link or click on the line ellipsis and selecting Edit.

6

Edit or Delete a Pricing Attribute by clicking on the line ellipsis and selecting the appropriate action.

ClosedPricing Attribute Page - This page allows administrators to manage Basic Details and Attribute Mapping for a pricing attribute.

Pricing Atribute page

Item Description

1

 Navigate to the Pricing Attributes list page.

2

 Navigate to Next or Previous pricing attribute in the pricing attributes list or filtered pricing attributes search results list.

3

 Data Type: Boolean, Currency, String, Decimal, Date, or Integer.

4

 Pricing Entity: Header or Line

5

Type: Custom or Standard

6

Edit the pricing attributes Name or Description.

7

Mapped Data Sources

8

Click Edit to add, reorder, and delete attribute mappings.

Beginning in CPQ 23A, pricing attributes can now be re-sequenced (ordered) without creating a new attribute and deleting the old one.

See procedures to for more information.

Pricing Engine Price Attribute Enhancements

 

Administration

ClosedAdd a Pricing Attribute

Complete the following steps to create a Pricing Attribute.

  1. Navigate to the Admin page.

  2. Click Pricing Portal in the Products section.

  3. Click on the Pricing Attributes card.

  4. Click the Add button at the top of the Pricing Attributes page.

    Create Pricing Attribute dialog

  5. Enter a name in the Name field.
  6. Enter the Variable Name. Variable names can only contain alpha-numeric characters and underscores. The entry can be changed before saving, but after saving the value is read-only.
  7. Select the Data Type: Boolean, Currency, String, Decimal, Date, or Integer.
  8. Select the Pricing Entity option:

    • Header - Select this option for Contract Header attributes.

    • Line - Select this option for Line Item attributes.

  9. Select the Array Type option.

    • Yes - Select this option for Array attributes.

    • No - Select this option for Non-Array attributes.

  10. (optional) Select a Lookup to associate a Pricing Lookup to a String type Pricing Attribute.

  11. (optional) Enter a Description

  12. Click Create.

  13. Click the Attribute Mapping Edit button.

    Edit Attibute Mapping

  14. Complete the following items to map a pricing attribute to a Commerce, Configuration, or Parts attribute.

    Selected attribute mapping line

    1. Click Add.
    2. Select the Data Source from the drop-down menu.

    3. Select the appropriate attribute from the Source Attribute Name drop-down menu.

      Notes:

      • The Source Attribute Variable Name and Path will auto-populate.
      • To reorder mapping attributes, click in the Order field and enter the desired order number.
      • To delete a Pricing Data line, click the ellipsis at the end of the line and select Delete.

  15. Repeat Step 13 to add and map additional attributes.

  16. Click Update to add the attribute mapping.

ClosedPricing Engine Quantity Attribute

The standard Pricing Engine Quantity attribute supports the Volume Pricing and Tier Pricing price models. This pricing attribute can't be deleted, but it can have new mappings added and its mappings can be reordered. This Quantity pricing attribute is used to determine which pricing tier applies when executing the dynamic pricing types that are quantity-driven (i.e. Tiered Pricing, Volume Pricing price models). If the value of the attribute is missing when the mappings are evaluated at runtime, a quantity of 1 is used.

Pricing Engine Quantity Attribute

ClosedReorder Mapped Pricing Attributes

Complete the following steps to reorder mapped pricing attributes.

  1. Navigate to the Admin page.

  2. Click Pricing Portal in the Products section.

  3. Click on the Pricing Attributes card.

  4. Click the appropriate Attribute Name link.

  5. Click the Attribute Mapping Edit button.

  6. To reorder mapping attributes, click in the Order field and enter the desired order number.

    Reorder attribute mappings

  7. Click Update to save the new attribute mapping order.

Related Topics

Related Topics Link IconSee Also