After the OFSAAI platform is deployed, the OFSAA Reconciliation Framework has to be deployed. For more information on installing the OFSAA Reconciliation Framework, see the OFSAA Reconciliation Framework, Release 8.1.0.0.0 Installation Manual.
You now have the choice to perform model upload through the installer or manually. To perform model upload manually, follow these steps:
1. Click Data Model Management on the left pane of the OFSAAI platform.
2. Navigate to Data Model Management, and select Data Model Maintenance.
Figure 5: Business Model Upload Summary Page
3. Click + Add icon to open up the Business Model Upload window.
Figure 6: Business Model Upload Window
4. In the Business Model Upload window, enter the Mandatory fields.
5. In the Upload Details pane, enter the Model Name and Select Upload Options as Erwin.
6. Select the Upload Model from the drop-down list. You can select Incremental, Rebuild, or Sliced upload mode.
7. Select the Object Registration Mode from the drop-down list as Full Object Registration or Incremental Object Registration. You can select Incremental Object Registration for the Upload Mode as Incremental and Sliced. It is recommended to select incremental only if the changes are minimal.
8. Select the Erwin XML or Database XML file for upload from the File Name drop-down list.
9. In the Additional Options pane, select the required options.
10. Click the Upload Model button to upload the model.
For more details, see the Model Upload Utility section of the OFS Analytical Applications Infrastructure User Guide.
The most important activity, to commence working on the application, is the configuration of data. Data can be divided into two categories:
· Setup Table: SETUP_GL_DIMENSIONS_MAP
· Stage Table: STG_SRC_GLCODE_MAP
A setup table is a set of data that is static and does not change at regular intervals. This is a set of seeded data that refers to the initial data that is provided with the application. Stage table data consists of Product Processors and a set of other stage tables for which you can see the Download Specifications document. The seeded tables of Currency and GAAP Codes can be edited to add specific currencies and GAAP codes in use.
Topics:
Additional dimensions can be made available for the Reconciliation types using the below-mentioned setup table (SETUP_GL_DIMENSIONS_MAP). This table is being used to set up the additional dimensions used for the reconciliation process.
Figure 7: Setup Table
While uploading data into STG_SRC_GLCODE_MAP ensure the following:
If a new set of data is to be added in the table STG_SRC_GLCODE_MAP, then ensure that this data is added to the existing set of records as incremental data for the batch to be executed successfully. Once new data is uploaded, for all subsequent executions see the new mapping. Execution based on old GL code mapping is not permitted.
The application automatically matches similar GL codes from the Product Processor entity and general ledger entity and the reconciliation definition difference is computed. However, you must create mappings when GL codes differ across the Product Processor entity and general ledger entity.
|
FIC_MIS_DATE |
V_SOURCE_GL_CODE |
V_TARGET_GL_CODE |
|---|---|---|
|
12/31/2010 |
GL1001 |
GL1001 |
For any other not null attribute a dummy value can be provided.
GL Reconciliation application also requires you to specify the physical column names of (for example, End of Period Balance (N_EOP_BAL), Accrued Interest) Product Processor (PP) entities, for which the reconciliation definition process must be executed. See Setting up Data for more information.
NOTE:
You also have the option to reconcile GL codes with other operational data used by the bank, which does not flow into the standard Product Processors configured in the application. For more information on adding operational data tables to the data, see Data Model and Metadata Extensions.
The list of Product Processors supported by this application is as follows.
|
Product Processor |
Table Name |
|---|---|
|
BILLS |
STG_BILLS_CONTRACTS |
|
BORROWINGS |
STG_BORROWINGS |
|
CARDS |
STG_CARDS |
|
CASA |
STG_CASA |
|
EQUITY |
STG_EQUITY_EXPOSURES |
|
FUTURES |
STG_FUTURES |
|
FX_CONTRACTS |
STG_FX_CONTRACTS |
|
INVESTMENTS |
STG_INVESTMENTS |
|
LC |
STG_LC_CONTRACTS |
|
LEASES_CONTRACTS |
STG_LEASES_CONTRACTS |
|
LOANS |
STG_LOAN_CONTRACTS |
|
MM CONTRACTS |
STG_MM_CONTRACTS |
|
MUTUAL_FUNDS |
STG_MUTUAL_FUNDS |
|
OD |
STG_OD_ACCOUNTS |
|
OPTIONS |
STG_OPTION_CONTRACTS |
|
REPO_CONTRACTS |
STG_REPO_CONTRACTS |
|
TD_CONTRACTS |
STG_TD_CONTRACTS |
The following table provides the list of entity names and their corresponding measures.
|
Entity Name |
Measures |
|---|---|
|
Stage General Ledger Data |
· Amount In Accounting Currency · Amount In Local Currency |
|
Stage Management Ledger |
· Average Balance Amount · Balance · Movement Amount · Movement Mtd · Movement Ytd |
|
Stage Repo Contracts |
· End Of Period Balance · Write Off Amount |
|
Stage Option Contracts |
· End Of Period Balance |
|
Stage Investments |
· End Of Period Balance |
|
Stage Loan Contracts |
· Accrued Interest · End Of Period Balance · End Of Period Book Balance · Provisions Amount |
|
Stage Casa Account |
· Commission Amount · End Of Period Balance · Write Off Amount |
|
Stage Cards |
· Accrued Interest · Account Attrition Score · End Of Period Balance |
|
Stage Term Deposit Contracts |
· Commission Amount · End Of Period Balance |
|
Stage Mutual Funds |
· Commission Amount · End Of Period Balance |
|
Stage Futures Contracts |
· End Of Period Balance · Write Off Amount |
|
Stage Leases Contracts |
· End Of Period Balance · Write Off Amount |
|
Stage Bill Contracts |
· End Of Period Balance |
|
Stage Money Market Contracts |
· Commission Amount · End Of Period Balance |
|
Stage Letter Of Credit Contracts |
· End Of Period Balance |
|
Stage Borrowings |
· Commission Amount · End Of Period Balance |
|
Stage Foreign Exchange Contracts |
· End Of Period Balance |
|
Stage Over Draft Accounts |
· End Of Period Balance · Write Off Amount |