This chapter provides information about Fiduciary Services Investment Summary tables in the Oracle Financial Services Data Foundation application and step-by-step instructions to use this section.
Topics:
· Overview of the Fiduciary Services Investment Summary Tables
· Overview of the Fiduciary Services Investment Summary Population
· Executing the Fiduciary Services Investment Summary T2Ts using PMF
· Checking the Execution Status
· Retrieving the Fiduciary Services Investment Summary T2T Definitions
Fiduciary Services Investment Summary table is loaded from the staging product processor table using the Table to Table (T2T) component of Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) framework.
A fiduciary is responsible for managing the assets of another person, or of a group of people. The fiduciary is expected to manage the assets for the benefit of the customer. The customer can open a trust account that would have the different investments that the person would do. The customer would have different assets under the trust such as Investments, Mututal Funds, CASA, Term Deposit etc. So, in these T2Ts the target table is loaded only with those records which are of fiduciary service type which is identified using Parent Account Number in each Product Processor table.
The Fact Fiduciary Services Investment Summary stores records from the Stage CASA, Stage Custodial Accounts, Stage Investments, Stage Managed Inv Adv, Stage Mutual Funds, Stage Retirement Accounts, Stage TD Contracts and Stage Trusts, that has valid Parent Account Number for further operation and regulatory reporting.
Table to Table seeded definitions are provided for loading data into the target table Fct Fiduciary Serv Invst Summary (FCT_FIDUCIARY_SERV_INVST_SUMM):
Table 50: Fiduciary Services Investment Summary T2T Definitions
Source Table Name |
T2T Definition Name |
STG_CASA |
T2T_FFSIS_STG_CASA |
STG_CUSTODIAL_ACCOUNTS |
T2T_FFSIS_STG_CUSTODIAL_ACCOUNTS |
STG_INVESTMENTS |
T2T_FFSIS_STG_INVESTMENTS |
STG_MANAGED_INV_ADV |
T2T_FFSIS_STG_MANAGED_INV_ADV |
STG_MUTUAL_FUNDS |
T2T_FFSIS_STG_MUTUAL_FUNDS |
STG_RETIREMENT_ACCOUNTS |
T2T_FFSIS_STG_RETIREMENT_ACCOUNTS |
STG_TD_CONTRACTS |
T2T_FFSIS_STG_TD_CONTRACTS |
STG_TRUSTS |
T2T_FFSIS_STG_TRUSTS |
The T2Ts are a part of Financial Services Data Foundation Sourced Run. The process can be executed through the out-of-the-box standard Run, which is Financial Services Data Foundation Execution Run. For more information, see the section Executing Run through Process Modelling Framework in OFSDF.
NOTE |
While executing through Run, the RUNSkey will be auto-generated and stamped against each record. |
The following most common error message may be logged in the T2T log file directory ftpshare/logs/<Run_Date>/FSDFINFO/LOAD DATA:
Unique Constraint Violation
This error occurs after there is an attempt to re‐load or load the existing records for the already executed AS_OF_DATE.
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.0.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_FIDUCIARY_SERV_INVST_SUMM$
T2T definitions can be retrieved as an excel document for reference from the metadata browser of the Unified Metadata Manager (UMM) component of OFSAAI.