BOM Tables

Overview

Oracle CPQ provides five BOM Mapping platform tables to support the full BOM Mapping solution: BOM Item Definition, BOM Item Mapping, BOM Attribute Definition, BOM Attribute Mapping, and BOM Attribute Translation. Many customers may only require one or two of these tables to implement their use cases.

The BOM Mapping platform tables contain the schema for associating BOM structures to Configuration attribute values. Customer-specific mapping details are stored in Oracle CPQ Data Tables. The combination of these two sets of tables enables administrators to create simple Table-Based Configuration rules to associate fulfillment system BOMs, Oracle CPQ Configuration attributes, and Commerce transaction lines without the need for BML or other logic.

Administrators upload or migrate BOM structures to Oracle CPQ Data Tables using CPQ’s standard importing features. These Data Tables can then be linked to the corresponding BOM Mapping platform tables for use in BOM Mapping rules, as shown in the illustration below.

Mapping CPQ BOM Data Tables to CPQ BOM Platform Tables

Oracle CPQ provides standard, down-loadable Data Table definitions that can be used to create the implementation-specific tables, which map automatically to the BOM Mapping platform tables. Alternatively, customers can reuse existing Data Tables containing BOM structure details by mapping the columns in their tables to the BOM Mapping platform tables. The new Edit BOM Table Definition page provides drop-down menus for column mapping and Data Table definitions for download.

Administrators must activate the required BOM Mapping platform tables, and populate BOM Mapping Data Tables prior to BOM Mapping.

Oracle CPQ has five BOM tables:

BOM Table Relationships

BOM Mapping uses variable names as references to capture hierarchical relationships. BOM Mapping also uses variable names to identify relationships between BOM tables. The following image illustrates these relationships.

BOM Table Relationships

BOM Table Relationships

Administration

ClosedAccess BOM Tables

To access and manage BOM Tables:

  1. Click Admin to go to the Admin Home Page.

  2. Click BOM in the Products section.

    The  BOM Administration Platform page opens.

  3. Click BOM Tables in the BOM Declaration section.

    The Bills of Materials Tables page opens. This page is used access to BOM Mapping tables, shows mapping status, and activate tables.

Notes

Note: Changes to 'Live' Data Tables are not immediately reflected in configuration data for BOM Mapping or System Configurations. Therefore, Oracle CPQ does not recommend using 'Live' Data Tables with BOM Mapping or System Configuration.

Related Topics

Related Topics Link IconSee Also