Rate Cards
Overview
Rate Cards can be used to support subscription-based pricing for industries such as communications, utilities, and cloud services. These industries require invoicing or rating calculations based on multi-dimensional tables to capture complex Pricing Rules, such as for phone call or data storage usage. Pricing Engine supports this type of pricing through the creation of custom Rate Cards for determining the invoice amounts to be billed on a periodic basis. Rate Cards and their associated templates can be used to define complex usage-based pricing, and for rating of actual usage quantities (in Oracle Fusion Pricing).
Rate Card Pages
Rate Cards List Page
The Rate Cards List Page displays available Rate Cards that can be applied to a usage-based charge. Pricing administrators can perform the following tasks from this page:
|
1
|
Navigate to the Pricing Portal.
|
|
2
|
Click
Actions to Add a Rate Card or Manage Columns for the Rate Cards list.
|
|
3
|
Enter search criteria to filter Rate Card results,
which remain persistent while navigating within Rate Cards.
|
|
4
|
Sort
Rate Cards using Name, Variable Name, or Status
column headers.
|
|
5
|
Click
the appropriate Name link or click the line ellipsis and select Edit to edit an existing Rate Card.
|
|
6
|
Click
the Rate Card Template Name link to quickly access linked Rate Card Templates. |
| 7 |
Click
the Linked Price Models number link to view linked Price Models. |
|
8
|
Click
the Rate Card line ellipsis to Edit a Rate Card or Delete an
inactive Rate Card.
|
Rate Card Page
The Rate Card Page shows the basic details and lists the number of Price Models in which this Rate Card is used. It also lists the rows and columns in the Rate Card that will be applied at rating-time to calculate the recurring invoice amounts.
|
1
|
Navigate to Rate Card list page. |
|
2
|
Navigate to Next or Previous Rate Card in the
Rate Card list or filtered Rate Card search results list.
|
|
3
|
Click the Basic Details
Edit button to modify basic details for the Rate Card.
|
|
4
|
Click
the Rate Card Template Name link to quickly access linked Rate Card Templates. |
|
5
|
Click
the Linked Price Models number link to view linked Price Models. |
|
6
|
Enter search criteria to filter Rate Card data results,
which remain persistent while navigating within Rate Cards.
|
|
7
|
Click
Actions and select Edit to edit Rate Card data or select Manage Columns to manage the fields that are displayed as Rate Card data columns.
|
Rate Card Template Pages (Oracle CPQ 23D - 24A)
Beginning in Oracle CPQ 24B, Rate Card Templates are defined in the Pricing Matrix Templates module. To view Pricing Matrix Template pages for Oracle CPQ 24B and Later, refer to Pricing Matrix Templates.
The Rate Card Templates List Page displays available Rate Card Templates that can be used to define one or more Rate Cards. Pricing administrators can perform the following tasks from this page:
|
1
|
Navigate to the Pricing Portal.
|
|
2
|
Click
Actions to Add a Rate Card Template or Manage Columns for the Rate Card Templates list.
|
|
3
|
Enter search criteria to filter Rate Card Template results,
which remain persistent while navigating within Rate Card Templates.
|
|
4
|
Sort
Rate Card Templates using Name, Variable Name, or Status
column headers.
|
|
5
|
Click
the appropriate Name link or click the line ellipsis and select Edit to edit an existing Rate Card Template.
|
|
6
|
Quickly access linked Rate Cards |
|
7
|
Click
the Rate Card Template line ellipsis to Edit a Rate Card Template or Delete an
inactive Rate Card Template.
Note: Rate Card Templates with linked Rate Cards can’t
be inactivated or deleted.
|
The Rate Card Template Page shows the basic details and lists the columns that define the Rate Card. Pricing administrators can perform the following tasks from this page:
|
1
|
Navigate to Rate Card Template list page. |
|
2
|
Navigate to Next or Previous Rate Card Template in the
Rate Card Template list or filtered Rate Card Template search results list.
|
|
3
|
Click the Basic Details
Edit button to modify basic details for the Rate Card Template.
|
|
4
|
Click
Actions to Add, Reorder, or Manage Columns.
|
|
5
|
Click
the appropriate Name link to click the line ellipsis and select Edit to edit an existing Rate Card column.
|
|
6
|
Click
the Rate Card Template line ellipsis to Edit or Delete a Rate Card column.
|
Pricing Matrix Template / Rate Card / Product Charge Relationship
The process for defining a Rate Card pricing involves four steps:
- Define the Lookups and their valid values for any menu type attributes you will use in your Rate Cards.
- Create a Rate Card type Pricing Matrix Template that defines the specific metadata or columns that will be used to define one or more Rate Cards (ex. region, call-to country) using Lookups to define the list of valid values.
- Create a Rate Card using the Rate Card type Pricing Matrix Template to define the specific column values and the resulting per unit prices for each combination of these values.
- Associate the Rate Card with a usage charge for a product (Price Model Item).
Rate Card type Pricing Matrix Templates are provided to specify the custom fields or columns that are included in a Rate Card (e.g. Usage From, Usage To, Rate). The Rate Card is then used to define the necessary rows and values for the pricing table matrix. The Rate Card is then associated with a product charge.
Rate Cards and associated Templates are also supported in the Product Workbench for Oracle CX Sales product managers to define complex pricing for usage-based charges for a product.
CPQ pricing also writes the Rate Card data into the applicable quote line charge items. This information can be included in document outputs to assist sales users in pricing negotiations. The Rate Card data is also integrated to a subscription billing system and referenced in the downstream flow to an order management or fulfillment system.
Administration
Add Rate Card Template Oracle CPQ 23D - 24A
Beginning in Oracle CPQ 24B, Rate Card Templates are defined in the Pricing Matrix Templates module. To add a Rate Card Template for Oracle CPQ 24B and Later, refer to Pricing Matrix Templates.
Complete the following steps to create a Rate Card Template for releases prior to Oracle CPQ 24B (releases 23D - 24A).
-
Navigate to the Admin page.
-
Click Pricing Portal in the Products section.
- Click on the Rate Card Templates card.
- Click Add.
- Enter a name in the Name field.
- Enter the Variable Name.
- (optional) Enter a Description.
- Click Create.
Add Rate Card Template Columns
- Select Add from the Actions drop-down.
- Enter a Name for the Rate Card Template column.
- Enter the Variable Name for the Rate Card Template column.
- Select the Data Type.
-
Select a Pricing Lookup from the Lookup drop-down.
- This field is only available for string data types.
- Refer to Pricing Lookups for more information.
-
(optional) Select or enter a Default Value.
- The default value cannot be specified for currency data types.
- Only True or False values can be selected for Boolean data types.
- When a Lookup is selected, you can select a default value from values defined in Pricing Lookups.
-
Check the Default Value Overridable option if the default value can be modified a sales user.
-
Check Negotiable to allow modification of this attribute at runtime.
-
Check Key to identify this field as a unique identifier.
-
Check Required to make this field mandatory.
-
optional) Enter a Description.
-
Click Create.
Add Rate Card
Complete the following steps to create a Rate Card in the CPQ Pricing Portal.
-
Navigate to the Admin page.
-
Click Pricing Portal in the Products section.
- Click on the Rate Cards card.
- Click Add.
- Enter a name in the Name field.
- Enter the Variable Name.
- Select a Rate Card Template from the drop-down.
- (optional) Enter a Description.
- Click Create.
Add Rate Card Data
- Click Edit in the Data section.
- Click Add.
- Enter the applicable data for the predefined Rate Card columns.
- Click Add to add another Rate Card data row.
- Click
the line ellipsis and select Delete to delete a Rate Card data row.
- Click Save or Update.
Notes
Notes:
- Rate Cards are static objects that do not calculate estimated usage prices but can be used for calculating usage rating invoice amounts based on actual consumption.
- Rate Cards can only be applied to charges with a price type of 'Usage'. When CPQ is integrated with Oracle Fusion Pricing, Rate Cards can only be applied to charges with a price type of 'Usage' and which are members of a Rate Plan.
- Rate Cards can only be applied to charges. Rate Cards are not available for product prices.
- Once created, Rate Cards and Rate Card Templates may be deleted if the Rate Card is not used to price any charges and the Rate Card Template is not used by any Rate Cards.
Related Topics
See Also
