The purpose of the Currency Exchange Rates Entity is to offer the value of one currency in relation to another currency. The Currency Exchange Rates Entity stores the list of all Exchange Rates for all Currency Types.
Topics:
· About Currency Exchange Rates
· Staging
· Currency Exchange Rates Workflow
Currency Exchange Rates Service consists of the following Conceptual Modules:
· Staging: In this Module, the Data is provided on a Date or a Period granularity level.
· Preparation: If the Data is provided for a Period, then that Data is exploded (split) based on the individual Date granularity.
Inputs to the Data Service can be provided using any of the following granularities:
· Date: Rates are provided at the Date Granularity and they can be as follows:
§ Average for the Day
§ Spot Rate
§ Start of the Period
§ End of the Period
· Period: Rates are provided for a Period (Effective Start Date and Effective End Date). This is typically used for internal computations to avoid Currency Rate fluctuations that affect incentive, pricing, estimates, budgets, and so on.
The Time Granularity Level in the Currency Exchange Rates is supported as follows:
· Time Granularity may include the following:
§ Beginning of the Day
§ Mid-day
§ End of the Day
§ Any time (Running Variable), for example, 11 A.M. Rates and 4 P.M. Rates.
· For each Time Granularity that needs to be captured, a Data Version needs to be created in the Data Version Dimension Entity.
· Currency Exchange Rates are provided in the Staging along with the Data Version information. For example, this enables the User to stamp the Currency Exchange Rates given for three days at 08:00, 08:01, 07:59 as the 'Beginning of the day'.
The Rate Type and its description are as follows:
· EOP and SOP (Start of the Period for the day and End of the Period for the day): Rate is provided with the Time Stamp.
· Average for the Day: Average for the Day is provided by the Source.
The Rate Type and its description are as follows:
· Floating (FLTG): This is the Floating Rate prevailing in the market.
· Fixed (FIXED): This is the Rate fixed by the Bank or Regulator (for Reporting) for a particular purpose. For example, Pricing.
· Forecast: These are the Rates forecast and provided by a Cloud Service.
The Preparation Stage details are as follows:
· Currency Exchange Rates provided at the Date Granularity are loaded directly into the Processing Entity.
· Currency Exchange Rates provided for a Period are exploded to a Date Granularity and loaded at the Date Granularity Level.
· Post data population as stated above, for currencies which are active in the Currency Dimension Entity, if there are missing data points between all possible currency pairs, then the data is populated using the following methods:
§ Inverse
§ Triangulation
· At the end of the data population routine or module, the Exchange Rate is available in time and date, and date granularity.
· If the data is arrived at using inverse or triangulation, then the Data is flagged. Therefore, you can understand whether the Rate in use is traceable to a Source.
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:
a. Navigate to
the Process Modeller Page. On the Home page, click Process
Orchestration.
The Process Modeller Page is displayed.
b. Click the Add Button. A Process Flow Page with the Process Details Page is displayed.
i. Enter Process Name and Process Description.
ii. On the App Package ID list, select Data Foundation.
iii. Select the Type as Run Pipeline.
iv. Select Oracle Financial Services Data Service for Analytics_WS001 for the Service ID_Workspace.
v. To save the changes, click the Apply Button.
c. On the Process Flow Page, to design the Process Flow on the Drawing Canvas, use a Widget Component available in the floating tool bar.
d. 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.
e. 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.
f. Drag an ExchangeRates Widget to the Canvas.
g. 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.
h. Click the
Save Button.
A Confirmation Acknowledgment Message is displayed: Successfully
saved.
2. Execute the Exchange Rates Pipeline using the following procedure:
a. 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.
b. 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.
c. The Exchange Rates Pipeline loads the Preparation Currency Exchange Rates Entity.
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:
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.
· If the Exchange Rates for a Period is present, then the Direct Rates are loaded for individual Rates for each Date.
· 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.
· Triangulation for the Rates is done only if any Date intersection is present.