18.8.1 Use and Execute Currency Exchange Rates Population Pipeline

The Currency Exchange Rates Population Pipeline enables Oracle Accounting Foundation Cloud Service (AFCS) to populate foreign exchange (FX) rates from a configured source into the AFCS exchange rate repository. The pipeline supports the direct integration with ERP GL. During processing, exchange rate records are extracted, validated, mapped to the AFCS currency data model, enriched with default or derived attributes where required, and loaded into the AFCS exchange rate staging area. After the data is successfully loaded, the exchange rates are published to the Exchange Rates table, making them available for downstream AFCS processes such as Netting, Revaluation, and other modules that require currency conversion. The pipeline also applies standard AFCS processing, including attribute enrichment and triangulation where applicable, ensuring that exchange rates are consistently managed and available for enterprise-wide financial processing.

Prerequisite

Before executing the 'Currency Exchange Rates Population' perform the following to ensure that the files are available on the ERP Financial Cloud Service:

Schedule the "GL_CURRENCY_EXCHG_RATES" Extract Job created in the BI Cloud Console while saving the AHCS Instance Details and ensure that the Job is completed.

To search and execute the Currency Exchange Rates Population process in the Process Orchestration, do the following:

1. To access the Currency Exchange Rates Population Pipeline, on the Home Page, select the Process Orchestration.
   The Process Modeller Page is displayed.
2. On the Process Modeller Page, search and select the Currency Exchange Rates Population Pipeline.
   The Process Flow Page is displayed.
3. To execute the Run, you can select the Run Parameter values using the Execution icon on the Process page or on the Process Modeller page.
4. Navigate to the Process Modeller page to execute the Run and Click Execution icon.
   The Execution Page is displayed.
5. On the Execution page, to execute the Run with parameters, select With Parameters in the Execution Type List. Select or enter the required values for each field as follows:

   Table 18-9 Currency Exchange Rates Population process - Execution page Field Names and Description

   Field Name	Description or Instruction
   As of Date	Use the Calendar button to select the As of Date for the pipeline.

6. To save the details and execute the Run, click Execute. The Run Execution begins.

   Note:

   The execution of the Run Pipeline is triggered using the selected As of Date.
7. To verify the Run Execution of the Currency Exchange Rates Population process, do the following:
   1. To open the Process Monitor Page, on the Process Modeller Page, click the Process Monitor Button or select Process Flow Monitor on the Process Menu on the Process Modeller Page.
   2. The Process Monitor Page is displayed listing all the Run Instances corresponding to the Currency Exchange Rates Population process. On the Process Monitor Page, search by the Process ID, or by the Process Name Currency Exchange Rates Population Pipeline, and select the Process Instance for the required Run Pipeline (Process) that was executed.
8. The Process Flow Page is displayed with the Run Execution Status on each Node of the Currency Exchange Rates Population process.
9. To verify the Run Execution Logs, do the following:
   1. On the Process Monitor Page, click the required Process Instance for which you need to verify the Execution Logs.
   2. To see the Execution Status details of a Node, double-click on that Node. The Execution Status details Page is displayed. Click Execution Logs.
   The Log Viewer Page is displayed, which lists all the Logs related to the Process Instance. To see an elaborated information of a log entry, click the Show More button. Click outside the Log Viewer page to close it.