11.3 POI Tables and External Engine T2Ts

The following POI (Processing Output Integration) Staging Tables are created in the OFSDF in the respective Application-specific Subject Areas to source the External Engine Data from the listed Applications to OFSDF:

Table 26: POI Tables, T2T Names, and the corresponding OFSAA Application Name

POI Table Name (Source)	Target Table Name	T2T Name	OFSAA Application Name
POI_IFRS_CREDIT_LINE_DETAILS	FCT_IFRS_CREDIT_LINE_DETAILS	T2T_FCT_IFRS_CREDIT_LINE_DETAILS	OFS IFRS
POI_IFRS_MITIGANTS_SUMMARY	FCT_IFRS_MITIGANTS_SUMMARY	T2T_FCT_IFRS_MITIGANTS_SUMMARY	OFS IFRS
POI_IFRS_PLACED_COLLATERAL	FCT_IFRS_PLACED_COLLATERAL	T2T_FCT_IFRS_PLACED_COLLATERAL	OFS IFRS
POI_LLFP_CRE_FACILITY_SUMMARY	FCTI_LLFP_CRE_FACILITY_SUMMARY	T2T_FCT_LLFP_CRE_FACILITY_SUMMARY	OFS LLFP
POI_COHORT_LOAN_LOSS_DETAILS	FCT_COHORT_LOAN_LOSS_DETAILS	T2T_FCT_COHORT_LOAN_LOSS_DETAILS	OFS LLFP
POI_LRM_MITIGANTS_SUMMARY	FCT_LRM_MITIGANTS_SUMMARY	T2T_FCT_LRM_MITIGANTS_SUMMARY	OFS LRM
POI_LRM_PLACED_COLLATERAL	FCT_LRM_PLACED_COLLATERAL	T2T_FCT_LRM_PLACED_COLLATERAL	OFS LRM
POI_HEDGE_DETAILS	FCT_REG_HEDGE_DETAILS	T2T_FCT_REG_HEDGE_DETAILS	OFS HM

NOTE

The External Engine T2Ts are not a part of the default PMF in OFSDF. Customers can include T2Ts in PMF as required. To include T2Ts in PMF, the EXTERNAL_ENGINE_RUN Batch, containing the External Engine related POI Tables and Fact Tables, need to be tailored to a PMF process. Therefore, execute the pmf_EXTERNAL_ENGINE_LOAD_RUN.sql Script.

POI SCD Batch Name is ##INFODOM##_EXTERNAL_ENGINE_SCD. The Script Files execution order is as follows:

1. poi_batch_master.sql

2. poi_batch_task_master.sql

3. poi_batch_parameter_master.sql

4. poi_batch_task_precedence_master.sql

For more information, see the Configure and Use the External Engine POI Tables section in the Oracle Financial Services Data Foundation Application Pack Installation and Configuration Guide Release 8.1.2.0.0.