Siebel Connector for Oracle Applications > Detailed Data Mappings > Entity Attribute Mappings for Oracle Applications >
Product Integration EAM Mappings
This integration associates orderable Oracle global master material items with the Siebel Internal Product business object. The EAM mapping for this integration is shown Table 26 to Table 29. Entity Mapping
Table 26. Product Integration EAM Mapping
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 27. 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 28. 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 29. 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 |
|