Configure Data Sync

The Product Workbench requires that product details be synced to enable pricing in Oracle CPQ. This product data synchronization across the Sales Product Information Master (SPIM) and Oracle CPQ applications can be configured as follows based on the business need:

  • Batch Synchronization, a predefined scheduled synchronization
  • Near Real Time Synchronization, without waiting for a scheduled batch synchronization to occur
  • Both Batch and Near Real Time Synchronization, to use a combination of the two

See Oracle CX Sales SPIM Integration for information about synchronization status details.

See Establish Oracle CX Sales SPIM as the Products Source for an Oracle CX Sales – Oracle CPQ Products Integration for Oracle CPQ parts integration procedures.

Oracle CPQ BOM tables and mapping are required to enable synchronization of Oracle Sales product structures and components to CPQ. See Create and Map CPQ BOM Tables to create and map Oracle CPQ BOM tables.

Note: You need to use Application Composer to configure Routines for "Product" and "Product Structure" objects to enable Near Real Time Synchronization. This will enable you to price products immediately after you've defined your product in the Product Workbench.

Follow the actions and rules in the example screenshots that follow. Configure both "Create" and "Updated" triggered routines for "Product" and "Product Structure" objects.

The screenshot shows an example of the data integration mapping screen.

The screenshot shows an example of the data integration mapping screen.

The screenshot shows an example of the Review section of the edit routine screen.

The screenshot shows an example of the edit routine screen.