This section provides information about Loan Account Summary tables in the Oracle Insurance Data Foundation application and step-by-step instructions to use this section.
Topics:
· About Loan Account Summary T2T (Result Table)
· Deploying Loan Account Summary Tables on Hive
· Populating Loan Account Summary T2T Result Tables
· Related Topics
Loan Account Summary provides a detailed report of insurance transactions done.
Loan Account in Insurance is used, when an insured takes a loan against his or her policy. The policy code is used to track the loan and its outstanding amount for the reporting if the policy is closed and then decided how to treat the loan.
Loan Account Summary T2T and its description is given here.
T2T Name |
T2T Description |
|---|---|
T2T_FLAS_STG_LOAN_CONTRACTS |
This T2T stores the details of loan contracts. This table includes mortgage and vehicle loans. |
The mapping details for the Loan Account Summary T2T is given here.
Source Table Name |
Logical Stage Table Name |
Fact Table Name |
Logical Fact Table Name |
T2T Name |
|---|---|---|---|---|
STG_LOAN_CONTRACTS |
Stage Loan Contracts |
FCT_LOAN_ACCOUNT_SUMMARY |
Fact Loan Account Summary |
T2T_FLAS_STG_LOAN_CONTRACTS |
All RDBMS related Result tables can also be deployed on Hive (Stage and Results). Deploy the Hive T2Ts using the Rules Run Framework. For more information, see the Rules Run Framework section in the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.1.0.0.
NOTE:
In general, Stage and Result tables are also supported in Hive. However, there are some exceptions. For a list of tables that are not supported in Hive, see List of Unsupported T2Ts
Follow this T2T process to populate data into any T2T Result table:
NOTE:
Only RDBMS T2Ts can be executed using the PMF.
1. To populate data into any T2T Result table, execute the PMF process for that T2T. For a detailed procedure, see the following sections:
a. Prerequisites for loading T2T.
b. Select the Run Parameters and Execute the Run.
2. To check the T2T execution status and verify the log files of any Result table, follow the procedure in the Verify the Run Execution section.
3. To check the error messages, if any, follow the procedure in the Check Error Messages section.
You can see the following topics related to other function-specific tables: