Reporting currency ledgers are representations of a primary or secondary ledger in another currency for reporting purposes. Reporting currencies share the same chart of accounts, accounting calendar, and accounting method as their related ledger. You can use reporting currencies for online inquires, reporting, and consolidation.
Topic:
· Currency Translation Process
The Currency Translation process is performed in the PMF page.
To design and execute the Currency Translation process, follow these steps:
NOTE |
You must set the Reporting Currency in the Legal Entity Settings. |
1. From OFSAA Home, select Financial Services Balance Computation Engine, select Orchestration, and then select Process Modeller. The Process Modeler page is displayed.
Figure 31: Process Modeler page
2. In the Process Modeler
page, click
3. The Process Details page is displayed.
Figure 32: Process Details page for the Currency Translation process
Enter/Select the required values for each field.
Table 5: Process Details page field names and description
Field Name |
Description and instruction |
Process ID |
Enter a unique and easily recognizable value in the Process ID field. |
Process Name |
Enter a unique and easily recognizable value in the Process Name field. |
Process Description |
Enter a unique and easily recognizable value in the Process Description field. |
App Package ID |
Select the required application package in which the process must be created from the drop-down list. |
Type |
Select the required process type from the Type drop-down list. The options are as follows: · Business Process Pipeline · Run Pipeline · Stream Pipeline |
Registered Topics |
Note: This functionality is currently not applicable to OFSBCE. |
Spark DB |
Enable the Spark DB option if you are executing the Run for Hive metadata. |
Infodom |
Select the information domain from the Infodom drop-down list in which the Run Pipeline must be created. The list displays all the infodoms mapped to the applications configured in your OFSAA instance. |
Tag |
Enter the text that can be used as search keywords or helpful in defining a relationship between two or more Pipelines. |
Segment |
Select the application segment. The options are as follows: · BCESEG: OFSBCE segment · BFNDSEG: OFSDF segment |
4. To save the details and launch the Process Flow designing page, click Save And Launch.
5. In the Process Flow designing page, design a Currency Translation Process flow Run pipeline using the floating toolbar and a drawing canvas. Use the drawing canvas to design the process flow with the Tools, Activities, and OFSAA Widgets components available in the floating toolbar with Service Task as the base. In the illustration, the Service Task represents GL type for Management Period Balance Currency Conversion set in the Currency Conversion Settings section.
NOTE |
To create an Application Rule, see the Application Rules section, and to create a Data Field, see the Data Fields section in the Oracle Financial Services Analytical Applications Infrastructure Process Modelling Framework Orchestration Guide Release 8.1.0.0.0. |
Figure 33: Creation of Translate Management Ledger Period Balances process flow
For more information, see the Service Tasks section in the Oracle Financial Services Analytical Applications Infrastructure Process Modelling Framework Orchestration Guide Release 8.1.0.0.0.
6. Save the Currency Translation Process flow.
7. The Currency Translation Process is listed in the Process Modeler page. To select the Run parameters and execute the Run, follow these steps:
a. In the Process Modeler
page, click 
corresponding
to the Translation Process Run Pipeline that must be executed.
Figure 34: Translate Management Ledger Period Balances process - Select Execute Run
8. When you click Execute Run, the Select Run Params page is displayed.
Figure 35: Translate Management Ledger Period Balances process - Select Run Params page
Select the required values for each field as follows.
Table 6: Select Run Params page field names and descriptions
Field Name |
Description or Instruction |
Portfolio Identifier |
Select the reqiured Portfolio definition and the filter applies on the dataset with the members selected for this Portfolio. |
Run |
Select the defined Run. |
9. When you click OK, the Run execution begins. The Select Run Params page closes .
NOTE |
The execution of the Run Pipeline is triggered using the selected FIC MIS DATE. The Run SKey is generated and inserted into the “DIM_RUN” table. For the Run SKey generated, the corresponding user-selected Run parameters are inserted into the “RUN_EXE_PARAMETERS” table. |
NOTE |
See the chapter Executing Run through Process Modelling Framework in OFSDF in the Oracle Financial Services Data Foundation Application Pack User Guide Release 8.1.0.0.0, for information about the sections for information about the following sections: · Verifying the Run Execution · Aborting, Resuming, or Rerunning the Run Pipeline Process · Verifying the Execution Logs |
For detailed information about complete functioning of the PMF, see the Oracle Financial Services Analytical Applications Infrastructure Process Modelling Framework Orchestration Guide Release 8.1.0.0.0.
10. To open the Process Monitor
page, in the Process Modeler page, click the
icon
or select Process Flow Monitor from the 
.
11. The Process Monitor page opens displaying all the Run instances corresponding to the Translate Management Ledger Period Balances process. Or, in the Process Monitor page, search by Process ID, or by the Process Name Translate Management Ledger Period Balances, and select the process instance for the required Run pipeline (process) that was executed to verify the status and logs.
Figure 36: Translate Management Ledger Period Balances process - Process Monitor page - select Process ID
12. In the illustration, the Run pipeline is successfully executed. Therefore, the Currency Translation process is successfully complete and all the balances selected for the Translation are converted into the set Reporting Currency.
Figure 37: Translate Management Ledger Period Balances process - Run Execution status
For detailed information about the complete functioning of the PMF, see the Oracle Financial Services Analytical Applications Infrastructure Process Modelling Framework Orchestration Guide Release 8.1.0.0.0.
13. You can also check the details of execution status in the Execution Summary page.