5.8 Merging Case Types

Alerts are correlated into cases based on the watch list record type when you run the Customer Screening batch. The record types Sanctions (SAN), Country Prohibitions (PRB), Politically Exposed Persons (PEP), and Enhanced Due Diligence (EDD) are merged under a single case ID based on the configuration.

To merge ECM case types follow the below steps:

1. Create new case type under case the class CS in ECM from Case Designer. For example consider the case type CS_RT. Map the entities and workflow from the user interface while creating the case type. See the Managing Case Designer section in Oracle Financial Services Enterprise Case Management Admin Guide.
2. Update the entries 12, 13, 14, and 15 in the FCC_CORRELATION_CASE_TYPE_MAP table with new case type CS_RT created in step 1.

   Figure 5-7 FCC_CORRELATION_CASE_TYPE_MAP table

   
   

   

   
   

   update FCC_CORRELATION_CASE_TYPE_MAP set v_case_type = 'CS_RT' where N_CORRELATION_RULE_SKEY in (12,13,14,15);

3. Add a new entry in the FCC_RT_EVENTTYPE_PTC table for the newly created case type CS_RT.

   Figure 5-8 FCC_RT_EVENTTYPE_PTC table

   
   

   

   
   

   insert into FCC_RT_EVENTTYPE_PTC select 'CS_RT', '5','CS_RT_KDD_CASE_RT_EXT_ID' from FCC_RT_EVENTTYPE_PTC where V_CASE_TYPE = 'CS_RT_SAN';

4. Update the entries 12, 13, 14, and 15 in FCC_CORRELATION_RULE table to reflect the new title for the case type CS_RT.

   Figure 5-9 FCC_CORRELATION_RULE table

   
   

   

   
   

   update FCC_CORRELATION_RULE set V_RULE_NAME = 'RealTime Screening' where N_CORRELATION_RULE_SKEY in (12,13,14,15);

5. In the Case Summary page, insert the status ID entries in the FCC_CASETYPE_EVENT_STATUS_MAP table for the new case type CS_RT to get the event decisions in the Set Event Decision window.

   Figure 5-10 FCC_CASETYPE_EVENT_STATUS_MAP table

   
   

   

   
   

   insert into FCC_CASETYPE_EVENT_STATUS_MAP select 'CS_RT', n_status_id from FCC_CASETYPE_EVENT_STATUS_MAP where V_CASE_TYPE_SUBTYPE_CD = 'CS_RT_SAN';

6. To get the details in Take Action Pop-up window, insert the below entries in the KDD_CASETYPE_ACTION_MAP-SEQ table for the new case type CS_RT.

   Figure 5-11 KDD_CASETYPE_ACTION_MAP-SEQ table

   
   

   

   
   

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA6','CS_RT');

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA921','CS_RT');

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA922','CS_RT');

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA934','CS_RT');

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA935','CS_RT');

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA936','CS_RT');

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA937','CS_RT');

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA938','CS_RT');

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA939','CS_RT');

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA961','CS_RT');

   Insert into KDD_CASETYPE_ACTION_MAP (CASE_CASETYPE_ACTION_MAP_SEQ,ACTION_CD,CASE_TYPE_SUBTYPE_CD) values ((select max(CASE_CASETYPE_ACTION_MAP_SEQ) from kdd_casetype_action_map)+1,'CA8','CS_RT');

7. To get the values in standard comments drop down, insert below entries in KDD_CASE_TYPE_CMMNT table for the new case type CS_RT.

   Figure 5-12 KDD_CASE_TYPE_CMMNT table

   
   

   

   
   

   insert into kdd_case_type_cmmnt select 'CS_RT', CMMNT_ID from kdd_case_type_cmmnt where CASE_TYPE_CD = 'CS_RT_SAN';

8. Map the OWNER_SEQ_ID table entry with the new case type CS_RT created in the KDD_REVIEW_OWNER_CASE_TYPE table and restart the server.

   Figure 5-13 OWNER_SEQ_ID table

   
   

   

   
   

   INSERT INTO KDD_REVIEW_OWNER_CASE_TYPE (OWNER_SEQ_ID, CASE_TYPE_CD) VALUES ($OWNER_SEQ_ID$, 'CS_RT')