This chapter provides information about LRS pack (Liquidity Risk Solutions pack, which was formerly Liquidity Risk Management) Processing to FSDF Results Integration in the Oracle Financial Services Data Foundation application and step-by-step instructions to use this section. The LRS pack consists of the following two application IDs:
· LRM_LCR (for Liquidity Coverage Ratio)
· LRM_DIC (for Deposit Insurance)
Topics:
· Overview of the LRS Pack Processing to FSDF Results Integration Tables
· Overview of the LRS Pack Processing to FSDF Results Integration
· Executing the LRS Pack Processing to FSDF Results Integration T2Ts
· Checking the Execution Status
· Retrieving the LRS Pack Processing to FSDF Results Integration T2T Definitions
As part of LRS pack processing to FSDF results integration, FSDF tables are loaded from LRS pack processing tables using Table to Table (T2T) component of Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) framework. These are the Result tables that store integrated results:
· FCT_LRM_ACCOUNT_SUMMARY
· FCT_DEP_INS_ACCT_PARTY_DETL
· FCT_DEP_INS_BENEFICIARY_DTL
NOTE:
As part of LRS pack processing results to FSDF integration, FSDF packages the T2Ts mentioned in the next section. These are optional T2Ts that are deployed only when OFS_TR_PACK is installed.
These are the Table-to-Table seeded definitions to load data into the target tables.
Source Table Name |
Target Table Name |
T2T Name |
|---|---|---|
FSI_LRM_INSTRUMENT |
FCT_LRM_ACCOUNT_SUMMARY |
T2T_FCT_LRM_ACCOUNT_SUMMARY |
FCT_DEPOSIT_INSURANCE_DETAILS |
FCT_DEP_INS_ACCT_PARTY_DETL |
T2T_FCT_DEP_INS_ACCT_PARTY_DETL |
FCT_DEPOSIT_INSURANCE_DETAILS |
FCT_DEP_INS_BENEFICIARY_DTL |
T2T_FCT_DEP_INS_BENEFICIARY_DTL |
For LRS Pack FSDF integration, you must have FSDF and LRS pack installed on the same INFODOM. There are two ways to integrate LRS pack and FSDF:
1. Creating Integrated Run at Implementation Site: During implementation, you can merge the tasks of both LRS pack and FSDF, and create an integrated Run to execute each time. The processes inside Run must be in the sequence LRS pack first, and then FSDF, and finally the LRS FSDF Integration process. In this Run, the LRS pack processing area and the FSDF results area tables must consist of the same Run SKEY across all tables.
NOTE:
The Request Report Flag, Override Report Flag, and Approve Report Flag options are not available in the LRS PMF page to enable the Reporting Flag. Therefore, for LRS-FSDF Integration Run, use the FSDF PMF screen.
2. Using approved LRS Run Execution ID in FSDF Run: In this case, you can use the out-of-the-box LRS pack Run as is for execution. After the execution, if the values are correct, you can execute the out-of-the-box FSDF Run by selecting the required LRS Run SKEY from the PMF screen. In this case, LRS pack processing area consists of one RUN SKEY and for the same data, FSDF consists of a different RUN SKEY in FSDF results area tables, where the data is getting reported. To generate a sample report, follow these steps:
a. Login to Oracle Financial Services Analytical Applications interface with your credentials.
b. Navigate to the Process Modeller page. For navigation, see the section Executing Run through Process Modelling Framework in OFSDF.
c. Select Execute Run.
d. The Select Run Params window is displayed.
e. Enter the Run Execution Description. The LRS Run Execution Identifier and FIC MIS Date is auto-populated from the LRS Run report used.
f. Click OK.
NOTE:
After LRS execution, to get values in this LRS Run Execution Identifier, Resave Hierarchy HFSDF006 (FSDF LRS Run Execution Identifier for Run).
Figure 101: Integration of LRS Pack and FSDF using approved LRS Pack Run Execution ID in FSDF Run
g. Select only one LRS Run from the Available Hierarchies for the execution and click OK.
The status of execution can be monitored in the Process Monitor page.
NOTE:
For a more comprehensive coverage of configuration and execution of a process, see the section Executing Run through Process Modelling Framework in OFSDF and the Oracle Financial Services Analytical Applications Infrastructure Process Modelling Framework Orchestration Guide Release 8.1.2.0.0.
Access the execution log on the application server in the following directory:
ftpshare/logs/<Run_Date>/FSDFINFO/LOAD DATA
The file name contains the batch execution ID. The error log table in the atomic schema is as follows:
· FCT_LRM_ACCOUNT_SUMMARY$
· FCT_DEP_INS_ACCT_PARTY_DETL$
· FCT_DEP_INS_BENEFICIARY_DTL$
T2T definitions can be retrieved as an excel document for reference from the metadata browser of the Unified Metadata Manager (UMM) component of OFSAAI.