The Data Adjustment Module provides capabilities to define templates that can be used for various types of Adjustments. The entities on templates that can be defined refer to the Stage instrument tables of OFS Data foundation Applications. The templates are used by a reconciliation framework to define default values for various attributes for the instrument tables. While posting adjustments, Data Adjustment Modules apply the defaults for the adjustments created by the reconciliation framework.
Figure 61: Data Adjustment Summary Page
Topic:
· Navigation within the Data Adjustments Summary Page
You can navigate to Data Adjustment, and select Adjustment Rules. The Data Adjustments Summary window displays all the Adjustment templates defined for various entities. You can use search criteria to search for an Adjustment Entry. The highlighted icon is used for the set of adjustment entries that are displayed. When you click the Add, View, or Copy icon, the details page is displayed.
Figure 62: Data Adjustment Summary Page Features
Topics:
· Navigation within the Adjustment Entry Page
· Copy and Edit Data the Adjustments Summary Page
· Navigation within the Adjustment Run Details Page
When you first navigate to the Adjustment Entry page, the Adjustment entries associated with the first dimension are presented in a summary list. The Adjustment Entry Page has the following sections:
· Adjustment Entry Status Pane
Among other properties, each Adjustment Entry consists of a Run Execution ID, a GL Date, and a Definition. You may search on any of these properties in the Search pane.
Figure 63: Search Adjustment Pane
The Adjustment Entry Status pane presents a list containing all of the Adjustment Entries that meet your search criteria. This list also offers several icons that allow you to perform different functions when an Adjustment Entry is selected. The following icons are:
· Add
:
Click the Add icon, to add the Adjustment
Entry and its parameters that are further displayed on the Adjustment
Entry Summary window.
· View
:
Click the View icon, to view the detailed
parameters of an Adjustment Entry on a read-only mode.
· Copy
:
Click the Copy icon, to copy the feature
on the Data Adjustments Summary page.
· Delete
:
Click the Delete icon, to delete the
Adjustment Entry from the list.
The following are the steps to copy and edit data adjustments on the Data Adjustments Summary page:
1. In the Data Adjustments Summary page, click the Copy icon.
The Adjustment Copy dialog box appears to copy the adjustment definition.
Figure 64: Copy Icon in Data Adjustments Summary Page
NOTE:
If the user clicks the Copy icon, a new adjustment template is created in the Draft mode.
2. Enter the Name and the Description in the Adjustment Copy tab and click the Save button.
Figure 65: Adjustments Copy tab
This creates a new adjustment template in the draft mode.
3. After the adjustment template is in the draft mode, the Edit option is enabled on the Data Adjustments Summary page.
Figure 66: Edit Icon in Data Adjustments Summary Page
NOTE:
If the user clicks on cancel without submitting the template, it appears in Draft mode and later can be edited. After submission, the template is in an Approved state and cannot be edited.
4. Click the Edit button.
The Adjustment Rule Details tab appears.
You can Edit the Description, Add or Delete the Expressions, and can Save or Submit the Definition on the Adjustment Rule Details page.
5. After the adjustment rule is submitted, the definition moves to the Approved state and can be used by GL definitions for the execution.
When you click the Add or View icon the Adjustment Entry details page is displayed.
This Adjustment Rule Details page consists of the following tabs:
In the Data Adjustments Rules page, click the Add icon, the Adjustment Add tab with Rule Designer pane is displayed.
Figure 67: Adjustment Add Tab with Rule Designer Pane
In the Adjustment Add tab, follow these steps:
1. Select a value from the Adjustment Entry from the dropdown list.
Figure 68: Adjustment Entry list
You can also search the Adjustment Entry from the search filter.
2. Select the Entity Attribute that you want to define for the selected Adjustment Entity. You can also search the Entity Attributes from the search filter.
Figure 69: All Adjustment Entity
You can navigate to attributes using the pagination option from the attributes menu.
3. Add the Expression for the selected attribute using any of the following steps:
a. Select the Lookup Entity and Lookup Attribute from the drop-down list.
Figure 70: Lookup Entity and Lookup Attribute drop-down list
NOTE:
The data type should be the same for the Entity Attribute and Lookup Attribute.
OR,
b. Select the default toggle button to add the Expression manually.
Figure 71: Adding Expression manually
You can define multiple Entity Attributes.
4. Click the Save Expression button. The Defined button displays all the defined attributes.
Figure 72: Defined Attributes
You can select all the defined entity attributes using
the Select All 
icon, or delete any
entity attribute using the Delete icon.
In the Properties pane, enter the Adjustment Definition Name and Description. Click the Save button. The Submit button is displayed. Click Submit. The Adjustment ID is auto-generated.
Figure 73: Save and Submit the added Adjustment
NOTE:
For Data Adjustments, any new entity added must be created in FSI_ADJUSTMENT_TABLES.