Pricing Rules

Overview

Pricing Rules determine when the Pricing Engine will invoke the specified price models.

Pricing Rule Types: There are four pricing rule types:

Pricing Rule Page Descriptions

ClosedPricing Rules List Page - This list page allows administrators to view the pricing rule Name, Variable Name, Value Type, Dynamic Pricing, and the number of Linked Pricing Rules without opening individual Price Model details.

Pricing Rules list page

Item Description

1

Navigate to Pricing Portal.

2

Add a new Pricing Rule, Reorder existing rules, or Manage Columns for the Pricing Rules list.

3

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

4

Sort Pricing Rules using the Order, Name, Variable Name, Status, Start or End column headers.

5

Edit an existing Pricing Rule by clicking on the appropriate Name link or clicking on the line ellipsis and clicking Edit.

6

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


ClosedPricing Rule Page - This page allows administrators to manage Basic Details, Conditions, and Pricing Data for a price model.

Pricing Rule page

Item Description

1

Navigate to the Pricing Rules list page.

2

Navigate to Next or Previous price model in the pricing rules list or filtered pricing rule search results list.

3

The Start date and time (previously named 'From') is the beginning date and time that a pricing rule will be effective.

The Start field is no longer required on Pricing Rules and may be set to a historical date and time. As a result, both retroactive and evergreen Pricing Rules are now supported and you can use Status to govern their effectivity.

4

The End date and time (previously named 'To') is the ending date and time that a pricing rule will be effective.

5

Status (previously named 'Active') is used to set the pricing rule to Active or Inactive.

6

Edit the pricing rule Name, Description, Start date and time, End date and time, or Status.

7

Conditions can be set to Always True, Customer Specific, Simple, or Advanced.

See Pricing Rule Types for condition type descriptions.

8

The conditions Edit allow administrators to modify and change the pricing rule conditions.

The pricing rule condition type can not be changed for releases prior to CPQ 23A,

9

Actions provide the ability to Add new Linked Price Models, Reorder existing Linked Price Models, or Manage Columns for the linked Price Models list.

Simple pricing rules can't be linked to Advanced price models.

10

Click on the Model link or click the line ellipsis and select Edit to edit the linked Price Model. See Price Models for editing information.

11

Edit or Delete a Linked Price Model by clicking on the line ellipsis and selecting the appropriate action.

This operation does not delete the associated price model.


Pricing Rule Enhancements

ClosedBase Pricing Rule - CPQ provides a seeded Pricing Rule called ‘Base Pricing Rule’. The Base Pricing Rule enhances the pricing administrator user experience by predefining the setup for the Base Price Model at run-time.

The seeded Base Pricing Rule has Base Price Model linked where both cannot be deleted, reordered or assigned a condition. These Base objects will unconditionally apply "Base" pricing; therefore, simplifying the required pricing setup in CPQ.

Base Pricing Rule


Administration

ClosedAdd a Pricing Rule

  1. Navigate to the Admin page.

  2. Click Pricing Portal in the Products section.

  3. Click on the Pricing Rules card.
  4. Select Add from the Actions drop-down.

  5. Enter the following information:

    1. Enter a name in the Name field.

    2. 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.

    3. (Optional) Enter a Start date and time.

    4. (Optional) Enter an End date and time.

    5. (Optional) Enter a Description.

    New Pricing Rule dialog

  6. Click Create.

  7. Click the Conditions Edit button.

    Edit pricing rule Conditions

  8. Select the applicable rule type.

    ClosedAlways True

    1. Select Always True from the Condition Type drop-down.
    2. Click Update.

    Conditition - Always True option


    ClosedCustomer Specific

    1. Select Customer Specific from the Condition Type drop-down.
    2. Click the Add button.

      Edit Pricing Rule Accounts

    3. Select the appropriate account from the Account drop-down.

      As you begin typing, the available accounts will begin to filter.

    4. Enter Start and End dates and times for each account in the pricing rule.

    5. (Optional) If you want to inactive the pricing rule for the account, select Inactive from the Status drop-down.

    6. Click Save when you've finished editing the account.

      • To add additional accounts, click Add and repeat sub-steps a - d.
      • To edit an account line, click inside the desired field(s) to modify the values, then click Save when you've finished editing.
      • To delete an account line, click the ellipsis at the end of the line and select Delete.
    7. Click Update after adding, editing, or deleting accounts.


    ClosedSimple

    1. Select Simple from the Condition Type drop-down.

    2. Select the Action based on option:

      • All Conditions will apply the pricing rule when all of the specified conditions are met.

        For example, (Price Segment is equal to "abc") AND (Industry Vertical is equal to "123")

      • Any Conditions will apply the pricing rule when any of the specified conditions are met.

        For example, (Price Segment is equal to "abc") OR (Price Segment is equal to "xyz")

      • Complex Conditions will apply the pricing rule when a complex conditions are met.

        For example, (Price Segment is equal to "abc") OR (Price Segment is equal to "xyz") AND (Industry Vertical is equal to "123")

    3. Select Click to add attributes here.

      Edit pricing rule Simple Conditions

    4. Select the desired Attribute.

      Only Header Pricing Attributes are available for selection. For more information on Pricing Attribute options, refer to Pricing Attributes.

    5. Select the Operator.
    6. Enter the desired Value.

    7. Click Save when you've finished editing the attribute line.
      • To add additional conditions, click the Add New Conditions, repeat sub-steps d - g.
      • To edit a condition line, click inside the applicable field and modify value, then click Save when you've finished editing.
      • To delete a condition, click the Delete Delete icon icon .
    8. For Complex Conditions, enter the Complex Grouping.

      For example, (Price Segment is equal to "abc") OR (Price Segment is equal to "xyz") AND (Industry Vertical is equal to "123")

    9. Click Update.

    ClosedAdvanced

    1. Select Advanced from the Condition Type drop-down.

    2. Click the Advanced link.

      Edit pricing rule Advanced condition

    3. If the Pricing Attributes and Library Functions tabs aren't displayed, click Reselect.

    4. Select the applicable Pricing Attributes and Library Functions.

    5. Click Next.

    6. Enter the applicable BML function.

      Sample BML:

      if (quoteType == “subscription”) {
            return true;
      }
      return false;
      
    7. Click Save and Close.


  9. Proceed to Link, Unlink, or Reorder Price Models to link price models to this pricing rule.


ClosedLink, Unlink, or Reorder Price Models

ClosedEdit Pricing Rules

  1. Navigate to the Pricing Engine Pricing Rules page.

    Admin Home Page > Products > Pricing Portal > Pricing Rules

  2. Click on the applicable pricing rule Name link.

Modify Basic Details

  1. Click on the Basic Details Edit button to modify the name, status, start / end dates, or description.

  2. Modify the applicable field.

    • Click in the Name or Description field to update values.
    • Set the Status switch to Active or Inactive.
    • Click in the Start field to set the beginning date and time that a pricing rule will be effective.
    • Click in the End field to set ending date and time that a pricing rule will be effective.

    Edit pricing rule Basic Details

  3. Click Update.

Modify Conditions

  1. Click the Conditions Edit button to change the Condition Type or modify existing conditions.

  2. Select the new Condition Type from the drop-down.

    You will lose your previous condition setup.

    ClosedAlways True

    1. Select Always True from the Condition Type drop-down.
    2. Click Update.

    Conditition - Always True option


    ClosedCustomer Specific

    1. Select Customer Specific from the Condition Type drop-down.
    2. Click the Add button.

      Edit Pricing Rule Accounts

    3. Select the appropriate account from the Account drop-down.

      As you begin typing, the available accounts will begin to filter.

    4. Enter Start and End dates and times for each account in the pricing rule.

    5. (Optional) If you want to inactive the pricing rule for the account, select Inactive from the Status drop-down.

    6. Click Save when you've finished editing the account.

      • To add additional accounts, click Add and repeat sub-steps a - d.
      • To edit an account line, click inside the desired field(s) to modify the values, then click Save when you've finished editing.
      • To delete an account line, click the ellipsis at the end of the line and select Delete.
    7. Click Update after adding, editing, or deleting accounts.


    ClosedSimple

    1. Select Simple from the Condition Type drop-down.

    2. Select the Action based on option:

      • All Conditions will apply the pricing rule when all of the specified conditions are met.

        For example, (Price Segment is equal to "abc") AND (Industry Vertical is equal to "123")

      • Any Conditions will apply the pricing rule when any of the specified conditions are met.

        For example, (Price Segment is equal to "abc") OR (Price Segment is equal to "xyz")

      • Complex Conditions will apply the pricing rule when a complex conditions are met.

        For example, (Price Segment is equal to "abc") OR (Price Segment is equal to "xyz") AND (Industry Vertical is equal to "123")

    3. Select Click to add attributes here.

      Edit pricing rule Simple Conditions

    4. Select the desired Attribute.

      Only Header Pricing Attributes are available for selection. For more information on Pricing Attribute options, refer to Pricing Attributes.

    5. Select the Operator.
    6. Enter the desired Value.

    7. Click Save when you've finished editing the attribute line.
      • To add additional conditions, click the Add New Conditions, repeat sub-steps d - g.
      • To edit a condition line, click inside the applicable field and modify value, then click Save when you've finished editing.
      • To delete a condition, click the Delete Delete icon icon .
    8. For Complex Conditions, enter the Complex Grouping.

      For example, (Price Segment is equal to "abc") OR (Price Segment is equal to "xyz") AND (Industry Vertical is equal to "123")

    9. Click Update.

    ClosedAdvanced

    1. Select Advanced from the Condition Type drop-down.

    2. Click the Advanced link.

      Edit pricing rule Advanced condition

    3. If the Pricing Attributes and Library Functions tabs aren't displayed, click Reselect.

    4. Select the applicable Pricing Attributes and Library Functions.

    5. Click Next.

    6. Enter the applicable BML function.

      Sample BML:

      if (quoteType == “subscription”) {
            return true;
      }
      return false;
      
    7. Click Save and Close.


Modify Linked Price Models

  1. Select this option to link, unlink, or reorder price models.

    ClosedLink Price Model(s) to a Pricing Rule

    ClosedUnlink Price Model from a Pricing Rule

    ClosedReorder Linked Price Models

    Note: Click on the applicable Price Model to edit a linked Price Model.

    Refer to Price Models for editing information.


Notes

 

  • Important: Switching pricing Version options may affect existing pricing and transactions. Oracle recommends thoroughly testing the impact of the new version before implementing the change into a production environment. Once Version 2 or Version 3 is enabled in a production environment, returning transactional data to Version 1 may require significant effort.

    Error messages are not clear in bulk upload/download. Error message will currently not tell you why records have failed. Errors can be viewed in the application Error Logs.

  • Siebel Integration is not currently supported.

Notes:

  • The maximum number of Pricing Rules is 100. Submit a Service Request (SR) on My Oracle Support to change the maximum number.

  • Pricing rules will only be shown in Commerce once an Account has been synced; the Account ID field must be populated.

  • Values in the price model should be populated for all supported currencies for a given part.
    Example: If your application supports USD and EURO, when a part is added to a profile, a price/value should be defined for both the USD and EURO currencies.

Related Topics

Related Topics Link IconSee Also