The revaluation process is used to adjust account balance figures of denominated currencies other than accounting currency. Revaluation adjustments represent the difference in the value of the balance due to changes in conversion rates between the date of the original journal entry and the revaluation date.
Topic:
This section provides information about the Revaluation Process in OFSBCE.
Topics:
· Create and Execute Revaluation Process
Figure 23: Revaluation Process Flow in OFSBCE
The main phases in the Revaluation process are depicted in the preceding illustration.
The Revaluation Process begins with the data present in the Management Ledger Period Balances. In the Revaluation Adjustments stage, the revaluation adjustments are performed against each period balance amount to calculate the adjustment amount. As a result, during the Revalued Management Ledger Period Balances stage, in the Period Balance table, the adjusted balances are recomputed and inserted in a new row with an incremented version.
Ensure you have completed the Revaluation admin settings. See the Revaluation Settings section for more information.
In the Revaluation Adjustments stage, to arrive at the revalued amount (N_REVALUED_AMOUNT values in the FSI_MGMT_LGR_REVAL_BALANCES table) before initiating the Revaluation execution process, complete the following tasks:
1. Load the FSI_EXCG_RATES table using the insert scripts.
2. For any balance you arrive at from the Period balance perspective, compare the current exchange rate (N_EXCHANGE_RATE) value in the FSI_EXCG_RATES table against the Period balance present corresponding to the exchange rate in the FSI_MGMT_LGR_REVAL_BALANCES table.
3. Apply the following formula:
§ For AST/LIAB (Assets or Liabilities) type, calculate the adjustment amount using the following formula:
Current Period YTD Balance x Revaluation Rate – Currency Period YTD Balance LCY
§ For REV/EXP (Revenue or Expenses) type, calculate the adjustment amount using the following formula:
(Current Period YTD Balance – Prior Period YTD Balance) x Revaluation Rate –
(Currency Period YTD Balance LCY – Prior Period YTD Balance LCY)
NOTE |
Revaluation is processed only for the Open fiscal periods. |
In the Revaluation Adjustments stage, Offset GL Account is generated from the SETUP_MASTER table based on whether the entry corresponds to a Gain or Loss account. Then in the Revaluation process execution stage, for each account in the management ledger period balances, the offset balance is generated.
To create and execute the Revaluation process, follow these steps:
1. From OFSAA Home, select the Financial Services Balance Computation Engine, then select Orchestration, select Process Modeler. The Process Modeler page is displayed.
Figure 24: Navigate to the Process Modeler page
2. In the Process Modeler page, click
.
3. The Process Details page is displayed.
Figure 25: Process Details page for the Revaluation process
Enter or Select the required values for each field.
Table 3: 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 Revaluation 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, each Service Task represents GL type for Assets, Liabilities, Expenses, Revenue, Gains, Losses, Contra Asset, Contra Liability, and Owner’s Equity set in the Revaluation Settings section.
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.
Figure 26: Creation of Balance Revaluation Management Ledger process flow
6. Save the Revaluation Process Flow.
7. The Revaluation 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 Revaluation Process Run Pipeline that must be executed.
Figure 27: Balance Revaluation Management Ledger process - Select Execute Run
8. When you click Execute Run, the Select Run Params page is displayed.
Figure 28: Balance Revaluation Management Ledger process - Select Run Params page
Select the required values for each field as follows.
NOTE |
The values are fetched from the FSI_EXCG_RATES and SETUP_MASTER tables. |
Table 4: Balance Revaluation Management Ledger process - Select Run Params page field names and description
Field Name |
Description/Instruction |
FIC MIS Date |
Use the |
Data Origin |
Use the |
Currency |
Use the |
Rate Type |
Select the Rate Type from the drop-down list. The options are as follows: · Average · Daily · End of Period |
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 Executing Run through Process Modelling Framework in OFSDF chapter in the Oracle Financial Services Data Foundation Application Pack User Guide Release 8.1.0.0.0, 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 verify the Run execution of the Balance Revaluation Management Ledger process, follow these steps:
a. To open the
Process Monitor page, in the Process
Modeler page, click the 
icon
or select Process Flow Monitor from the 
.
b. The Process Monitor page is displayed listing all the Run instances corresponding to the Balance Revaluation Management Ledger process. In the Process Monitor page, search by Process ID, or by the Process Name Balance Revaluation Management Ledger, and select the process instance for the required Run pipeline (process) that was executed.
Figure 29: Balance Revaluation Management Ledger process – Process Monitor page – select Process ID
11. A status is displayed, which shows the execution status of the executed Run for the Balance Revaluation Management Ledger process. In this illustration, the Run for the Revaluation is successfully executed.
Figure 30: Balance Revaluation Management Ledger process – Run Execution status
For 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.
You can also check the details of execution status in the Execution Summary page.
to
select the extraction date.
icon to select the required Data Origin from the Available Values
list and click