Oracle Fusion Pricing Integration

Overview

CPQ provides productized integration to synchronize price definitions involving usage charges, Rate Plans, and Rate Cards between the Oracle Fusion Pricing module (also known as QP) and CPQ for subscription-based products to support usage-related rating and invoicing and creation of subscriptions in Oracle Subscription Management.

CPQ synchronizes pricing setup entities including Rate Plans, Rate Cards and usage Charges to Oracle Fusion Pricing on demand, then writes the identifiers of these objects at runtime into quote charges, which can then be integrated downstream to Oracle Fusion Pricing via Oracle Fusion Order Management. For additional information, refer to Support Rate Plans for Oracle Order Management - CPQ Integrations.

When integrated with CPQ, Oracle Fusion Order Management applies the net prices negotiated in CPQ as pre-priced sales order lines. Oracle Order Management uses the Rate Plans, Rate Cards and usage prices integrated from CPQ to perform the rating of actual usage and the calculation of invoice amounts.

Integrate Base Pricing from Oracle Fusion Pricing

Beginning in Oracle CPQ 24D, Oracle provides customers a productized mechanism to automatically synchronize base price lists from Oracle Fusion Pricing into CPQ Pricing Engine that ensures the most up-to-date pricing information in CPQ, minimizes the risk of pricing discrepancies, and eliminates manual data entry and redundant data uploads. This feature enables the transfer of pricing elements like price models, price model items, charges, and rate plans directly from Fusion Pricing to CPQ. The synchronization process leverages CPQ Bulk Data Services APIs, ensuring efficient and reliable data transfer.

Support for this productized integration is provided by a list page for scheduling integration executions and a page for monitoring the progress and completion of integration instances. In addition, seeded mappings of attributes between the two applications are provided for turn-key integration support.

Note: Base Pricing Integration from Oracle Fusion Pricing to Oracle CPQ is set up in Oracle Fusion Pricing.

Fusion Pricing Integration

The Pricing Portal Pricing Integration module allows CPQ pricing administrators to define the Default Partner Price List and initiate synchronization of price definitions between CPQ and Oracle Fusion Pricing. The initial synchronization will synchronize all relevant price definitions. Thereafter only delta changes are sent. Pricing administrators can click on the desired Log link to view details for the synchronization task including deleted pricing definitions, updated Price Model Items, and new Price Model Items.

Pricing Sync

Synchronization of price definitions with Oracle Fusion Pricing will provide synchronized usage charges, Rate Plans, and Rate Card data for Oracle Order Management orders.

ClosedSynchronized Quote with Charges Example

For example, the following CPQ quote shows the Supremo IOT Data product with two charges.

View Rate Card

Charge 2 uses a Rate Card to provide tiered usage-based charges. Sales users can click View Rate Card to display the associated tiered charges.

View Rate Card Details

When an order is created in Oracle Order Management, billing users can view the applied usage charges in the customer order.

Order Management Rate Plan

When Rate Card data is associated with an order, user can click the Usage charge link to view synchronized Rate Card data from Oracle Fusion Pricing.

Order Management Rate Plan details


ClosedSelect Oracle Fusion Pricing Integration IDs

The Integration ID values are provided for Charge Definitions, Price Models, Pricing Lookups, and Rate Card Templates.

Select Integration ID

The Integration ID drop-down also displays a dynamic matrix of related lookup values from Oracle Fusion Pricing.

Releated Lookup Values from Oracle Fusion Pricing


 

Administration

ClosedSet up a CPQ-Oracle Fusion Pricing Integration

Prerequisites

  • Oracle Fusion Pricing and Oracle Subscription Management must be implemented.
  • Before defining other pricing, set up the same values in both CPQ and Oracle Fusion Pricing for the following objects: Charge Types, Price Types, Price Periods, Usage UOMs, and Charge Definitions.
  • If Rate Cards will be used, the columns used for the cards must be defined in Oracle Fusion Pricing Matrix Classes with the same domains of values as in CPQ.

Complete the following steps to set up a CPQ-Oracle Fusion Pricing integration.

  1. Navigate to the Admin page.
  2. Click Integration Center in the Integration Platform section.
  3. Click Create Integration.
  4. Select Generic Integration from the Type drop-down.

    Oracle Fusion Pricing Price Lists are integrated and available in the Default Partner Price List drop-down in CPQ Pricing Integration.

    Fusion Pricing Integration

  5. Enter "Fusion Pricing Integration" for the Name.
  6. Enter the Request URL for the Oracle Fusion Pricing application.
  7. Enter the Username and Password login credentials.
  8. Select the Enable Integration option.
  9. Click Save.

ClosedDefine the Default Partner Price List

Complete the following steps to define the default partner price list.

  1. Navigate to the Admin page.

  2. Click Pricing Portal in the Products section.

  3. Click on the Pricing Integration card.

  4. Click Edit.

  5. Select the applicable price list from the Default Partner Price List drop-down.

    Integrated Price List

  6. Click Update.


 

Notes

Refer to the following documents for more information focused on Oracle Sales to Oracle CPQ integration implementation.

Notes:

  • As the integration is based on CPQ Pricing Engine, you should use pricing behavior Version 2 or higher. For more information about pricing behaviors, refer to Pricing Options.

  • To apply Volume-type tier pricing to a usage charge in Oracle CPQ 23D, create a Rate Card with the from / to tier dimensions as columns.
  • Note that Oracle Fusion Pricing Integration does not support tier pricing with rating usage. Only volume tiering is supported.

Related Topics

Related Topics Link IconSee Also