For example, in banking, for a house loan/mortgage product transaction with a customer, following questions can be asked for each Mortgage transaction
What is the mortgage product?
What is the customer account number?
What is the profit as of date from this mortgage account?
What is the interest accrued on this account ?
What is the term of the mortgage/house loan?
Is this tracking base rate? if so what is the tracker and current base rate?
If this is fixed price mortgage, then what is the fixed price rate and term
Is the payment received as direct debit?
Which bank branch does this account reside?
What is the call centre expense for this account, based on number of calls received from the customer for this specific mortgage account?
What is the frequency at which the interest is compounded?
In case of OFSAA, the Mortgage instrument table named FSI_D_MORTGAGES contains approx 250 attributes, each of which answers the questions listed above, as shown in the screenshot below.
Rather than each bank spending time and money on analysts to decipher the attributes related to the product, the OFSAA product comes out of the box model with these attributes.
This helps to speed up the implementation, so that the implementation teams can simply concentrate on making the data available for these product types.
Typically you will find that Oracle have created one instrument table for each product type out of the box. These tables come pre-registered with the OFSAA’s analytical engine.
Oracle keeps on adding new tables to the list of instrument tables. However, if a specific product type does not have a corresponding instrument table then implementation team can create new tables and register those with the OFSAA’s data model.
| List of OFSAA Instrument tables |
| FSI_D_ANNUITY_CONTRACTS |
| FSI_D_ANNUITY_TXNS |
| FSI_D_BORROWINGS |
| FSI_D_BORROWINGS_TXNS |
| FSI_D_BREAK_FUNDING_CHARGES |
| FSI_D_CASA |
| FSI_D_CASA_TXNS |
| FSI_D_CREDIT_CARDS |
| FSI_D_CREDIT_CARDS_TXNS |
| FSI_D_CREDIT_LINES |
| FSI_D_CREDIT_LINES_TXNS |
| FSI_D_DERIVATIVES |
| FSI_D_FORWARD_RATE_AGMTS |
| FSI_D_FUTURES |
| FSI_D_FX_CONTRACTS |
| FSI_D_GUARANTEES |
| FSI_D_GUARANTEES_TXNS |
| FSI_D_INVESTMENTS |
| FSI_D_INVESTMENTS_TXNS |
| FSI_D_LEASES |
| FSI_D_LEASES_TXNS |
| FSI_D_LEDGER_STAT_INSTRUMENT |
| FSI_D_LOAN_CONTRACTS |
| FSI_D_LOAN_CONTRACTS_TXNS |
| FSI_D_MERCHANT_CARDS |
| FSI_D_MM_CONTRACTS |
| FSI_D_MM_CONTRACTS_TXNS |
| FSI_D_MORTGAGE_BACK_SEC |
| FSI_D_MORTGAGE_BACK_SEC_TXNS |
| FSI_D_MORTGAGES |
| FSI_D_MORTGAGES_TXNS |
| FSI_D_MUTUAL_FUNDS |
| FSI_D_OPTIONS |
| FSI_D_OTHER_SERVICES |
| FSI_D_PAYMENT_SCHEDULE |
| FSI_D_RETIREMENT_ACCOUNTS |
| FSI_D_RETIREMENT_ACCTS_TXNS |
| FSI_D_SWAPS |
| FSI_D_TERM_DEPOSITS |
| FSI_D_TRUSTS |
| FSI_D_TRUSTS_TXNS |
Comments
(1)
Subscribe to this comment's feed
It's time to start living the life you've imagined.