Statistical Amounts (Average, Month-to-Date, Quarter-to-Date, and Year-to-Date) are derived off of the Instrument Level Accounting Balance information. Balance Computation uses Instrument Accounting Balance figures across multiple MIS Dates, Calendar Information, and Fiscal or Accounting Period Definition to assess the Average Accounting Balance, Month-to-Date Accounting Balance, and Year-to-Date Accounting Balance as the Statistical Management Ledger Amounts.
NOTE:
For the Backdated Journal Processing, ensure that the Period to which you are posting the Journals to is an Open Period as set in the Legal Entity Settings Section.
Additionally, when the Backdated Journals are processed, the System recomputes the Daily Movements, Period-to-Date, and Period-to-Date Average Balances for the Range between the Journal Posting Date and the As of Date. Based on the preceding method, the larger the Range between the two Dates, the greater is the duration for Execution.
Topic:
· Use and Execute the Balance Computation Management Ledger Process
Re-save the following Hierarchies and then proceed with the Run Pipeline execution.
· BCE001 (DIM_CURRENCY)
· BCE002 (DIM_DATA_SOURCE)
· BCE003 (DIM_LEGAL_ENTITY)
To re-save the BCE Hierarchies in the Process Orchestration, do the following:
1. To access the BCE001, BCE002, and BCE003 related Pipelines, on the Home Page, select the Process Orchestration. The Process Modeller Page is displayed.
2. Create a pipeline BCE Hierarchy Resave and enter information in the Process Details window such as Process Name, Process Description, App Package ID as Balance Computation Engine, Type as Run Pipeline, Spark DB as No and the Service ID Workspace as Oracle Financial Services Data Service for Analytics WS001 and click the OK Button to save the details in the Process Orchestration page before re-saving them.
3. On the Process Modeller Page, search for the created pipeline. The Process Flow Page is displayed. This Process Flow is designed on the Drawing Canvas using the Transition, Activity, and Widgets Components available in the floating toolbar. A HIERARCHYRESAVE Widget is added to the START for the purpose of resaving the Hierarchy.
4. Once the HIERARCHYRESAVE Widget is added in the Drawing Canvas, double-click the HIERACHYRESAVE Node, the HIERARCHYRESAVE window is displayed. Enter information in the Activity Desc field and select No as the option for the Exclude Task field. Under Dynamic Parameters for HIERARCHYRESAVE fields, enter the Hierarchy Codes as BCE001, BCE002 or BCE003 and enter the Load Type as Resave and click the OK Button to save the details.
5. To execute the Run, you can select the Run Parameter Values using the Execution Button on the Process Flow Page or on the Process Modeller Page.
6. Go to the Process Modeller Page to execute the Run. Click the Menu Button corresponding to the pipeline. Click Execute Run. The Execution Page is displayed.
7. On the Execution Page, select the Execution Type as Without Parameters. Enter a unique value for the Object ID.
8. To save the details and execute the Run, click the Apply Button. The resaving process begins.
NOTE:
See the Managing Processes Section for more details about the Processes.
9. To verify the Run Execution (BCE Hierarchy Resave), do the following:
a. To open the Process Monitor Page, on the Process Modeller Page, click the Process Monitor Button or select Process Flow Monitor on the Process Modeller Menu.
b. The Process Monitor Page is displayed listing all the Run Instances corresponding to the BCE Hierarchy Resave Processes. On the Process Monitor Page, search by the Process ID, or by the Process Name BCE Hierarchy Resave, and select the Process Instance for the required Run Pipeline (BCE Hierarchy Resave) that was executed.
The Process Flow Page is displayed with the Run Execution Status on each Node of the BCE Hierarchy Resave Process.
10. To verify the Run Execution Logs, do the following:
a. On the Process Monitor Page, click the required Process Instance for which you need to verify the Execution Logs. The Process Flow Page is displayed with the Run Execution Status on each Node.
b. 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 the details of a log entry, click the Show More Button. Click outside the Log Viewer Page to close it.
Use this Run Pipeline (Process) to compute the daily movements, Period-to-Date, backdated, and Translation Process Execution of average balances in Balance Computation.
Ensure that you complete the following procedures and then proceed with the use and execution of the Balance Computation Management Ledger Process:
To use and execute the Balance Computation Management Ledger Process in the Process Orchestration, do the following:
1. To access the Balance Computation Management Ledger Process 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 Balance Computation Management Ledger Process. The Process Flow Page is displayed. This Process Flow is designed on the Drawing Canvas using the Transition, Activity, and Widgets Components available in the floating toolbar. A Data Service Widget is added at the beginning meant for sourcing the Data for Accounting Entries. Then the BalanceComputation Widget is used for each GL Type Activity such as Assets, Liabilities, Expenses, Revenue, Gains, Losses, Contra Asset, Contra Liability, and Owner’s Equity. The Activities are sequenced in the order of the Backdated Process, Daily Balances Process, and Average Balances Process. The Activities are repeated in the Run for each General Ledger Type and are executed in parallel. The Balance Translation Node is added in the end.
3. To view the details of any Activity, double-click on the Activity and the details related to its Activity, Transition, and Notification are displayed. On the drawing canvas, you can select and see the Definition, Data Fields, and Application Rule details.
4. To execute the Run, you can select the Run Parameter Values using the Execution Button on the Process Flow Page or on the Process Modeller Page.
5. Go to the Process Modeller Page to execute the Run. Click the Menu Button corresponding to the Balance Computation Management Ledger Run Process that needs to be executed. Click Execute Run. The Execution Page is displayed.
6. 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.
Field Name |
Description or Instruction |
|---|---|
Extraction Date |
Use the Calendar Button to select the Extraction Date or Run Date for the Pipeline. |
Data Source |
Use the Link Button to select the required data source from the Available Values List, move it to the Selected Values List, and click OK. |
Legal Entity |
Use the Link Button to select the required Legal Entity from the Available Values List, move it to the Selected Values List, and click OK. |
Run Execution Description |
Enter a description for the Run Pipeline. |
7. To save the details and execute the Run, click the Apply Button. The Run Execution begins.
NOTE:
The execution of the Run Pipeline is triggered using the selected Extraction Date.
See the Managing Processes Section for more details about the Processes.
8. To verify the Run Execution of the Balance Computation Management Ledger Process, do the following:
a. To open the Process Monitor Page, on the Process Modeller Page, click the Process Monitor Button or select Process Flow Monitor on the Process Modeller Menu.
b. The Process Monitor Page is displayed listing all the Run Instances corresponding to the Balance Computation Management Ledger Process. On the Process Monitor Page, search by the Process ID, or by the Process Name Balance Computation Management Ledger, and select the Process Instance for the required Run Pipeline (Process) that was executed.
The Process Flow Page is displayed with the Run Execution Status on each Node of the Balance Computation Management Ledger Process.
9. To verify the Run Execution Logs, do the following:
a. On the Process Monitor Page, click the required Process Instance for which you need to verify the Execution Logs. The Process Flow Page is displayed with the Run Execution Status on each Node.
b. 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 the details of a log entry, click the Show More Button. Click outside the Log Viewer Page to close it.