BOM Attribute Translation Table

Overview

The BOM Attribute Translation Table associates translations for the applicable attributes. BOM attribute variable references associate the fulfillment system translation with the applicable 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.

The versatility of the BOM Mapping feature allows administrators to choose among a variety of options for implementation. Administrators must activate and map only those BOM Mapping tables needed to support their requirements. For more information refer to BOM Mapping Use Cases.

As shown in the image below, the BOM Attribute Translation table provides three translations for BOM Attribute variable “BSO3901”: zh_CN – Chinese (Simplified), ja_JP - Japanese, and de – German.

BOM Attribute Translsations data table correlation to BOM Attribute Definition data table

ClosedBOM Attribute Translation Table Schema

Default table name: Oracle_BomAttr_Tr

Index

Key

Name

Type

Required

Display Name

Description / Comment

Y

Y

VariableName

String

Y

Variable Name

The primary key column of this table.

 

 

Language

String

Y

Language

The language in which the translations of the given record is defined. For example: de for German, zh_CN for Chinese Simplified

 

 

BomAttrVariableName

String

Y

BOM Attribute Variable Name

The variable name of the parent BOM attribute. Key to BomAttrDef.VariableName.

Orphan records of dirty BOM attribute variable names are ignored.

 

 

Name

String

 

Name

The translation of display name, corresponding to BomAttrDef.Name.

 

 

Values

String

 

Values

The translation of values of the attribute, corresponding to BomAttrDef.Values

Y

 

RootBomItemVarName

String

Y

Root BOM Item Variable Name

The variable name of the root BOM item.

Key to BomItemDef.VariableName of the root BOM item definition.

Orphan records of dirty root BOM item variable names are ignored.

Administration

ClosedDownload a Sample Data Table for BOM Attribute Translation

  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.

  1. Click BOM Attribute Translation.

    The Edit BOM Table Definition page for the BOM Attribute Translation table appears.

    Edit BOM Table Definition page for the BOM Attribute Translation table

  2. Click Download Sample Datatable.

ClosedMap a BOM Attribute Translation Table

A BOM Attribute Translation Data Table must be uploaded to Oracle CPQ prior to mapping.
  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.

  1. Click BOM Attribute Translation.

    The Edit BOM Table Definition page for the BOM Attribute Translation table appears.

  2. 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.

Edit BOM Table Definition page for the BOM Attribute Translation table correlations


Related Topics

Related Topics Link IconSee Also