Item Synchronization
This table displays the item synchronization mapping details from Oracle E-Business Suite to Oracle Global Trade Management.
| Oracle E-Business Suite Source | Oracle E-Business Suite Element | Oracle Global Trade Management Element | Details |
|---|---|---|---|
|
MTL_SYSTEM_ITEMS_B.inventory_item_id NUMBER |
ITEM_SYNC/DATAAREA/ ITEM/ITEM_ID |
GLogXMLElement/ItemMaster/Item/ItemGid/Gid/Xid | |
|
MTL_SYSTEM_ITEMS_B. Segment1||segment2||segment3 Concatenation of Segments: VARCHAR2(850) |
ITEM_SYNC/DATAAREA/ ITEM/ITEM_CODE |
GLogXMLElement/ItemMaster/Item/ItemName | |
|
MTL_SYSTEM_ITEMS_TL.DESCRIPTION VARCHAR2(240) |
ITEM_SYNC/DATAAREA/ ITEM/DESCRIPTION |
GLogXMLElement/ItemMaster/Item/Description | |
|
PO_HAZARD_CLASSES_TL.HAZARD_CLASS VARCHAR2(40) |
ITEM_SYNC/DATAAREA/ ITEM/HAZARD_CLASS |
GLogXMLElement/ItemMaster/Item/Remark/RemarkText | RemarkQualGid=”HAZARD_CLASS” |
|
MTL_SYSTEM_ITEMS_B.organzation_id NUMBER |
ITEM_SYNC/DATAAREA/ ITEM/ORGANIZATION_ID |
GLogXMLElement/ItemMaster/Item/Remark/RemarkText | RemarkQualGid=” ORG_ID” |
|
MTL_SYSTEM_ITEMS_B.source_organization_id NUMBER |
ITEM_SYNC/DATAAREA/ ITEM/SRC_ORGANIZATION_ID |
GLogXMLElement/ItemMaster/Item/Remark/RemarkText | RemarkQualGid=”SRC_ORG_ID” |
|
FND_LOOKUP_VALUES.Meaning VARCHAR2(80) |
ITEM_SYNC/DATAAREA/ ITEM/ITEM_TYPE |
GLogXMLElement/ItemMaster/Item/Remark/RemarkText | RemarkQualGid=”ITEM_TYPE” |
| ORG_ORGANIZATION_DEFINITIONS. OPERATING_UNIT NUMBER |
ITEM_SYNC/DATAAREA/ ITEM/USERAREA/ ORACLE.ITEM_SYNC. ITEM.USERAREA/ ORACLE.OPERATING_UNIT |
GLogXMLElement/ItemMaster/Item/Remark/RemarkText | RemarkQualGid=”EBS_OP_UNIT” |
|
MTL_SYSTEM_ITEMS_B. PRIMARY_UOM_CODE VARCHAR2(3) |
ITEM_SYNC/DATAAREA/ ITEM/UNIT_OF_MEASURE |
GLogXMLElement/ItemMaster/Item/UnitOfMeasure | |
|
MTL_SYSTEM_ITEMS_B. LIST_PRICE_PER_UNIT NUMBER GL_LEDGERS_PUBLIC_V.CURRENCY_CODE VARCHAR2(50) |
ITEM_SYNC/DATAAREA/ ITEM/ITEM_VALUE ITEM_SYNC/DATAAREA/ ITEM/CURRENCY |
GLogXMLElement/ItemMaster/Item/PricePerUnit/ FinancialAmount/MonetaryAmount GLogXMLElement/ItemMaster/Item/PricePerUnit/ FinancialAmount/GlobalCurrencyCode |
Add a Price Per Unit Value field to the Item Master Add a currency field to accompany the Price Per Unit Value field |
| MTL_SYSTEM_ITEMS_TL. LONG_DESCRIPTION VARCHAR2(4000) |
ITEM_SYNC/DATAAREA/ ITEM/USERAREA/ ORACLE.ITEM_SYNC. ITEM.USERAREA/ ITEM.LONG_DESCRIPTION |
The default mapping given in the StyleSheetContent ‘DEFAULT_ITEM_SYNC_STYLESHEET’ is used by the system to generate Oracle Global Trade Management XML for inserting item data as Oracle Global Trade Management item unless it is overridden. The sample EBS and transformed GTM XMLs appears in the Appendix: XML Samples chapter, in the Item Synchronization section.