:
Click the View icon, to view
the Settings and Dimensions
of the reconciliation type on a read-only basis.The Type Configuration allows you to perform the functions:
· The GL to PP and GL to ML reconciliation are supported. For GL to PP reconciliation, Source GL is mapped to target PP tables and in case of GL to ML reconciliation, Source GL is mapped to target ML table. Mandatory Dimensions are preselected, and you can define additional dimensions.
· The mandatory dimensions, optional dimensions, and MEMBERS OF THE DIMENSION participating in the GL Reconciliation Process.
The Type Configuration page lists the predefined Reconciliation Definition types that can be used during a Reconciliation Definition. These configurations are:
· General Ledger to Product Processor
The Type Configuration UI allows you to define the type of reconciliation. You can perform various activities on the selected Type in the Type Configuration Window.
· View :
Click the View icon, to view
the Settings and Dimensions
of the reconciliation type on a read-only basis.
The view displays two panes:
§ Settings
§ Dimensions
· Edit 
:
Click the Edit icon, to modify
the Settings and Dimensions
of the reconciliation type. It allows you to modify an existing reconciliation
definition except for the Name.
Edit displays two panes:
§ Settings
§ Dimensions
· Delete 
:
Click the Delete icon, to
delete the Settings and Dimensions of the reconciliation
type that you wish to delete. A dialog box is displayed if the selected
Reconciliation type is used in any rule, with the following message “This Recon Type is used by some
Rules, unable to delete the Recon Type”.
NOTE:
You should NOT delete the seeded Reconciliation Type (General Ledger to Product Processor).
Topics:
· General Ledger to Product Processor
General Ledger to Product Processor Reconciliation is to identify the difference between the GL system and the Product Processor data. It nullifies the difference by posting the adjustment entries up to the amount of difference.
· If the reconciliation difference is greater than the threshold value, then the difference is reported.
· A threshold is a specified Product Processor level and these values are specified in the terms of percentage or an absolute amount. The Percentage value represents the difference in percent to the General Ledger side amount.
· If the threshold is specified in the terms of the amount, then it must be read in connection with a currency of the threshold amount. The reconciliation difference is reported in the base currency. If the currency specified here is different than that of the reconciliation dimension, then the difference amount must be converted in the threshold currency using the exchange rate of execution date or the latest available rate of the five preceding days.
· While reconciling General Ledger and Product Processor, differences can arise in two ways:
either when the General Ledger Amount is greater than the Product Processor Amount
or
when the General Ledger amount is less than the Product Processor amount.
· Hence, there are two threshold values to address differences arising out of this condition.
For more information, see Target Parameters.
Topics:
· Settings
It consists of two tabs:
· Settings
· Dimensions
The Settings tab displays the name and the description of the reconciliation type that you want to view (General Ledger to Product Processor Configuration for this section).
It is further divided into two panes:
· Source: This pane displays the Source Grain and the Source Entity for General Ledger to Product Processor type. The Stage General Ledger data is the default source entity used for reconciliation definition.
· Target: This pane displays the Target Grain and Target Entity for General Ledger to Product Processor type. The Target entities refer to the Stage instrument tables (Product Processors) of the Oracle Financial Services Data Foundation.
When you click the View icon from main page, you can only view the selected reconciliation type, on the Settings page. All the panes in the Settings page are disabled for modifying the Reconciliation type in the Read-only mode.
Click the Edit icon to edit the selected reconciliation type. All the panes in the Settings Tab are enabled for editing except the Name.
The Dimensions tab consists of two panes as Dimension Mapping, and Dimension Attribute Selection. The dimensions such as Legal Entity, Currency, and GAAP Code are mandatory dimensions and must be selected to proceed with GL Reconciliation executions.
NOTE:
It is assumed that mandatory reconciliation dimensions are present in all the bank’s GL Source Systems.
· Dimension Mapping: This pane displays the Legal Entity, Currency, and Accounting Standard for the selected dimension. The dimensions Legal Entity, Currency, and Accounting Standard must be selected to proceed with the GL Reconciliation executions. You can configure additional optional dimensions based on the requirement.
· Dimension Attribute Selection: This pane allows you to map the respective dimension attribute to each of the entities selected in the Settings view. As an example, the Stage Cards, Stage General Ledger Data, and Stage Loan Contracts have been configured for dimensions.
When you click the View icon in main page, the corresponding mappings of the entities present in the Dimension mapping pane are displayed with the selected dimension attributes in a Read-Only mode.
NOTE:
The Dimensions tab functionalities remain the same for all three types of configurations.
Topics:
When you select the Dimension from the drop-down list in this pane, the mapping of the respective dimension is done for all the entities defined in the Settings Tab.
By default, these mandatory dimensions Legal Entity, Currency, and Accounting Standard are available in the reconciliation type.
For example, only a Legal Entity dimension must be selected against the Legal Entity and any other dimension cannot be selected. You are expected to select a valid Legal Entity, GAAP, and Currency hierarchy while configuring the mandatory dimensions.
You
can select the optional dimensions such as Product,
Organization Unit, and so on and map these dimensions
to the Reconciliation type, so for each dimension respective attributes
of the entities must be selected.
You can select one or more entities to map the attributes for the respective
dimension.
1. Select any of the entities within the Dimension Attributes Selection Pane to enable the Attribute icon. Click Attributes to add optional Dimension Attributes.
The Attributes list displays the list of the attributes that can be associated with the selected Dimension Attributes. The attribute list shows the combined attributes for all the Stage Tables selected.
2. Select the attributes and click the OK button.
Management Ledger refers to an entity with detailed GL balances based on number of COA segment chosen, often referred to as thick GL. In this setting the Balance Computation engine output data is tagged as Management Ledger data.
In AFCS, the Management Ledger Reconciliation compares Source GL Data with Target revalued balance of Balance Computation engine. While the source GL data is ingested from Accounting Hub Cloud Services (AHCS), target data is output for Balance computation engine. GL Level Definition is only enabled during management ledger reconciliation.
Reconciliation Type ‘Ledger to Management Ledger’ helps to reconcile such balances. Navigate to Reconciliation Type to see the out of the box configuration of this type of reconciliation.
In the Ledger to Management Ledger (GL to ML) reconciliation, the difference between two sources of the Ledger for the same Legal Entity and the Consolidation Type is identified. This difference is identified at the granularity of the GL code for the selected hierarchy, the mandatory dimensions, and the selected optional dimensions. Adjustments are not passed in the Ledger to Management Ledger reconciliation. Also, the difference is identified by comparing the Source Ledger with the Target Ledger, to ensure that all the GL codes’ amount is covered to calculate the difference.
A Legal Entity in the bank can maintain the same GL data (either solo or consolidated) in one or more source systems. If GL data is maintained in the multiple source systems, then it is essential to compare the GL balances among such GL sources to ensure that all GL sources reflect the accurate and uniform balance. Any difference, between two GL source systems, is expected to be rectified outside the framework. Reconciliation definition is applied at Legal Entity Level - either Solo or Consolidated.
NOTE:
The Adjustment Entry is not passed in the GL to ML reconciliation.
NOTE:
The Management Ledger Period Balance is included in the data model of the AFCS Reconciliation Framework. This table is used as a Target Ledger table. The Preparation Management Ledger Period Balance is a single table to store the thick ledger of the bank and it is already configured.
Topics:
· Settings
It consists of two tabs:
· Settings
· Dimensions
The Settings tab displays the name and the description of the reconciliation type that you want to view (Ledger to Management Ledger Configuration for this section).
It is further divided into two panes:
· Source: This pane displays the Source Grain (Ledger) and the Source Entity for Ledger to Management Ledger. The Stage General Ledger data is the default source entity used for reconciliation definition.
· Target: This pane displays the Target Grain (Management Ledger) and Target Entity for Ledger to Management Ledger. The Target entities refer to the Preparation Management Ledger Period Balance table (Management Ledger) of the Oracle Financial Services Data Foundation.
When you click the View icon from main page, you can only view the selected reconciliation type, on the Settings page. All the panes in the Settings page are disabled for modifying the Reconciliation type in the Read-only mode.
Click the Edit icon to edit the selected reconciliation type. All the panes in the Settings Tab are enabled for editing except the Name.
The Dimensions tab consists of two panes as Dimension Mapping, and Dimension Attribute Selection. The dimensions such as Legal Entity, Currency, and Accounting Standard are mandatory dimensions and must be selected to proceed with GL Reconciliation executions.
NOTE:
It is assumed that mandatory reconciliation dimensions are present in all the bank’s GL Source Systems.
· Dimension Mapping: This pane displays the Legal Entity, Currency, and Accounting Standard for the selected dimension. The dimensions Legal Entity, Currency, and Accounting Standard must be selected to proceed with the GL Reconciliation executions. You can configure additional optional dimensions based on the requirement.
· Dimension Attribute Selection: This pane allows you to map the respective dimension attribute to each of the entities selected in the Settings view. The Stage General Ledger Data, and Preparation Management Ledger Period Balance have been configured for dimensions.
NOTE:
Reconciliation Framework follows attribute consistency. It is expected that the same attribute is used for a particular dimension across all the Stage entities. For example, If ‘Product Code’ is used for product dimension, then system will always look for ‘Product Code’ in all the stage side entities (Ledger and Management Ledger).
When you click the View icon in main page, the corresponding mappings of the entities present in the Dimension mapping pane are displayed with the selected dimension attributes in a Read-Only mode.
NOTE:
The Dimensions tab functionalities remain the same for all three types of configurations.
Topics:
When you select the Dimension from the drop-down list in this pane, the mapping of the respective dimension is done for all the entities defined in the Settings Tab.
By default, these mandatory dimensions Legal Entity, Currency, and Accounting Standard are available in the reconciliation type.
For example, only a Legal Entity dimension must be selected against the Legal Entity and any other dimension cannot be selected. You are expected to select a valid Legal Entity, and Currency hierarchy while configuring the mandatory dimensions.
You
can select the optional dimensions such as Product,
Organization Unit, and so on and map these dimensions
to the Reconciliation type, so for each dimension respective attributes
of the entities must be selected.
You can select one or more entities to map the attributes for the respective
dimension.
1. Select any of the entities within the Dimension Attributes Selection Pane to enable the Attribute icon. Click Attributes to add optional Dimension Attributes.
The Attributes list displays the list of the attributes that can be associated with the selected Dimension Attributes. The attribute list shows the combined attributes for all the Stage Tables selected.
2. Select the attributes and click the OK button.