1. E-Business Suite Integration Guide
  2. Parties/Locations

Parties/Locations

If both integrations are implemented there will be multiple instances in the Oracle Transportation Management/Oracle Global Trade Management database of certain contacts and locations, some specific to Oracle Transportation Management and some specific to Oracle Global Trade Management.

Oracle E-Business Suite to Oracle Transportation Management

  • Location/Customer/Party master not synced between Oracle E-Business Suite and Oracle Transportation Management independent of a delivery, customer locations are created “on the fly” as they are sent over with the Delivery, there is no master load of customer party/location data in this point to point integration.
  • Carrier synch process sends Oracle E-Business Suite carriers to Oracle Transportation Management as service providers, XID = CAR"-"WSH.WSH_CARRIERS.CARRIER_ID
  • Mapping details for customer
    • Creates new corporation for each customer with CorporationName = AR.HZ_PARTIES.PARTY_NAME (via CUST_ACCOUNT_ID) and the id the same as the location id.
    • Location.LocationXid = CUS"-"AR.HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
    • Location.LocationName = AR.HZ_PARTIES.PARTY_NAME (via CUST_ACCOUNT_ID)

Oracle E-Business Suite ITM to Oracle Global Trade Management

  • Locations/parties are created in advance via the Party Synchronization process as described above.