Global Currencies Supported in TI and GTI

Oracle TI and GTI display reports in 3 different global currencies which are configured in OTM. Cost-related facts in the TRANSPORTATION INTELLIGENCE subject area contain 3 extra fields for each cost. You can use global currencies for the following analysis folders:

• Invoice Analysis
• Invoice Line Analysis
• Order Release Analysis
• Order Movement Analysis
• Shipment Analysis
• Shipment Line Analysis
• Shipment Order Release Analysis
• Shipment Order Release Line Analysis
• Tender Performance Analysis
• Bulk Plan Analysis
• Shipment Claim Analyis
• Rate Analysis

1. Configure 3 global currencies in OTM via the report common properties shown below. (Do not change 3 global currencies after the initial configuration as this might cause data discrepancy).
2. The exchange rates for the 3 global currencies are calculated as follows:
   1. Latest effective date is determined based on the shipment start time.
   2. The exchange rates for 3 global currencies are taken for the latest effective.
3. In the HDOWNER database, the fact tables for the analysis folders list above have 3 extra columns to hold global currencies’ exchange rates.
4. The cost value for the global currency columns in each analysis folder is calculated as follows:
   1. Base cost * exchange rate of global currency.
   2. The multiplied amount is displayed for each of the global currency fields in each analysis folder.

Configure the following report common properties (Business Process Automation > Power Data > Document Generation > Report Common Properties):

Property	Default Value	Description
GLOBAL_CURRENCY1 GLOBAL_CURRENCY2 GLOBAL_CURRENCY2		During installation in OTM, use these properties to configure three global currencies in which you would want to see the cost-based reports in TI. Note: Once these properties are set, it is recommended not to change the values.
EXCHANGE_RATE_GID	Default	Use this property to configure exchange rate in Oracle Transportation Management (OTM) to fetch exchange rates for objects (Bulk Plan, Order Release, Order Movement) that don’t have SHIPMENT GID. These exchange rates will be used to display the global currency values in the cost-based reports.