Files Impacting Database

A.1.2 Files Impacting Database

This section lists the files impacting the database.

The following files impact the database:

FCC_UI_MODULE_CONF.sql
PR_8.1.2.1.0_34012573.miner.sql
PR_8.1.2.3.30_36008428.business
CR_8.1.2.7.0_35363987.miner.sql
FCC_UI_MODULE_CONF_8121ML.sql
BD_FSDM.xml
P_FCC_JIT_SEC_MAP.sql
P_JIT_SYNCH_ADHOC_BATCH.sql
P_JIT_USER_DISABLE.sql
FN_JIT_SYNCH_ADHOC_BATCH.sql
FN_JIT_USER_DISABLE.sql
PLC_FN_JIT_SYNCH_ADHOC_BATCH.sql
PLC_FN_JIT_USER_DISABLE.sql
34332109_MESSAGES_EN_US.sql
34332109_FCC_UI_MODULE_CONF
PKG_KYC_ACTIONS.sql
PKG_KYC_ACTIONS_BODY.sql
PKG_PTC_MANUAL_OKYC_BODY.sql
PKG_PTC_MANUAL_OKYC.sql
LOAD_FCT_CUST_REVIEW_REASONS.sql
FN_POPULATE_PRCSNG_KYC.sql
F_RA_TO_CASE_MNUL.sql
CUST_IP_SNAPHSOT.sql
34637484_APPLN_INSTALL_PARAMS.sql
APPLN_REREVIEW_PARAMS_8123.sql
MAP_EVAL_RISK_ASSMNT_MODEL_8123.sql
FN_POPULATE_IP_KYC.sql
MAP_EVAL_RISK_ASSMNT_MODEL_8124.sql
8125_FCC_UI_MODULE_CONF.sql
P_UPDATE_MPTC_DUEDT.sql
8126_FCC_UI_MODULE_CONF.sql
FCT_RA_RISK_DETAILS.sql
FCT_RA_RISK_REASONS.sql
FCT_RA_RISK_SUMMARY.sql
KDD_CASE_LINKS_MPTC_INS_HIST.sql
REV_BIHIER_KYC_SIMULATION.sql
F_VAL_RA_FOR_CASE.sql
P_SW_TESTING_SCENARIO_BODY.sql
35680852_KDD_INSTALL_PARAM.sql
35680852_KDD_KDD_CTR_ACTVY_TYPE_RVW_STATUS.sql
35680852_KDD_CTR_ROLE_ACTIVITY_TYPE.sql
35895028_AAI_MENU.sql
OJF_CTREncrypt.sql
CTR_OJET_MENU.sql
34637484_MESSAGES_EN_US.sql
35189486_CSSMS_START_PAGE_MASTER.sql 
35624897_MESSAGES_EN_US.sql
35482609_MESSAGES_EN_US.sql
35624897_KDD_INSTALL_PARAM.sql
35624897_KDD_QUEUE_MASTER.sql
35252946_MESSAGES_EN_US.sql
OJF_CTR_CreateCTR.sql
OJF_CTR_CreateTrxnG.sql
OJF_CTR_Action.sql
OJF_CTR_AttchmntG.sql
OJF_CTR_AttchmntP.sql
OJF_CTR_Attchmnt_Add.sql
OJF_CTR_AuditG.sql
OJF_CTR_AuditP.sql
OJF_CTR_CommentG.sql
OJF_CTR_CommentP.sql
OJF_CTR_Comment_Add.sql
OJF_CTR_CrtDOEPEfileG.sql
OJF_CTR_CrtDOEPEfileP.sql
OJF_CTR_CrtEfileG.sql
OJF_CTR_CrtEfileP.sql
OJF_CTR_DEFL_Context.sql
OJF_CTR_DEFL_Details.sql
OJF_CTR_Det_Action.sql
OJF_CTR_DOEPAuditG.sql
OJF_CTR_DOEPAuditP.sql
OJF_CTR_DOEPEFile_CTR.sql
OJF_CTR_DOEPEFile_ErrG1.sql
OJF_CTR_DOEPEFile_ErrG2.sql
OJF_CTR_DOEPEFile_ErrP.sql
OJF_CTR_DOEPEFL_ListG.sql
OJF_CTR_DOEPEFL_ListP.sql
OJF_CTR_EFile_CTR.sql
OJF_CTR_EFile_ErrG1.sql
OJF_CTR_EFile_ErrG2.sql
OJF_CTR_EFile_ErrP.sql
OJF_CTR_EFL_Context.sql
OJF_CTR_EFL_Details.sql
OJF_CTR_EFL_ListG.sql
OJF_CTR_EFL_ListP.sql
OJF_CTR_EvidenceP.sql
OJF_CTR_GenDOEPEfile.sql
OJF_CTR_GenEfile.sql
OJF_CTR_Inc_CtrsG.sql
OJF_CTR_Inc_ExmG.sql
OJF_CTR_ListG.sql
OJF_CTR_ListP.sql
OJF_CTR_ReportContext.sql
OJF_CTR_ReportDetails.sql
OJF_CTR_Show_AtchmntG.sql
OJF_CTR_Show_AtchmntP.sql
OJF_CTR_View_AtchmntG.sql
OJF_CTR_View_AtchmntP.sql
OJF_MIT_AddRep.sql
OJF_MIT_AuditG.sql
OJF_MIT_DeleteComments.sql
OJF_MIT_EditRep.sql
OJF_MIT_ListG.sql
OJF_MIT_ListP.sql
OJF_CTR_DOEPEvidenceP.sql
OJF_CTR_DOEPAttchmntP.sql
OJF_CTR_DOEPCommentG.sql
OJF_CTR_DOEPAttchmntG.sql
OJF_CTR_AccountG.sql
OJF_CTR_AccountP.sql
OJF_CTR_CashInG.sql
OJF_CTR_CashInP.sql
OJF_CTR_CashOutG.sql
OJF_CTR_CashOutP.sql
OJF_CTR_CTRAuditP.sql
OJF_CTR_DOEPCommentP.sql
OJF_CTR_EXE_ListG.sql
OJF_CTR_EXE_ListP.sql
OJF_CTR_FinCen_AknlP.sql
OJF_CTR_FinCen_Aknl_PrmG.sql
OJF_CTR_FinCen_Aknl_SecG.sql
OJF_CTR_Init_VaditP.sql
OJF_CTR_Init_Vadit_ErrG.sql
OJF_CTR_Init_Vadit_WrnG.sql
OJF_CTR_PerAddressG.sql
OJF_CTR_PerAddressP.sql
OJF_CTR_PerAddToCTRG.sql
OJF_CTR_PerAddToCTRP.sql
OJF_CTR_PersonsG.sql
OJF_CTR_PersonsP.sql
OJF_CTR_Persons_Dtls.sql
OJF_CTR_Person_TranG.sql
OJF_CTR_Person_TranP.sql
OJF_CTR_Per_AcctInG.sql
OJF_CTR_Per_AcctOutG.sql
OJF_CTR_Per_AcctP.sql
OJF_CTR_Per_Addr_Add.sql
OJF_CTR_Per_Addr_Edit.sql
OJF_CTR_Per_Inv_edit.sql
OJF_CTR_Per_Inv_ListB.sql
OJF_CTR_Per_Inv_ListE.sql
OJF_CTR_PI_Edit.sql
OJF_CTR_PrntFI_G.sql
OJF_CTR_PrntFI_P.sql
OJF_CTR_RepFinG.sql
OJF_CTR_RepFinP.sql
OJF_CTR_TransactionG.sql
OJF_CTR_TransactionP.sql
OJF_CTR_Trans_Summary.sql
OJF_CTR_Trxn_AddG.sql
OJF_CTR_Trxn_AddP.sql
OJF_CTR_Trxn_Edit.sql
OJF_CTR_Xsd_VaditG.sql
OJF_CTR_Xsd_VaditP.sql
OJF_CTR_EXE_Create
OJF_CTR_EXE_Tin_Cust
OJF_CTR_CustTIN_DET.sql
OJF_CTR_Cust_DET_P.sql
OJF_CTR_EXE_AccD.sql
OJF_CTR_EXE_AccG.sql
OJF_CTR_EXE_AccP.sql
OJF_CTR_EXE_Acctin.sql
OJF_CTR_EXE_Acctin_EX.sql
OJF_CTR_EXE_Act.sql
OJF_CTR_EXE_Action.sql
OJF_CTR_EXE_Context.sql
OJF_CTR_EXE_CustG.sql
OJF_CTR_EXE_CustP.sql
OJF_CTR_EXE_Cust_AcG.sql
OJF_CTR_EXE_Cust_AcP.sql
OJF_CTR_EXE_Cust_Adr_Add.sql
OJF_CTR_EXE_Cust_Edit.sql
OJF_CTR_EXE_Cust_Ph_Add.sql
OJF_CTR_EXE_Cu_Adr_Edit.sql
OJF_CTR_EXE_Cu_Eml_Add.sql
OJF_CTR_EXE_Cu_Eml_Edit.sql
OJF_CTR_EXE_Cu_Ph_Edit.sql
OJF_CTR_EXE_Details.sql
OJF_CTR_EXE_Info_AddG.sql
OJF_CTR_EXE_Info_EmlG.sql
OJF_CTR_EXE_Info_PhnG.sql
OJF_CTR_EXE_Rel_CTRG.sql
OJF_CTR_EXE_Rel_CTRP.sql
OJF_CTR_EXE_TIN_CustG.sql
OJF_CTR_EXE_TransG.sql
OJF_CTR_EXE_TransP.sql
OJF_CTR_EXM_Acc_Dtl.sql
OJF_CTR_EXM_CONT_INFOP.sql
OJF_CTR_EXM_Cust_Dtl.sql
OJF_CTR_PrntFI_Edit.sql
OJF_CTR_RepFinDetails.sql
OJF_CTR_RepFinEdit.sql
OJF_CTR_RepFin_DTL.sql
OJF_CTR_RepFin_Edit.sql
OJF_CTR_EXE_CustCmtG.sql
OJF_CTR_EXE_CustCmtAdd.sql
OJF_CTR_EXE_CustAtcmntG.sql
OJF_CTR_EXE_CustAtcmntAdd.sql
OJF_CTR_EXE_CreateP.sql
OJF_CTR_EXE_CreateCustG.sql
OJF_CTR_EXE_AcctCustG.sql
OJF_CTR_EXE_CustAccG.sql
OJF_CTR_EXE_CreateAccG.sql
OJF_CTR_EXE_AccCmtG.sql
OJF_CTR_EXE_AccCmtAdd.sql
OJF_CTR_EXE_AccAtcmntG.sql
OJF_CTR_EXE_AccAtcmntAdd.sql
OJF_CTR_PICmtAdd.sql
OJF_CTR_PICmtG.sql
OJF_CTR_PIAtcmntG.sql
OJF_CTR_PIAtcmntAdd.sql
OJF_CTR_Eml_Act.sql
OJF_CTR_EFL_RejActn.sql
OJF_CTR_EFL_Action.sql
OJF_CTR_EFL_AckRcvd.sql
OJF_CTR_DOEPEvidenceP.sql
OJF_CTR_DOEPEFL_RejActn.sql
OJF_CTR_DOEPEFL_Action.sql
OJF_CTR_DOEPEFL_AckRcvd.sql
OJF_CTR_DOEPCommentG.sql
OJF_CTR_DOEPComment_Add.sql
OJF_CTR_DOEPAttchmntG.sql
OJF_CTR_DOEPAtchmt_Add.sql
OJF_CTR_EFL_Actn.sql
OJF_CTR_DOEPEFL_Actn.sql
OJF_CTR_EFL_Actns.sql
OJF_CTR_DOEPEFL_Actns.sql
CTR_AAI_OJFF_MASKING_VIEW_MAPPING.sql
CTR_AAI_OJFF_MASKING_RULE_DETAILS.sql
CTR_AAI_OJFF_MASKING_ATTR_VAL_MAP.sql
CTR_AAI_OJFF_FUNCTION_MASKING_MAP.sql
CTR_AAI_OJFF_COMP_FUNC_CODE_MAP.sql
CTR_AAI_AOM_APP_COMP_ATTR_MAPPING_IR.sql
CTR_AAI_AOM_COMPONENT_INFO.sql
CTR_AAI_AOM_APP_INFO.sql
P_CTR_STP.sql
PKG_WORKFLOW.sql
PKG_WORKFLOW_BODY.sql
PKG_MITCTR.sql
PKG_MITCTR_BODY.sql
OJF_AlertListN.sql
OJF_Aml_Tab_Cu_Dt_Al.sql
OJF_Aml_Ad_Bot_Ml.sql
OJF_Aml_Ad_Ct1.sql
OJF_AM_Ad_MitTC.sql
OJF_AM_RelAlrt_HistP.sql
OJF_Aml_Lk_Ml_Bot.sql
OJF_Aml_Review_Act.sql
OJF_Aml_Lk_Eft_Det.sql
OJF_Aml_Lk_Mit_Det.sql
OJF_AM_Ad_OrdEvnt_FX1.sql
OJF_Aml_Ad_Ct.sql
OJF_Aml_Ad_Cu.sql
OJF_Aml_Ad_Svt.sql
OJF_AM_Ad_OrdEvnt.sql
812_Config.sql
8111_ATOMIC.sql
PKG_AMUIACTIONWORKFLOW.sql
PKG_AMUIACTIONWORKFLOW_BODY.sql
CR_8.1.2.8_36146973.miner.sql
CR_8.1.2.8_36495785.miner.sql

Menu-related Files:

OJFF_CONV_AAI_MENU_B.sql
OJFF_CONV_AAI_FF_FORMS_B.sql
OJFF_CONV_AAI_FF_FORMS_TL.sql
OJFF_CONV_AAI_FF_FORMS_CONTAINERS_B.sql
OJFF_CONV_AAI_FF_FORMS_CONTAINERS_TL.sql
OJFF_CONV_AAI_FF_FORM_CONTROLS_B.sql
OJFF_CONV_AAI_FF_FORM_CONTROLS_TL.sql
OJFF_CONV_AAI_FF_CONTROL_PROPERTIES.sql
OJFF_CONV_AAI_FF_CONTROL_PARAMS.sql
Horizontal_Menu_Remove_List.sql
34637484_CSSMS_GROUP_MAST.sql
34637484_CSSMS_GROUP_ROLE_MAP.sql
34637484_CSSMS_ROLE_FUNCTION_MAP.sql
34637484_CSSMS_ROLE_MAST.sql
34637484_CSSMS_USR_GROUP_DSN_SEG_MAP.sql
CSSMS_GROUP_MAST_PACK.sql
CSSMS_GROUP_ROLE_MAP_PACK.sql
CSSMS_ROLE_FUNCTION_MAP_PACK.sql
CSSMS_ROLE_MAST_PACK.sql
CSSMS_GRP_ROLE_MAP_UNAUTH_PACK.sql
34633835_ACCT_SNAPHSOT.sql
34633835_CUST_CUST_SNAPHSOT.sql
34633835_CUST_ID_DOC_SNAPHSOT.sql
34633835_CUST_IP_SNAPSHOT.sql
34827060_CUST_IP_SNAPSHOT.sql
34633835_CUST_SNAPSHOT.sql
34633835_FCT_TP_WLS_RESULTS_SNAPHSOT.sql
34633835_PARTY_ID_DOC_SNAPHSOT.sql
34633835_PARTY_PARTY_RLSHP_SNAPHSOT.sql
F_RA_TO_CASE_MNUL.sql
F_CUST_RA_HISTORY_MNUL.sql
34637484_ALTER_CUST_SNAPSHOT.sql
FCT_CUST_RA_HISTRY_INDX.sql
/Atomic_Schema/Functions/FN_POPULATE_PRCSNG_KYC.sql
/Config_Schema/DT/FN_POPULATE_PRCSNG_KYC.sql
AAI_DMT_DEFINITION_34637484
34637484_AAI_DMT_MAPPING_DETAILS.sql
34637484_AAI_DMT_DEF_SOURCE_ENTITY.sql
Remove_Backup_Tables_34913083.sql
F_PROCESS_RISK_DETAILS.sql
FCC_KYC_MODEL_SIMULATION_SEQ.sql
RTI_ASSMNT_RESULT_INDX.sql
KYC_APP_ID_SIMULATION_SEQ.sql
OVERLAYS.sql
34637484_ALTER_CUST_IP_SNAPSHOT.sql
KYC_Batch_Performance.sql
EXCEL_MAPPING_MASTER.sql
/OB/FCC_TPG_TABLE_JSON_MAPPING_CS_BULK.sql
/OB/FCC_TPG_TABLE_JSON_QUERY_CS_BULK.sql
/OB/FCC_TPG_TABLE_JSON_QUERY_PARAM_CS_BULK.sql
/OB/FCC_TPG_TABLE_JSON_MAPPING_EDQ_BULK.sql
/OB/FCC_TPG_TABLE_JSON_QUERY_EDQ_BULK.sql
/OB/FCC_TPG_TABLE_JSON_QUERY_PARAM_EDQ_BULK.sql
/OB/FCC_OB_SETUP_PARAMS_SERVICES_8128.sql
34913083_AAI_MENU_B.sql
34913083_AAI_MENU_TL.sql
34913083_AAI_MENU_TREE.sql
34913083_MENU_ITEMS.sql
34913083_AAI_FF_FORMS_B.sql
34913083_AAI_FF_FORMS_TL.sql
34913083_AAI_FF_FORMS_CONTAINERS_B.sql
34913083_AAI_FF_FORMS_CONTAINERS_TL.sql
34913083_AAI_FF_FORM_CONTROLS_B.sql
34913083_AAI_FF_FORM_CONTROLS_TL.sql
34913083_AAI_FF_CONTROL_PROPERTIES.sql
34913083_AAI_FF_CONTROL_PARAMS.sql

PMF Scripts:

OB/AAI_WF_ACTIVITY_B_34637484.sql
OB/AAI_WF_ACTIVITY_TL_34637484.sql
OB/AAI_WF_APPLICATION_API_B_34637484.sql
OB/AAI_WF_APPLICATION_API_TL_34637484.sql
OB/AAI_WF_TRANSITION_B.sql
OB/AAI_WF_TRANSITION_TL.sql

Simulation Parallel Batch Scripts

DM_Populate_Acct_Prscng_8126.sql
DM_Populate_Cust_Acct_Prscng_8126.sql
DM_Populate_Cust_Addr_Prscng_8126.sql
DM_Populate_Cust_Cntry_Prscng_8126.sql
DM_Populate_Cust_Id_Doc_Prscng_8126.sql
DM_Populate_Cust_Mkt_Served_Prscng_8126.sql
DM_Populate_Cust_Phon_Prscng_8126.sql
DM_Populate_Cust_Prod_Prscng_8126.sql
DM_Populate_Cust_Prscng_8126.sql
DM_Populate_Cust_to_Cust_Prscng_8126.sql
DM_Populate_Customer_Reasn_Prcsng_8126.sql
DM_t2t_FCT_CUST_RA_HISTRY_8126.sql
DM_t2t_FCT_CUST_RVWDTLS_8126.sql
DM_t2t_FCT_RA_RISK_RATING_HISTORY_8126.sql
DM_t2t_FCT_TP_WLS_REQUESTS_8126.sql
DM_t2t_FCT_TP_WLS_REQUESTS_PRCNG_8126.sql
DM_t2t_FCT_TP_WLS_RESULTS_8126.sql
DM_t2t_FCT_TP_WLS_RESULTS_PRCNG.sql
DM_t2t_PARTY_ADDRESS_PRCNG_BO_EXT_8126.sql
DM_t2t_PARTY_ADDRESS_PRCNG_BO_INT_8126.sql
DM_t2t_PARTY_ADDRESS_PRCNG_IP_8126.sql
DM_t2t_PARTY_DETAILS_PRCNG_BO_EXT_8126.sql
DM_t2t_PARTY_DETAILS_PRCNG_BO_INT_8126.sql
DM_t2t_PARTY_DETAILS_PRCNG_IP_8126.sql
DM_t2t_PARTY_ID_DOC_PRCNG_BO_EXT_8126.sql
DM_t2t_PARTY_ID_DOC_PRCNG_BO_INT_8126.sql
DM_t2t_PARTY_ID_DOC_PRCNG_IP_8126.sql
DM_t2t_PARTY_PARTY_RLSHP_PRCSNG_BO_8126.sql
DM_t2t_POPULATE_FCT_RA_8126.sql
DM_t2t_POPULATE_FCT_RA_RISK_DETAILS_8126.sql
DM_t2t_POPULATE_FCT_RA_RISK_REASONS_8126.sql
DM_t2t_POPULATE_FCT_RA_RISK_SUMMARY_8126.sql
PLC_F_CLOSURE_UPDATES_8126.sql
PLC_F_NEW_ACCT_RAS_8126.sql
PLC_LOAD_FCT_CUST_REVIEW_REASONS_8126.sql
PLC_POPULATE_CUST_PROCESSING_IP_8126.sql
PLC_POPULATE_IP_KYC_8126.sql
PLC_POPULATE_PRCSNG_KYC_8126.sql
PLC_TRUNCATE_PRCSNG_RUN_KYC_8126.sql
PLC_UPDATE_WLS_STATUS_8126.sql
PLC_BD_POPULATE_LAST_RUN_BATCH_8126.sql
PLC_F_TRUNC_RTI_ASSMNT_TABLES_8126.sql
PLC_KYC_PURGE_LAST_RUN_TAB_8126.sql
KYC_PURGE_LAST_RUN_TAB_DI_8126.sql
POPULATE_IP_KYC_DI_8126.sql
t2t_FCT_RA_RISK_DETAILS_DI_8126.sql
t2t_POPULATE_FCT_RA_RISK_REASONS_DI_8126.sql
t2t_POPULATE_FCT_RA_RISK_SUMMARY_DI_8126.sql
UPDATE_WLS_STATUS_DI_8126.sql
Update_DI_Tasks_8126.sql
PLC_PopulateCustForAccReReview.sql
PLC_UpdProcessedAccReReviewCust.sql
FN_POPULATE_IP_KYC_8126.sql
LOAD_FCT_CUST_REVIEW_REASONS_8126.sql
FN_POPULATE_PRCSNG_KYC_8126.sql
FN_TRUNCATE_PRCSNG_RUN_KYC_8126.sql
F_CLOSURE_UPDATES_8126.sql
F_NEW_ACCT_RAS_8126.sql
FN_POPULATE_CUST_PROCESSING_IP_8126.sql
FN_UPDATE_WLS_STATUS_8126.sql
F_EXTRACTPARAM.sql
FN_IPE_LAST_BATCH_RUN_8126.sql
FN_PURGE_IPE_LAST_BATCH_RUN_8126.sql
F_TRUNC_RTI_ASSMNT_TABLES_8126.sql
FN_POPULATE_IP_KYC_DI_8126.sql
FN_POPULATE_PRCSNG_KYC_DI_8126.sql
FN_PURGE_IPE_LAST_BATCH_RUN_DI_8126.sql
FN_UPDATE_WLS_STATUS_DI_8126.sql
FN_POPULATE_CUST_PROCESSING_IP_DI.sql
POPULATE_ASSMNT_MODE_TABLES.sql
PLC_GathrStats_PRCSNG_TABLES.sql
F_GATHER_STATS_DLY_BATCH.sql
FN_TRUNCATE_PRCSNG_RUN_KYC_8126.sql
FCC_KYC_WSPACE_META_OBJECTS.sql
PLC_FN_SIM_VERIFY_TABLES_8126.sql
FN_SIM_VERIFY_TABLES.sql
VW_KYC_SIM_AGGREGATE_REPORT.sql
VW_KYC_SIM_DETAILED_REPORT.sql
DROP_TABLE_SUBPARTITION_DLY_8126.sql
F_CHG_LOG_CAPTURE_8126.sql
F_IPE_CRT_PARTITION_DLY_8126.sql
KDD_CODE_SET_TRNLN_36425526.sql
35975902_Config.sql
APPLN_PARAMS_36347060.sql
F_INS_ACC_RVW_CUST.sql
F_UPDT_ACC_RVW_CUST.sql
F_ACC_RULE_VALUE_DISP.sql

Note:

Take a backup of the files mentioned above as a precautionary measure; any customizations performed to these files must be re-applied.