This chapter provides information about Populating Placed Collateral Tables in the Oracle Financial Services Data Foundation application and step-by-step instructions to use this section.
Topics:
· Overview of the Placed Collateral Tables
· Overview of the Placed Collateral Population
· Executing the Placed Collateral T2Ts using PMF
· Checking the Execution Status
· Retrieving the Placed Collateral Result T2T Definitions
Placed Collateral Tables are loaded from respective Stage tables using the Table to Table (T2T) component of Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) framework. Following are the Results Tables that stores Placed Collateral Population:
· FCT_PLACED_COLLATERAL
· FCT_ACCT_PLACED_COLL_MAP
Table to Table seeded definitions are provided for loading data into the target tables.
Source Table Name |
Target Table Name |
T2T Definition Name |
|---|---|---|
STG_PLACED_COLLATERAL |
FCT_PLACED_COLLATERAL |
T2T_FCT_PLACED_CO LLATERAL |
STG_ACCT_PLACED_COLL_MAP |
FCT_ACCT_PLACED_COLL_MAP |
T2T_FCT_ACCT_PLACED_COLL_MAP |
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:
When 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_PLACED_COLLATERAL$
· FCT_ACCT_PLACED_COLL_MAP$
T2T definitions can be retrieved as an excel document for reference from the metadata browser of the Unified Metadata Manager (UMM) component of OFSAAI.