14.1.4 Currency Exchange Rates Workflow

Exchange Rates are loaded for a version, As of Date, which holds the information related to the Legal Entity, Time Zone, Start Time and End Time, and Organization Unit.

The Stage Currency Exchange Rates is the Input Table in the Currency Exchange Rates Process. The types of Data accepted in the Input Table are as follows:

• As of Date
• Effective Start Date
• Effective End Date
• Source Currency
• Target Currency
• Currency Rate Type (Seeded List of Values are Spot Rate, Average for the Day, Start of the Period, and End of the Period)
• Currency Rate Nature (Seeded List of Values are Floating, Fixed, Forecast)
• Currency Rate Version
• Exchange Rate
• Data Source

To use the Currency Exchange Rates Data Services, do the following:

1. Create an Exchange Rates Pipeline using the following procedure:
   1. Navigate to the Process Modeller Page. On the Home page, click Process Orchestration.

      The Process Modeller Page is displayed.

   2. Click the Add Button. A Process Flow Page with the Process Details Page is displayed.
      1. Enter Process Name and Process Description.
      2. On the App Package ID list, select Data Foundation.
      3. Select the Type as Run Pipeline.
      4. Select Oracle Financial Services Data Service for Analytics_WS001 for the Service ID_Workspace.
      5. To save the changes, click the Apply Button.
   3. On the Process Flow Page, to design the Process Flow on the Drawing Canvas, use a Widget Component available in the floating tool bar.
   4. To load all the Exchange Rates into the Stage Currency Exchange Rates Entity, add a Connector to the START. For information about creating a Connector, see the Ingesting Data into AFCS section.
   5. To connect the START Node with the Connector, right-click on the START Node and select Start Link, then right-click on the Connector and select End Link.
   6. Drag an ExchangeRates Widget to the Canvas.
   7. To connect the Connector Node with ExchangeRates, right-click on the Connector and select Start Link, then right-click on the ExchangeRates Widget and select End Link.
   8. Click the Save Button.

      A Confirmation Acknowledgment Message is displayed: Successfully saved.

2. Execute the Exchange Rates Pipeline using the following procedure:
   1. On the Process Modeller Page, click the Menu corresponding to the Exchange Rates Pipeline. Click Execute Run.

      The Process Flow Page with Execution is displayed.

   2. Select the Execution Type as With Parameters. Select the required As of Date for which the Exchange Rates needs to be processed. Click the Apply Button to initiate the Run Pipeline Execution.
   3. The Exchange Rates Pipeline loads the Preparation Currency Exchange Rates Entity.
   4. d. To verify the Execution Status, on the Process Modeller Page, for the Exchange Rates Pipeline, click the Menu and select the Process Flow Monitor.

      The Process Monitor Page is displayed with the list of Exchange Rates Process ID. Select the Process ID. The Process Flow Page is displayed with the Execution status of the Exchange Rates Pipeline.

Note:

By default, the number of failed records are saved in the Execution Log file. To view more details on the failed records, see Data Visualization Reports.

Note:

If the Effective Start Date and Effective End Date are mentioned in the Stage Currency Exchange Rates Entity, then the Rate is considered for a Period. Otherwise the Effective Start Date will be same as the Effective End Date.

Note:

Execution of the Exchange Rates Pipeline Processes the Input Data from the Stage Currency Exchange Rates Element using the Triangulation or the Inverse Methods, and populates the Processing Entity. The Period Rates will be exploded for the complete Date Range.

1. If the Exchange Rates for a Period is present, then the Direct Rates are loaded for individual Rates for each Date.
2. If the Inverse for all the above Dates are not present in the Stage Currency Exchange Rates Entity, then the Inverse is calculated and loaded to Preparation Currency Exchange Rates Entity.
3. Triangulation for the Rates is done only if any Date intersection is present.