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.