Integrating with Third-Party Case Management Systems

The AMLToCMEventData batch supports integration with third-party case management systems by providing a means to extract evented data which can be loaded into an external system.

The following table provides the tasks that are configured for the AMLToCMEventData batch. These tasks must be executed in the following order:

Table 19-13 AMLToCMEventData Batch Details

Sequence Tasks for AMLToCMEventData Batch Jobs for AMLToCMEventData Batch Pipelines for AMLToCMEventData Batch
1 ECMSRTBTH Not Applicable Not Applicable
2 PL_SRT Not Applicable Not Applicable
3 SCRLOAD Load Scenario Data to Case Management Load Scenario Data to Case Management
4 EVNTPOP Load Event Data to Case Management Load Event Data to Case Management
5 EVCUSTLOAD Load Evented Customer Data to Case Management Load Evented Customer Data to Case Management
6 EVACCTLOAD Load Evented Account Data to Case Management Load Evented Account Data to Case Management
7 EVTRXNLOAD Load Evented Transaction Data to Case Management Load Evented Transaction Data to Case Management
8 EVEXTELOAD Load Evented External Entity and Derived Address Data to Case Management Load Evented External Entity and Derived Address Data to Case Management
9 DropTempTables DropTempTables Not Applicable
10 ECMECND Not Applicable Not Applicable

Note:

You can find pre-configured sample data pipelines, Evented Customer Details (data extraction from a single table) and Evented Customer Details - Two Tables Join (data extraction from mutliple tables), which provide examples of the pipeline to extract data.

Run the TMCS_CSV_Export batch to generate the .csv file of the extracted data.

For information about how to download the extracted data in .csv format, see Using Object PAR in the Oracle FCCM Cloud Service Using Rest API guide.