1. E-Business Suite Integration Guide
  2. Items

Items

If both integrations are implemented, there will be multiple instances in the Oracle Transportation Management/Oracle Global Trade Management database of the item.

Oracle E-Business Suite to Oracle Transportation Management

  • Items are created “on the fly”, meaning they are sent to Oracle Transportation Management at the time the order is sent from Oracle E-Business Suite. An item master concept is not part of this solution.
  • If using Oracle Global Trade Management, you could change the PO/Delivery mapping within the Oracle E-Business Suite /Oracle Transportation Management integration BPEL flows to use the ID as it’s created in Oracle Global Trade Management rather than creating new ones “on the fly”.
  • Item ID is Inventory Item ID concatenated with the Org ID.
  • Oracle Transportation Management PackagedItemGid and Oracle Transportation Management Item.ItemXid = MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID"-"MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID

Oracle E-Business Suite ITM to Oracle Global Trade Management

  • Sent over to Oracle Global Trade Management to be synched in a batch via the ITM Adapter Item synch process, the item master concept rather than the “on the fly” concept.
  • Item ID is the Inventory Item ID
  • Oracle Global Trade Management ItemGid/Gid/Xid = MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID