1. Administration Guide
  2. Configuring Transportation Intelligence

Configuring Transportation Intelligence

Enabling Oracle Transportation Intelligence Agents in Oracle Transportation and Global Trade Management

The business objects in Oracle Transportation and Global Trade Management (like shipments, order releases, etc.) are loaded into the Transportation Intelligence tables when they have a status of READY_TO_LOAD. This status is set by automation agents in Oracle Transportation and Global Trade Management. To enable these automation agents, complete the following:

  1. Log on to Oracle Transportation and Global Trade Management as DBA.ADMIN.
  2. Go to Business Process Automation > Agents and Milestones > Automation Agent.
  3. Search for and activate the following automation agents:
    • LOAD_ORDER_BASE_TO_HD (Default Event: Order base created)
    • LOAD_ORDER_RELEASE_TO_HD (Default Event: Order on shipment tendered)
    • LOAD_SHIPMENT_TO_HD (Default Event: Shipment tendered)

Unloading an Oracle Transportation and Global Trade Management Object from Transportation Intelligence

When an object is deleted from Oracle Transportation and Global Trade Management, it has to be removed from the Transportation Intelligence tables also. You need an agent that will automatically take care of deleting objects from TI tables when you delete the object in Transportation and Global Trade Management.

Automation gents need to be created for each object type in Oracle Transportation and Global Trade Management. To create an agent for SHIPMENT, perform the following steps:

  1. Log onto Oracle Transportation and Global Trade Management as DBA.ADMIN
  2. Go to Business Process Automation > Agents and Milestones > Automation Agent. Select New.
  3. Select Agent Type as SHIPMENT.
  4. Select Agent Event as SHIPMENT-REMOVED with restrictions of INTEGRATION, INTERNAL, or USER.
  5. Add Agent Action as UNLOAD SHIPMENT FROM HD.
  6. Give a suitable name for the Agent ID and save the agent.

Any shipments which are now deleted in Oracle Transportation and Global Trade Management will be deleted from the Transportation Intelligence tables when the subsequent ETL is triggered.

Such automation agents need to be created for every needed object in Oracle Transportation and Global Trade Management (like order release, order base etc.). The list of agent actions available in Oracle Transportation and Global Trade Management are:

  • UNLOAD BULK PLAN FROM HD
  • UNLOAD INVOICE FROM HD
  • UNLOAD ORDER BASE FROM HD
  • UNLOAD ORDER BASE LINE FROM HD
  • UNLOAD ORDER BASE SHIP UNIT FROM HD
  • UNLOAD ORDER ITEM FROM HD
  • UNLOAD ORDER MOVEMENT FROM HD
  • UNLOAD ORDER RELEASE FROM HD
  • UNLOAD QUOTE FROM HD
  • UNLOAD SELL SHIPMENT FROM HD
  • UNLOAD SHIPMENT FROM HD

Mandatory Oracle Transportation and Global Trade Management User Role (VPD Profile) Configuration

VPD profile determines what data the user is entitled to see. All users of Oracle Transportation and Global Trade Management should have one of the following profile sets.

  • FTI_DEFAULT: All users who ARE NOT service providers in Oracle Transportation and Global Trade Management should have this profile. Use this profile to access the Logistics Network Modeling Intelligence and Logistics Machine Learning subject areas.
  • SERVPROV: All the users who are service providers in Oracle Transportation and Global Trade Management.

Performing this step is mandatory for the proper operational behavior of Transportation Intelligence application.