Files Packaged in This Patch

A Files Packaged in This Patch

This chapter describes the files modified and files impacting database objects due to this Patch in the Compliance Studio. It also provides additional information that supports the installation activity.

Note:

<PATCH_HOME> indicates the path where patch contents are extracted.

List of Database Objects Modified

Kindly take backup of these existing objects for future rollback.

New Database Objects Added

Functions: FN_Upload_Bulk_Threshold, FN_IS_VALID_VALUE

Tables: SM_EVENT_SCORE_DETAILS_NON_ALERTED, BULK_TSHLD_UPLOAD

Procedures: P_AIF_CUSTOM_MERGE_SCRIPT, p_aif_gather_stats

Existing Schema Objects Modified (Workspace Schema)

Packages

PKG_ASC
PKG_SCENARIO_MODEL
PKG_FCC_BD_NB
PKG_SCU_SUPPLIMENT_INFO,
PKG_AIF_UTILITY, PKG_SES
PKG_AIF
PKG_AIF_UNSUP

Tables

ASC_DEFINITION_MASTER
ASC_SCENARIO_EXECUTION_STATUS
ML4AML_SM_BASE_FEATURES
ML4AML_SM_RED_FLG_FEAT
ML4AML_SM_SCNRO_FEAT_MAP
AIF_ENTITY_GROUP
FCC_AM_EVENTS
FCC_AM_EVENT_BINDING
FCC_AM_EVENT_DETAILS
FCC_AM_EVENT_ENTITY_MAP
ML4AML_SES_EVENT_INPUT
AIF_QUERY_PROPERTY_GTT

Synonyms

DS_NOTEBOOK
DS_PARAGRAPH
SEQ_PARAGRAPH

Sequences

FCC_TEMP_TABLE_SEQ
FCC_SEQUENCES_RUN_ID
FCC_SEQUENCES_EVENT_CD
SEQ_EXEC_RUN_SKEY

View

VW_REVIEW
VW_REVIEW_SCNRO

Materialized View

VW_SCNRO_BIND_MD
VW_SCNRO_CHKPT_BIND_MD
VW_SCNRO_CHKPT_MD
VW_SCNRO_CONSTRAINT_MD
VW_SCNRO_DATASET_JOB_MD
VW_SCNRO_HIGHLIGHT_MD

Functions

FUNC_RETURN_PRCSNG_BATCH
FUNC_RETURN_CAL

INDEX

AIF_ENTITY_GROUP_UNIQUE_IDX

Database Objects Deleted

List of Files Which are Included in This Patch

##PATCH_HOME##/bin/applyPatch.sh
##PATCH_HOME##/bin/config.sh
##PATCH_HOME##/minicondaFiles/OFS_COMPLIANCE_STUDIO_8.1.2.9.0_LINUX_2of2.zip
##PATCH_HOME##/readme.txt
##PATCH_HOME##/scripts/helper.sh
##PATCH_HOME##/scripts/replaceFiles.sh
##PATCH_HOME##/scripts/replacePGX.sh
##PATCH_HOME##/scripts/replaceMl4aml.sh
##PATCH_HOME##/scripts/replaceSanctions.sh
##PATCH_HOME##/ml4aml/bin/*
##PATCH_HOME##/ml4aml/lib/*
##PATCH_HOME##/ml4aml/model/*
##PATCH_HOME##/ml4aml/notebooks/*
##PATCH_HOME##/ml4aml/python/*
##PATCH_HOME##/ficdb/scenario-conversion-utility/bin/*
##PATCH_HOME##/ficdb/scenario-conversion-utility/DynamicDatasets/dataset9999999.txt
##PATCH_HOME##/ficdb/scenario-conversion-utility/model/*
##PATCH_HOME##/ficdb/scenario-conversion-utility/notebooks/*
##PATCH_HOME##/pipfiles/*
##PATCH_HOME##/files/bin/replace.sh
##PATCH_HOME##/files/bin/install.sh
##PATCH_HOME##/files/bin/compliance-studio.sh
##PATCH_HOME##/files/bin/additional_config.sh
##PATCH_HOME##/files/batchservice/bin/batchservice
##PATCH_HOME##/files/batchservice/bin/batchservice.bat
##PATCH_HOME##/files/batchservice/lib/*
##PATCH_HOME##/files/metaservice/bin/metaservice
##PATCH_HOME##/files/metaservice/bin/metaservice.bat
##PATCH_HOME##/files/metaservice/lib/*
##PATCH_HOME##/files/metaservice/conf/server-config.properties
##PATCH_HOME##/files/candidate-selection/bin/candidate-selection
##PATCH_HOME##/files/candidate-selection/bin/candidate-selection.bat
##PATCH_HOME##/files/candidate-selection/bin/starter.sh
##PATCH_HOME##/files/candidate-selection/bin/stop.sh
##PATCH_HOME##/files/candidate-selection/lib/candidate-selection-service-8.1.2.9.0-1.jar
##PATCH_HOME##/files/candidate-selection/conf/log4j2.xml
##PATCH_HOME##/files/candidate-selection/utility/lib/*
##PATCH_HOME##/files/entity-resolution/bin/config.sh
##PATCH_HOME##/files/entity-resolution/bin/entity-resolution
##PATCH_HOME##/files/entity-resolution/bin/entity-resolution.bat
##PATCH_HOME##/files/entity-resolution/bin/install.sh
##PATCH_HOME##/files/entity-resolution/bin/starter.sh
##PATCH_HOME##/files/entity-resolution/bin/stop.sh
##PATCH_HOME##/files/entity-resolution/lib/*
##PATCH_HOME##/files/entity-resolution/datamodels/FSDF_8.1.2.9.0/ER_81290.ODM
##PATCH_HOME##/files/fcc-ui/bin/config.sh
##PATCH_HOME##/files/fcc-ui/bin/fcc-ui
##PATCH_HOME##/files/fcc-ui/bin/fcc-ui.bat
##PATCH_HOME##/files/fcc-ui/bin/install.sh
##PATCH_HOME##/files/fcc-ui/bin/starter.sh
##PATCH_HOME##/files/fcc-ui/bin/stop.sh
##PATCH_HOME##/files/fcc-ui/lib/*
##PATCH_HOME##/files/fcc-ui/conf/log4j2.xml
##PATCH_HOME##/files/ficdb/lib/*
##PATCH_HOME##/files/ficdb/seprateSchemaJars/lib/*
##PATCH_HOME##/files/ficdb/Utilities/LiquibaseCleanup/metaservice_databasechangelog_cleanup.sql
##PATCH_HOME##/files/ficdb/GraphPipeline-Cleanup-Scripts
##PATCH_HOME##/files/ficdb/graph-metadata/SQLScripts/*
##PATCH_HOME##/files/ficdb/graph-metadata/bin/InitializeBDSchema.sh
##PATCH_HOME##/files/ficdb/graph-metadata/bin/InitializeECMSchema.sh
##PATCH_HOME##/files/ficdb/graph-metadata/bin/InitializeGraphSchema.sh
##PATCH_HOME##/files/ficdb/graph-metadata/bin/InitializeOOBGraphBatchScheduleBD.sh
##PATCH_HOME##/files/ficdb/graph-metadata/bin/InitializeOOBGraphBatchScheduleECM.sh
##PATCH_HOME##/files/ficdb/graph-metadata/model/ecm-atomic.xml
##PATCH_HOME##/files/ficdb/graph-metadata/model/ecm-atomic-8.1.2.9.0.xml
##PATCH_HOME##/files/ficdb/graph-metadata/model/graph.xml
##PATCH_HOME##/files/ficdb/graph-metadata/model/graph-8.1.2.9.0.xml
##PATCH_HOME##/files/ficdb/graph-metadata/model/schedule-ecm.xml
##PATCH_HOME##/files/ficdb/graph-metadata/model/schedule-ecm-8.1.2.9.0.xml
##PATCH_HOME##/files/load-to-es/bin/load-to-open-search
##PATCH_HOME##/files/load-to-es/bin/load-to-open-search.bat
##PATCH_HOME##/files/load-to-es/lib/*
##PATCH_HOME##/files/load-to-open-search/bin/load-to-open-search
##PATCH_HOME##/files/load-to-open-search/bin/load-to-open-search.bat
##PATCH_HOME##/files/load-to-open-search/lib/*
##PATCH_HOME##/files/matching-service/bin/matching-service
##PATCH_HOME##/files/matching-service/bin/matching-service.bat
##PATCH_HOME##/files/matching-service/lib/*
##PATCH_HOME##/files/matching-service-es/bin/matching-service
##PATCH_HOME##/files/matching-service-es/bin/matching-service.bat
##PATCH_HOME##/files/matching-service-es/lib/*
##PATCH_HOME##/files/matching-service-ot/bin/matching-service
##PATCH_HOME##/files/matching-service-ot/bin/matching-service.bat
##PATCH_HOME##/files/matching-service-ot/lib/*
##PATCH_HOME##/files/opensearch/analysis-icu-2.18.0.zip
##PATCH_HOME##/files/opensearch/analysis-phonetic-2.18.0.zip
##PATCH_HOME##/files/opensearch/opensearch-2.18.0.tar.gz
##PATCH_HOME##/files/SQLScripts/ER_DROP_MVIEW_OT.sql
##PATCH_HOME##/files/mmg-home/bin/config.sh
##PATCH_HOME##/files/mmg-home/bin/install.sh
##PATCH_HOME##/files/mmg-home/bin/shutdown.sh
##PATCH_HOME##/files/mmg-home/bin/startup.sh
##PATCH_HOME##/files/mmg-home/bin/initialize-install.sh
##PATCH_HOME##/files/mmg-home/bin/pre-install-check.sh
##PATCH_HOME##/files/mmg-home/bin/install-helper/lib/mmg-configuration-manager-1.0.0.jar
##PATCH_HOME##/files/mmg-home/bin/install-helper/template/*
##PATCH_HOME##/files/mmg-home/mmg-ui/lib/mmg-ui.war
##PATCH_HOME##/files/mmg-home/mmg-ui/bin/install.sh
##PATCH_HOME##/files/mmg-home/mmg-ui/bin/config.sh
##PATCH_HOME##/files/mmg-home/mmg-ui/conf/application.properties.sh
##PATCH_HOME##/files/mmg-home/mmg-service/lib/mmg-service.war
##PATCH_HOME##/files/mmg-home/mmg-service/bin/install.sh
##PATCH_HOME##/files/mmg-home/mmg-service/bin/config.sh
##PATCH_HOME##/files/mmg-home/mmg-service/bin/startup.sh
##PATCH_HOME##/files/mmg-home/mmg-service/conf/application.properties
##PATCH_HOME##/files/mmg-home/mmg-service/python-lib/ds_interpreter_client-*.whl
##PATCH_HOME##/files/mmg-home/mmg-service/python-lib/mmg-8.1.2.7.0.tar.gz
##PATCH_HOME##/files/mmg-home/mmg-service/python-lib/oracle-pypgx-client-23.4.9.zip
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/bin/config.sh
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/bin/graph-service
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/bin/graph-service.bat
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/bin/install.sh
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/bin/start-script.sh
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/bin/stop-script.sh
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/model/datamodel/GraphService.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/model/datamodel/GraphService_81280_4.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/model/datamodel/GraphService_81290.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/model/datamodel/GraphService_81290_1.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/model/datamodel/GraphService_81290_2.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/model/datamodel/GraphService_81290_3.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/Audit_Schema_8128.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/Audit_Schema_8128-1.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/ExtSrvc_Schema_8128.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/IH_Archival_8129-2.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/IH_Data_Schema_8128.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/IH_Data_Schema_8128-1.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/IH_Data_Schema_8128-2.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/IH_Data_Schema_8128-3.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/IH_Data_Schema_8129-2.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/IH_Data_Schema_8129-3.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/Process_Log_8129.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/Runtime_Audit_schema.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/Runtime_Graph_schema.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/Runtime_IH_Archival.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/model/Runtime_IH_Data_Schema.xml
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/conf/runtimeLiquibase/SQLScripts/*
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/lib/graph-service-8.1.2.9.0-6.jar
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/lib/mmg-schema-creator.war
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/bin/install.sh
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/bin/config.sh
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/scripts/changelog-master.xml
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/scripts/811/*
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/scripts/8125/*
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/scripts/8127/*
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/scripts/81211/*
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/scripts/81271/*
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/scripts/81272/*
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/scripts/81273/*
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/scripts/8125/APP/SANCTIONS/AAI_NB_COMPONENT_REGISTRATION.sql
##PATCH_HOME##/files/mmg-home/mmg-gateway/lib/mmg-gateway.war
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/data-pipeline-service-10.0.1.1.0/lib/data-pipeline-service-10.0.1.1.0.war
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/data-pipeline-service-UI-10.0.1.1.0/lib/data-pipeline-service-ui-10.0.1.1.0.war
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/data-pipeline-service-UI-10.0.1.1.0/conf/*
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/pipeline-service-10.0.1.1.0/lib/pipeline-service-10.0.1.1.0.war
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/pipeline-service-10.0.1.1.0/pipelines/data-pipelines/*
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/pipeline-service-UI-10.0.1.1.0/lib/pipeline-service-ui-10.0.1.1.0.war
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/pipeline-service-UI-10.0.1.1.0/conf/*
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/data-metadata-job-10.0.1.1.0/lib/data-metadata-job-10.0.1.1.0.jar
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/pipelinegateway/lib/pipeline-gateway-*.jar
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/installation/set_parameter.sh
##PATCH_HOME##/files/mmg-home/mmg-pipeline/pipeline/pipelineDataModel/liquibase/lib/*
##PATCH_HOME##/files/mmg-home/mmg-studio/lib/*
##PATCH_HOME##/files/mmg-home/mmg-studio/bin/*
##PATCH_HOME##/files/mmg-home/mmg-studio/conf/*
##PATCH_HOME##/files/workspace/mmg/seeded/workspace-templates/CSWorkspaceTemplate.zip
##PATCH_HOME##/files/workspace/mmg/seeded/models/CSNOPRODSIMULATION_1701856523642_0.zip
##PATCH_HOME##/files/workspace/mmg/seeded/models/CSSIMULATION_1697220226831_0.zip
##PATCH_HOME##/files/workspace/mmg/seeded/data-population-templates/CSNoProdDataTemplate.zip
##PATCH_HOME##/files/workspace/mmg/seeded/data-population-templates/CSJurisdictionFilterTemplate.zip
##PATCH_HOME##/files/batchservice/conf/server-config.properties
##PATCH_HOME##/files/matching-service/conf/application.properties
##PATCH_HOME##/files/matching-service-es/conf/application.properties
##PATCH_HOME##/files/matching-service-ot/conf/application.properties
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/utility/bin/InitializeIhArchival.sh
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/utility/bin/SetConnectionPoolConfigForDatasource.sh
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/utility/bin/SyncCaseMergeRules.sh
##PATCH_HOME##/files/mmg-home/mmg-load-to-graph/graph-service/utility/fonts/*
##PATCH_HOME##/files/mmg-home/mmg-schema-creator/scripts/81274/*

List of Files to Edit

##PATCH_HOME##/bin/config.sh