Overview
The BOM Item Mapping Table associates BOM items to Configuration attributes. This table is not required for implementations, if required administrators will 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.
Activating this table enables simple Table-Based BOM Mapping Rules. If this table is not active, administrators would use advance BML-Based Rules to establish the association between BOM items and Configuration attributes. The following image shows the how the BOM Item Mapping Data Table “ConfigAttrVarName” and “ConfigAttrValue” items relate to the Configuration attributes.
Default table name: Oracle_BomItemMap
|
Index |
Key |
Name |
Type |
Required |
Display Name |
Description / Comments |
|---|---|---|---|---|---|---|
|
|
Y |
VariableName |
String |
Y |
Variable Name |
The primary key column of this table. |
|
|
|
BomItemVarName |
String |
Y |
Bom Item Variable Name |
The variable name of the BOM item. It is a foreign key to BomItemDef.VariableName. The BOM item must exist, otherwise it is a validation error. |
|
|
|
ConfigAttrVarName |
String |
|
Configurable Attribute Variable Name |
The variable name of the configurable attribute. Nullable. Configuration attribute variable Name. If not null, the BOM item is created when the configurator attribute has a matching value at buy-side to the value stored in "ConfigAttrValue" column If null, the BOM item is created unconditionally. |
|
|
|
ConfigAttrValue |
String |
|
Configurable Attribute Value |
The value of the configurable attribute. Nullable. Configuration attribute value. Null is interpreted as an empty string. |
|
|
|
ConfigAttrVarName1 |
String |
|
Configurable Attribute Variable Name 1 |
Additional mapping attribute name fields to support mapping to multiple Configurable Attributes. For more information refer to Multiple Attribute Mapping for BOM Mapping Items. |
|
|
|
ConfigAttrValue1 |
String |
|
Configurable Attribute Value 1 |
Additional mapping attribute value fields to support mapping to multiple Configurable Attributes. For more information refer to Multiple Attribute Mapping for BOM Mapping Items. |
|
Y |
|
ParentBomMapVarName |
String |
Y |
Parent BOM Map Variable Name |
The variable name of the BOM Map configuration rule. Fully qualified BOM mapping configuration rule variable name, in the format of productFamilyVarName:productLine VarName:modelVarName:configRuleVarName. For example, testFamily:testLine:testModel: testBomMap Orphan records of invalid BOM mapping rule variable names are ignored. |
|
|
|
EffectiveFrom |
String |
|
Effective From |
The effective from date. Formatted as YYY-MM-DD HH:mm:ss |
|
|
|
EffectiveTo |
String |
|
Effective To |
The effective to date. Formatted as YYY-MM-DD HH:mm:ss |
Multiple Attribute Mapping for BOM Mapping Items
Beginning in Release 18B, Oracle CPQ provides ten additional mapping attribute and value fields for the BOM Item Mapping table to support mapping to multiple Configurable Attributes. This allows the selection of multiple configuration options to add a single Line Item to a BOM-related Transaction.
Additional Configurable Attributes for BOM Item Mapping
The BOM Item Mapping Table associates BOM items to Configuration attributes. Administrators will upload or migrate BOM structures to Oracle CPQ Data Tables using CPQ’s standard importing features. The Data Table can then be linked to the corresponding BOM Mapping platform tables. Activating this table enables simple Table-Based BOM Mapping Rules. The items that are available for mapping are displayed in the Column Mapping drop-down menus. The list of menu options is derived from the BOM Item Mapping Data Table columns Names.
Configurable Attribute Columns in the BOM Item Mapping Data Table
Prior to mapping, the additional Configurable Attribute and Value fields must be added to the BOM Item Mapping Data Table Schema tab. The following image displays a BOM Item Mapping Data Table with ten additional Configurable Attribute and Value columns added to the Data Table schema.
Multiple Attribute Mapping Example
After the additional Configurable Attribute and Value fields have been added to the BOM Item Mapping Data Table schema, the Data Table can be populated with the additional Configurable Attributes and Values. BOM Mapping can now evaluate the combination of several different Configuration attributes and then add a single child part to the quote based on multiple attribute selections.
For example: The following BOM Item Mapping Data displays two BOM items with "speed" and "dataDownload" attributes. If a user selects a speed of 40Mbps and a data download option of 100GB, then the TelecomPackage1 part will be added to the quote.
When additional Configurable attributes have been added and mapped, administrators can view the mapped attributes in the BOM Item Mapping Administration List and BOM Item Mapping Administration pages.
In the following image, the mapped Configuration Attributes are shown. If there are any Additional Configurable Attributes, the Additional Attribute Mapped column will be set to Y.
The BOM Item Mapping details for "TelecomPackage1" are displayed in the following image. When "40Mbps" is selected for the "speed" attribute and "100GB" is selected for the "dataDownload" attribute, the TelecomPackage1 part will be added to the quote.
For instructions to access the BOM Item Mapping Administration List and BOM Item Mapping Administration pages, refer to BOM Item Mapping Administration Pages.
Map Multiple Values for Menu Attributes to a Single BOM Item
Delimiters for Single Select Menus and Pick Lists
Oracle CPQ allows delimiters for Configuration Single Select Menu (SSM) and Single Select Pick List (SSPL) menu options to allow administrators to map multiple menu options for SSM and SSPL attributes to a single BOM Item Mapping table record. Administrators can use the ^|^ delimiter to specify the OR operation for multiple SSM or SSPL menu options in the BOM Item Mapping table. Without this operation, the BOM Item Mapping table would require an additional record for each option to provide the same functionality.
For example, a company wants to add a warranty if a customer selects any of the monitors offered. The administrator could add the monitorWarranty line to the BOM Item Mapping table. The monitor19^|^monitor24^|^monitor27 ConfigAttrValue ConfigAttrValue will add the monitorWarranty when a 19 inch Monitor, 24 inch Monitor, or 27 inch Monitor are selected from the extraMonitor Single Select Menu in Configuration.
- Oracle CPQ only supports the ^|^ delimiter for SSM and SSPL attributes. An error will be generated if the ^|^ delimiter is used with any other attribute type.
- SSM and SSPL attributes cannot use the ~ delimiter.
Delimiters for Multi-Select Menus
Oracle CPQ allows delimiters for Configuration Multi-Select Menu (MSM) attributes to allow administrators to map multiple MSM meuu options to a single BOM Item Mapping table record. Administrators can use the ~ delimiter to specify the AND operation for multiple MSM menu options in the BOM Item Mapping table.
For example, a company wants to offer a one year internet promotion if a customer signs up for three TV channel packages. The administrator could add the1yrInternetPromo line to the BOM Item Mapping table. The newTV~sportsTV~movieTV ConfigAttrValue will add the 1yrInternetPromo when News, Sports, and Movie are selected from the channelTypes Multi-Select Menu in Configuration.
- Oracle CPQ only supports the ~ delimiter for MSM attributes. An error will be generated if the ~ delimiter is used with any other attribute type.
- MSM attributes cannot use the ^|^ delimiter.
Administration
Download a Sample Data Table for BOM Item Mapping
- Click Admin to go to the Admin Home Page.
-
Click BOM in the Products section.
The BOM Administration Platform page opens.
-
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.
-
Click BOM Item Mapping.
The Edit BOM Table Definition page for the BOM Item Mapping table appears.
-
Click Download Sample Datatable.
- Click Admin to go to the Admin Home Page.
-
Click BOM in the Products section.
The BOM Administration Platform page opens.
-
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.
-
Click BOM Item Mapping.
The Edit BOM Table Definition page for the BOM Item Mapping table appears.
-
Select the appropriate table in the Table Name drop-down menu.
If the selected Data Table column names and data types match the default, the column mapping is automatic. If the column names and data types do not match, map the columns manually. Select the appropriate columns from the Column Mapping drop-down menus.
4. Click Save, when column mapping is complete.
Notes
Best Practices
When using Single Select Menus, Multi-Select Menus, or Single Select Pick Lists in a BOM Mapping implementation CPQ recommends that all menu option values are mapped in the BOM Item Mapping table to ensure proper operation.
For more information, refer to BOM Mapping Implementation Resources.
