9.4.3.2 Balance Revaluation Management Ledger Process

This is the Run pipeline (process) to compute the revaluation amounts based on the currency exchange rates and generate offsets for the period balances based on user-configured settings in OFSBCE.

To compute the revaluation amount using the Balance Revaluation Management Ledger process, follow these steps

1. From OFSAA Home, select the Financial Services Balance Computation Engine, select the Administration. In the Information Domain list, select the information domain required for OFSBCE. Then click the Process Modelling Framework tile. A submenu is displayed. To access the Process Modeller, click Process Modeller. The Process Modeller page opens. In the following illustration, the out of the box Balance Revaluation Management Ledger Process is shown.

   Figure 9-19 Process Modeller page with Balance Revaluation Management Ledger Process

   
   

   

   
   
2. The corresponding process flow is displayed. This process flow is designed using the drawing canvas with the Transition, Activity, and Widgets components available in the floating toolbar and with Service Task as the base. Each Service Task represents GL type for Assets, Liabilities, Expenses, Revenue, Gains, Losses, Contra Asset, Contra Liability, and Owner’s Equity. The tasks are repeated in the Run for each General Ledger Type and are executed in parallel. You can set up which of these tasks must be executed in the Revaluation Settings section.

   Figure 9-20 Balance Revaluation Management Ledger process flow

   
   

   

   
   
3. Double-click a Service task to see the details related to its Activity, Implementation, Transitions, Actions, and Notifications. To save the details, click Save icon.

   Figure 9-21 Balance Revaluation Management Ledger process with Service Task details

   
   

   

   
   
4. On the drawing canvas, select the Definition, Application Rule, and Data Fields icons to see the respective details.
   1. Click Edit icon to open the Definition details. To save the details, click.

      Figure 9-22 Balance Revaluation Management Ledger process with Definition details

      
      

      

      
      
   2. Click the Appilcation Rule icon to open the Application Rule details. You can add or modify or delete the Rule details.

      Figure 9-23 Balance Revaluation Management Ledger process with Application Rule tab details

      
      

      

      
      
   3. Click the Data Fields icon to open the Data Fields details. Add, modify, delete, or view the Data Fields details.

      Figure 9-24 Balance Revaluation Management Ledger process with Data Fields details

      
      

      

      
      
   4. Click Save icon to save the Revaluation Process Flow. Continue with the next steps or execute the Run on the Process Modeller page.
   5. Click the Execution icon to open the Execution details. To save the details, click the Save icon.

      Figure 9-25 Balance Revaluation Management Ledger process without Execution Parameters

      
      

      

      
      
   6. Enter and select the required details to execute the Run without parameters. To execute with parameters, select With Parameters in the Execution Type list. To save the details, click Save icon.

      Figure 9-26 Balance Revaluation Management Ledger Process with Execution Parameters

      
      

      

      
      

      Note:

      The values are fetched from the FSI_EXCG_RATES and SETUP_MASTER tables.
   7. Select or enter the required values for each field as follows.

      Table 9-3 Balance Revaluation Management Ledger Process - Execution Page With Parameters and description

      Field Name	Description or Instruction
      FIC MIS Date	Use the calendar icon to select the extraction date.
      Currency	Use the Selection icon to select the Currency Code used to calculate the amount during the data population in the target table.
      Data Origin	Use the Selection icon to select the required Data Origin from the Available Values list and click OK.
      Rate Type	Select the Rate Type from the drop-down list. The options are as follows: Average Daily End of Period

      To save the details and execute the run, click Save icon.
5. In the Process Modeller page, click corresponding to the Balance Revaluation Management Ledger Run process that must be executed. Click Execute Run.

   Figure 9-27 Balance Revaluation Management Ledger process - Select Execute Run

   
   

   

   
   
6. 6. When you click Execute Run, the Execution page is displayed

   Figure 9-28 Balance Revaluation Management Ledger process without Execution Parameters

   
   

   

   
   
   1. Enter and select the required details to execute the Run without parameters. To execute with parameters, select With Parameters in the Execution Type list. To save the details, click Save icon.

      Figure 9-29 Balance Revaluation Management Ledger Process with Execution Parameters

      
      

      

      
      

      Note:

      The values are fetched from the FSI_EXCG_RATES and SETUP_MASTER tables.

      Select or enter the required values for each field as follows.

      Table 9-4 Balance Revaluation Management Ledger Process - Execution Page With Parameters and description

      Field Name	Description or Instruction
      FIC MIS Date	Use the calendar icon to select the extraction date.
      Currency	Use the Selection icon to select the Currency Code used to calculate the amount during the data population in the target table.
      Data Origin	Use the Selection icon to select the required Data Origin from the Available Values list and click OK.
      Rate Type	Select the Rate Type from the drop-down list. The options are as follows: Average Daily End of Period

7. To save the details and execute the Run, click Save. The Run execution begins.

   Note:

   The execution of the Balance Revaluation Management Ledger Run process 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 the Oracle Financial Services Analytical Applications Infrastructure Process Modelling Framework Orchestration Guide Release 8.1.1.0.0 for information about the following topics:

   • To abort, resume, or rerun the Run Pipeline Process, see the Abort Run Pipeline, Resume Run Pipeline, and Re-run Run Pipeline sections respectively.
   • To verify the execution logs, see the Viewing Activity Execution Logs and Viewing Execution Log for Widgets sections.
8. To verify the Run execution status of the Balance Revaluation Management Ledger process, follow these steps:
   1. To open the Process Monitor page, in the Process Modeller page, click Process Flow Monitor icon or select Process Flow Monitor from the Process Modeller menu.
   2. The Process Monitor page opens displaying all the Run instances corresponding to the Balance Revaluation Management Ledger process. In the Process Monitor page, for the required Run pipeline (process) that was executed, search the Run instance 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 9-30 Balance Revaluation Management Ledger Process – Process Monitor Page – Select Job ID

      
      

      

      
      
9. A status page opens, which displays the execution status of the executed Run instance for the Balance Revaluation Management Ledger process. In this illustration, the Run for Revaluation is successfully executed.

   Figure 9-31 Balance Revaluation Management Ledger process – Run Execution status

   
   

   

   
   
   For information about the complete functioning of the PMF, see the the Oracle Financial Services Analytical Applications Infrastructure Process Modelling Framework Orchestration Guide Release 8.1.1.0.0.

   You can also check the execution status details in the Execution Summary page.

   To design and execute a custom Balance Revaluation Management Ledger process, see the Create and Execute a Custom Run Pipeline for Balance Revaluation Management Ledger Process section.