Oracle Transportation and Global Trade Management Business Object Resources

Oracle Visual Builder Add-in for Excel provides support for Oracle Transportation and Global Trade Management Business Object Resources (OTM-GTM). OTM-GTM is a global transportation and logistics operations system that allows companies to manage their global trade operations.

See REST API for Fusion Cloud Transportation and Global Trade Management Business Object Resources.

When creating a layout for an OTM-GTM service, enter the service metadata endpoint for a given business object using this format:

<host>/logisticsRestApi/resources-int/v2/metadata-catalog/<resource_name>

where <resource_name> is the business object name. For example, the endpoint for an equipmentTypes business object would look like this: <host>/logisticsRestApi/resources-int/v2/metadata-catalog/equipmentTypes

See Create a Table Layout in an Excel Workbook.

You can create searches and download parameters for OTM-GTM workbooks. If you configure a search and a q parameter for a layout, the add-in merges them using the AND operator.

OTM-GTM Support Limitations

Keep these limitations in mind when configuring workbooks for OTM-GTM:

  • Business objects with item identifier values containing forward slashes (/) are not supported.
  • The Search Editor does not support queries on:
    • Object-based fields or subfields of object-based fields
    • Fields of child entities. Use download parameters for these fields.
  • Workbooks that include OTM-GTM catalogs are no longer compatible with earlier versions of the add-in.
  • The endpoints under /custom-actions/ are not supported.
  • Warehouse Management APIs are not supported.