5.9 Hierarchy Configuration for Reconciliation

Hierarchies are used in the Reconciliation User Interface to allow users to select one or more nodes (parent or leaf) within a dimension. The Hierarchy Browser is a widget that displays these hierarchies, relying on cached data maintained internally by the system. Since dimension data can change over time, this cache must be refreshed regularly to ensure it reflects the most up-to-date hierarchy information.

To refresh this data, DFCS provides a Processing Modelling Framework (PMF) process called ‘Hierarchy Resave’. Running this process updates the internal cache with the latest dimension data, ensuring the Hierarchy Browser widget displays the current dimension members. The successful execution of this process confirms that the hierarchy cache has been refreshed.

Key points about the Hierarchy Resave process:

  • It can be executed multiple times for a given date.
  • Multiple dimension hierarchies can be selected and refreshed simultaneously.
  • After resaving hierarchies, proceed with the Run Pipeline execution.

Usage in Reconciliation

In the Reconciliation configuration interface, hierarchies are used to render parent-child structures—for example, Legal Entity and General Ledger hierarchies. These hierarchies are either:

  • Out-of-the-box: Predefined by the system.
  • Custom: User-defined for specific reconciliation needs.
  • Legal Entity and General Ledger hierarchies are parent-child structures and must be loaded into their corresponding hierarchy tables.
  • Other hierarchies used in reconciliation rule filters are typically single-level.

Always ensure hierarchy data is loaded and the Hierarchy Resave process is run before executing reconciliation runs to ensure data accuracy.

Following are the seeded hierarchies and its corresponding mapping tables:

Table 5-8 Following are the seeded hierarchies and its corresponding mapping tables

Seeded Hierarchy Mapping Tables
HGL001 Product Dimension
HGL002 Business Unit Dimension
HGL003 Branch Dimension
HGL004 Counterparty Dimension
HGL005 Currency Dimension
HGL006 Organization Unit Dimension
HGL008 Legal Entity Hierarchy Dimension
HGL009 General Ledger Hierarchy Dimension
HGL012 Accounting Standard Dimension
HGL014 Ledger Dimension
HGL015 Project Dimension
Re-save the following Hierarchies and then proceed with the Run Pipeline execution:

Table 5-9 Re-save the following Hierarchies and then proceed with the Run Pipeline execution

Hierarchy Run Pipeline
Branch Dimension Branch for Reconciliation
Business Unit Dimension Business Unit for Reconciliation
Legal Entity Hierarchy Dimension Legal Entity for Reconciliation
Organization Unit Dimension Organization Unit for Reconciliation
Product Dimension Product for Reconciliation
Project Dimension Project for Reconciliation
General Ledger Hierarchy Dimension GL Code for Reconciliation
Ledger Dimension Ledger for Reconciliation
Currency Dimension Currency for Reconciliation
Accounting Standard Dimension Accounting Standard for Reconciliation
Legal Entity Dimension Intercompany for Reconciliation
Counterparty Dimension Counterparty for Reconciliation
Account Dimension Account for Reconciliation
To re-save the GL Hierarchies in Process Orchestration, follow these steps:
  1. On the home page, select Process Orchestration from the LHS menu. The Process Modeller page is displayed.
  2. Create a pipeline GL Hierarchy Resave and select one or multiple of the above listed Hierarchy names in the Process Orchestration before re-saving them. To create a pipeline, follow these steps:
    1. 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.
    2. After 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. Under Dynamic Parameters for HIERARCHYRESAVE fields, select the Entities, and then the corresponding Hierarchy names, and select Load Type as Resave. Click Tick mark icon to save the details.
    3. 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.
    4. Go to the Process Modeller Page to execute the Run. Click the Menu Button corresponding to the pipeline that needs to be executed. Click Execute Run. The Execution Page is displayed.
    5. On the Execution Page, select the Execution Type as Without Parameters. Enter a unique value for the Object ID.
    6. To save the details and execute the Run, click the Apply Button. The resaving process begins.

      Note:

      See the Process Orchestration Section for more details about the Processes.
  3. To verify the Run Execution (GL Hierarchy Resave), do the following:
    1. 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.
    2. The Process Monitor Page is displayed listing all the Run Instances corresponding to the GL Hierarchy Resave Processes. On the Process Monitor Page, search by the Process ID, or by the Process Name GL Hierarchy Resave, and select the Process Instance for the required Run Pipeline (GL Hierarchy Resave) that was executed. The Process Flow Page is displayed with the Run Execution Status on each Node of the GL Hierarchy Resave Process.
  4. To verify the Run Execution Logs, do the following:
    1. 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.
    2. 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.