This section provides information about Transaction Summary tables in the Oracle Insurance Data Foundation application and step-by-step instructions to use this section.
Topics:
· About Transaction Summary T2T (Result Table)
· Deploying Transaction Summary Result Tables on Hive
· Populating Transaction Summary T2T Result Tables
The Fact Transaction Summary stores data from the stage transactions table for further operation reporting. The data is moved through a T2T process from stage to fact, which ensures that the stage data is available in a single table in the result area.
Transaction Summary T2Ts and their description are given here.
T2T Name |
T2T Description |
|---|---|
T2T_STG_ANNUITY_TXNS_FTS |
This T2T stores the details of annuity transactions. |
T2T_STG_CREDIT_DERIVATIVES_TXNS_FTS |
This T2T stores the details of credit derivatives transactions. |
T2T_STG_FOREX_TXNS_FTS |
This T2T stores the details of Forex account transactions. |
T2T_STG_FUTURES_TXNS_FTS |
This T2T stores the details of futures contract transactions. |
T2T_STG_INVESTMENT_TXNS_FTS |
This T2T stores the details of investment transactions. |
T2T_STG_LOAN_CONTRACT_TXNS_FTS |
This T2T stores transactions that occurred on loan contracts. |
T2T_STG_MM_TXNS_FTS |
This T2T stores details of money market transactions. |
T2T_STG_MUTUAL_FUNDS_TXNS_FTS |
This T2T stores details of mutual fund transactions. |
T2T_STG_OPTION_CONTRACTS_TXNS_FTS |
This T2T stores details of option contracts transactions. |
T2T_STG_RETIREMENT_ACCOUNTS_TXNS_FTS |
This T2T stores the details of transactions that occurred on Retirement accounts. |
T2T_STG_SWAP_ACCOUNT_TXNS_FTS |
This T2T stores the details of swap account transactions. |
T2T_STG_TRUSTS_TXNS_FTS |
This T2T stores the details of transactions that occurred on trust accounts. |
T2T_STG_COMMODITIES_TXNS_FTS |
This T2T stores the details of commodity transactions. |
T2T_STG_CUSTODIAN_ACCOUNT_TXNS_FTS |
This T2T stores the details of transactions for a custodian account. |
T2T_STG_REPO_TRANSACTIONS_FTS |
This T2T stores the details of repurchase and reverse repurchase transactions. |
T2T_STG_TRADING_ACCOUNT_TXNS_FTS |
This T2T stores the details of transactions done on a trading account. |
The mapping details for the Transaction Summary T2Ts are given here.
Source Table Name |
Logical Stage Table Name |
Fact Table Name |
Logical Fact Table Name |
T2T Name |
|---|---|---|---|---|
STG_ANNUITY_TXNS |
Stage Annuity Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Annuity Transactions |
T2T_STG_ANNUITY_TXNS_FTS |
STG_CREDIT_DERIVATIVES_TXNS |
Stage Credit Derivatives Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_CREDIT_DERIVATIVES_TXNS_FTS |
STG_FOREX_TXNS |
Stage Forex Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_FOREX_TXNS_FTS |
STG_FUTURES_TXNS |
Stage Futures Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_FUTURES_TXNS_FTS |
STG_INVESTMENT_TXNS |
Stage Investment Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_INVESTMENT_TXNS_FTS |
STG_LOAN_CONTRACT_TXNS |
Stage Loan Contract Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_LOAN_CONTRACT_TXNS_FTS |
STG_MM_TXNS |
Stage Money Market Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_MM_TXNS_FTS |
STG_MUTUAL_FUNDS_TXNS |
Stage Mutual Funds Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_MUTUAL_FUNDS_TXNS_FTS |
STG_OPTION_CONTRACTS_TXNS |
Stage Option Contracts Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_OPTION_CONTRACTS_TXNS_FTS |
STG_RETIREMENT_ACCOUNTS_TXNS |
Stage Retirement Accounts Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_RETIREMENT_ACCOUNTS_TXNS_FTS |
STG_SWAP_ACCOUNT_TXNS |
Stage Swap Account Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_SWAP_ACCOUNT_TXNS_FTS |
STG_TRUSTS_TXNS |
Stage Trusts Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_TRUSTS_TXNS_FTS |
STG_COMMODITIES_TXNS |
Stage Commodities Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_COMMODITIES_TXNS_FTS |
STG_CUSTODIAN_ACCOUNT_TXNS |
Stage Custodian Account Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_CUSTODIAN_ACCOUNT_TXNS_FTS |
STG_REPO_TRANSACTIONS |
Stage Reporting Transactions |
FCT_TRANSACTION_SUMMARY |
Fact Transaction Summary |
T2T_STG_REPO_TRANSACTIONS_FTS |
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: