Siebel Connector for Oracle Applications > Detailed Data Mappings > Entity Attribute Mappings for Oracle Applications R10.7 >
Product Integration EAM Mappings
This integration associates Oracle global master material items with the Siebel Internal Product business object. The EAM mapping for this integration is shown in Table 6 through Table 9. Entity Mapping
Table 6. Product Integration EAM Mappings
Siebel Business Component |
|
Oracle to Siebel Integration |
Internal Product |
MTL_SYSTEM_ITEMS |
SIE_PRODUCT_V |
Internal Division |
ORG_ORGANIZATION_ DEFINITIONS |
SIE_PRODUCT_V |
FS Inventory Location |
ORG_ORGANIZATION_ DEFINITIONS |
SIE_PRODUCT_V |
Attribute Mapping
Table 7. Product Integration Attribute Mapping (part 1)
Siebel Field (Internal Product) |
|
Oracle to Siebel Integration |
Integration Id |
INVENTORY_ITEM_ ID |
INVENTORY_ITEM_ID |
Description |
DESCRIPTION |
DESCRIPTION |
Orderable |
CUSTOMER_ORDER_ ENABLED_FLAG |
CUSTOMER_ORDER_ ENABLED_FLAG |
Sales Product Flag |
CUSTOMER_ORDER_ FLAG |
CUSTOMER_ORDER_ FLAG |
Sales Service Flag |
SERVICE_ITEM_ FLAG |
SERVICE_ITEM_FLAG |
Unit of Measure |
PRIMARY_UOM_ CODE |
PRIMARY_UOM_CODE (through eAI value map Oracle Unit of Measure) |
Table 8. Product Integration Attribute Mapping (part 2)
Siebel Field (Internal Division) |
(ORG_ORGANIZATION _DEFINITIONS) |
Oracle to Siebel Integration |
Integration Id |
OPERATING_UNIT |
OPERATING_UNIT |
Default Shipping Org Int Id |
MTL_SYSTEM_ITEMS. DEFAULT_SHIPPING _ORG |
DEFAULT_SHIPPING_ ORG |
Status |
MTL_SYSTEM_ITEMS. INVENTORY_ITEM_ STATUS_CODE |
INVENTORY_ITEM_ STATUS_CODE |
Table 9. Product Integration Attribute Mapping (part 3)
Siebel Field (FS Inventory Location) |
(ORG_ORGANIZATION _DEFINITIONS) |
Oracle to Siebel Integration |
Integration Id |
MTL_SYSTEM_ITEMS.ORGANIZATION_ID |
ORGANIZATION_ID |
|