:
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:
· Currently, GL to PP reconciliation is supported, Source GL is mapped to target PP tables. Mandatory Dimension are preselected and you can define additional dimensions.
· The mandatory dimensions, optional dimensions, and MEMBRES 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 GAAP Code for the selected dimension. The dimensions Legal Entity, Currency, and GAAP Code 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 GAAP Code 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.