15.10.1 Use and Execute Balance Computation Management Ledger Data Compaction Pipeline

The Balance Computation Management Ledger Data Compaction Pipeline streamlines balance computations and enhances the system performance within the AFCS. By removing the outdated and redundant records from processing entities, it reduces data volume and accelerates execution times for processing runs and result area jobs. This leads to faster financial reporting, improved scalability for high-volume environments.
To create and execute the Balance Computation Management Ledger Data Compaction process in the Process Orchestration, do the following:
  1. To access the Balance Computation Management Ledger Data Compaction 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 Data Compaction 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 15-14 Balance Computation Management Ledger Data Compaction Pipeline - Execution page Field Names and Description

    Field Name Description or Instruction
    Extraction Date Use the Calendar button to select the Extraction Date for the pipeline.
    Run Purpose Select the run purpose details from the drop down.
  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 Extraction Date.
  7. To verify the Run Execution of the Balance Computation Management Ledger Data Compaction Pipeline, do the following:
    1. To open the Process Monitor Page, on the Process Modeller Summary Page, select Process Monitor from the drop down menu.
    2. The Process Monitor Page is displayed listing all the Run Instances corresponding to the Balance Computation Management Ledger Data Compaction Pipeline. On the Process Monitor Page, search by the Object ID, or by the Process Name Balance Computation Management Ledger Data Compaction Pipeline, and select the Object ID 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 Balance Computation Management Ledger Data Compaction Pipeline.
  9. To verify the Run Execution Logs, do the following:
    1. On the Process Monitor Page, click the required Object ID 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 Activity Execution Details Page is displayed. Click Execution Logs.
    The Log Viewer Service Page is displayed, which lists all the Logs related to the Object ID. To download the execution log, click the Download button to download the file as a PDF or as an Excel sheet. Click Close to close the Log Viewer Service page.