APPENDIX-D: Switching between EDQ and CS

D APPENDIX-D: Switching between EDQ and CS

This chapter shows the scripts that are to be executed to switch between EDQ (Enterprise Data Quality) and CS (Customer Screening).

Execute the following script to switch to EDQ.

MERGE INTO AAI_WF_TRANSITION_B T USING (
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085276' V_TRANSITION_ID,
'Job_1533292500818' V_FROM_ACTIVITY_ID, 'Job_1665486756737'
V_TO_ACTIVITY_ID, '0' V_CONDITION_EXPR, '1' V_CONDITION_TYPE, '1'
V_PRECEDENCE, 'C' V_TRANSITION_TYPE, ' ' V_TRANSITION_STROKE FROM DUAL)
S
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID =
S.V_TRANSITION_ID )
WHEN MATCHED THEN UPDATE SET T.V_FROM_ACTIVITY_ID =
S.V_FROM_ACTIVITY_ID, T.V_TO_ACTIVITY_ID = S.V_TO_ACTIVITY_ID,
T.V_CONDITION_EXPR = S.V_CONDITION_EXPR, T.V_CONDITION_TYPE =
S.V_CONDITION_TYPE, T.V_PRECEDENCE = S.V_PRECEDENCE, T.V_TRANSITION_TYPE
= S.V_TRANSITION_TYPE, T.V_TRANSITION_STROKE = S.V_TRANSITION_STROKE
WHEN NOT MATCHED THEN INSERT
(V_PROCESS_ID,V_TRANSITION_ID,V_FROM_ACTIVITY_ID,V_TO_ACTIVITY_ID,V_CON
DITION_EXPR,V_CONDITION_TYPE,V_PRECEDENCE,V_TRANSITION_TYPE,V_TRANSITION_STROKE)
VALUES
(S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_FROM_ACTIVITY_ID,S.V_TO_ACTIVITY_
ID,S.V_CONDITION_EXPR,S.V_CONDITION_TYPE,S.V_PRECEDENCE,S.V_TRANSITION_T
YPE,S.V_TRANSITION_STROKE)
/
MERGE INTO AAI_WF_TRANSITION_B T USING (
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085277' V_TRANSITION_ID,
'Job_1665486756737' V_FROM_ACTIVITY_ID, 'Job_1601833121763' V_TO_ACTIVITY_ID, '0' V_CONDITION_EXPR, '1' V_CONDITION_TYPE, '1'
V_PRECEDENCE, 'C' V_TRANSITION_TYPE, ' ' V_TRANSITION_STROKE FROM DUAL)S
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID =S.V_TRANSITION_ID )
WHEN MATCHED THEN UPDATE SET T.V_FROM_ACTIVITY_ID =S.V_FROM_ACTIVITY_ID, T.V_TO_ACTIVITY_ID = S.V_TO_ACTIVITY_ID,
T.V_CONDITION_EXPR = S.V_CONDITION_EXPR, T.V_CONDITION_TYPE =S.V_CONDITION_TYPE, T.V_PRECEDENCE = S.V_PRECEDENCE, T.V_TRANSITION_TYPE
= S.V_TRANSITION_TYPE, T.V_TRANSITION_STROKE = S.V_TRANSITION_STROKE
WHEN NOT MATCHED THEN INSERT
(V_PROCESS_ID,V_TRANSITION_ID,V_FROM_ACTIVITY_ID,V_TO_ACTIVITY_ID,V_CONDITION_EXPR,V_CONDITION_TYPE,V_PRECEDENCE,V_TRANSITION_TYPE,V_TRANSITION_STROKE)VALUES
(S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_FROM_ACTIVITY_ID,S.V_TO_ACTIVITY_ID,S.V_CONDITION_EXPR,S.V_CONDITION_TYPE,S.V_PRECEDENCE,S.V_TRANSITION_TYPE,S.V_TRANSITION_STROKE)
/
MERGE INTO AAI_WF_TRANSITION_TL T USING (
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085276' V_TRANSITION_ID,
'Job_1533292500818_Job_1665486756737' V_TRANSITION_NAME, ''V_TRANSITION_DESC, 'en_US' V_LOCALE_CODE FROM DUAL) S
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID =S.V_TRANSITION_ID AND T.V_LOCALE_CODE = S.V_LOCALE_CODE )
WHEN MATCHED THEN UPDATE SET T.V_TRANSITION_NAME = S.V_TRANSITION_NAME,T.V_TRANSITION_DESC = S.V_TRANSITION_DESC
WHEN NOT MATCHED THEN INSERT
(V_PROCESS_ID,V_TRANSITION_ID,V_TRANSITION_NAME,V_TRANSITION_DESC,V_LOCALE_CODE)VALUES
(S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_TRANSITION_NAME,S.V_TRANSITION_DESC,S.V_LOCALE_CODE)
/
MERGE INTO AAI_WF_TRANSITION_TL T USING (
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085277' V_TRANSITION_ID,
Job_1665486756737_Job_1601833121763' V_TRANSITION_NAME, ''V_TRANSITION_DESC, 'en_US' V_LOCALE_CODE FROM DUAL) S
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID =S.V_TRANSITION_ID AND T.V_LOCALE_CODE = S.V_LOCALE_CODE )
WHEN MATCHED THEN UPDATE SET T.V_TRANSITION_NAME = S.V_TRANSITION_NAME,T.V_TRANSITION_DESC = S.V_TRANSITION_DESC
WHEN NOT MATCHED THEN INSERT
(V_PROCESS_ID,V_TRANSITION_ID,V_TRANSITION_NAME,V_TRANSITION_DESC,V_LOCALE_CODE)VALUES
(S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_TRANSITION_NAME,S.V_TRANSITION_DESC,S.V_LOCALE_CODE)
/

Execute the following script to switch to CS.

MERGE INTO AAI_WF_TRANSITION_B T USING (
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085276' V_TRANSITION_ID,
'Job_1533292500818' V_FROM_ACTIVITY_ID, 'Job_1665486756736' V_TO_ACTIVITY_ID, '0' V_CONDITION_EXPR, '1' V_CONDITION_TYPE, '1'
V_PRECEDENCE, 'C' V_TRANSITION_TYPE, ' ' V_TRANSITION_STROKE FROM DUAL)S
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID =S.V_TRANSITION_ID )
WHEN MATCHED THEN UPDATE SET T.V_FROM_ACTIVITY_ID =
S.V_FROM_ACTIVITY_ID, T.V_TO_ACTIVITY_ID = S.V_TO_ACTIVITY_ID,
T.V_CONDITION_EXPR = S.V_CONDITION_EXPR, T.V_CONDITION_TYPE =S.V_CONDITION_TYPE, T.V_PRECEDENCE = S.V_PRECEDENCE, T.V_TRANSITION_TYPE
= S.V_TRANSITION_TYPE, T.V_TRANSITION_STROKE = S.V_TRANSITION_STROKE
WHEN NOT MATCHED THEN INSERT
(V_PROCESS_ID,V_TRANSITION_ID,V_FROM_ACTIVITY_ID,V_TO_ACTIVITY_ID,V_CONDITION_EXPR,V_CONDITION_TYPE,V_PRECEDENCE,V_TRANSITION_TYPE,V_TRANSITION_STROKE)VALUES
(S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_FROM_ACTIVITY_ID,S.V_TO_ACTIVITY_ID,S.V_CONDITION_EXPR,S.V_CONDITION_TYPE,S.V_PRECEDENCE,S.V_TRANSITION_TYPE,S.V_TRANSITION_STROKE)
/
MERGE INTO AAI_WF_TRANSITION_B T USING (
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085277' V_TRANSITION_ID,
'Job_1665486756736' V_FROM_ACTIVITY_ID, 'Job_1601833121763' V_TO_ACTIVITY_ID, '0' V_CONDITION_EXPR, '1' V_CONDITION_TYPE, '1'
V_PRECEDENCE, 'C' V_TRANSITION_TYPE, ' ' V_TRANSITION_STROKE FROM DUAL)S ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID =S.V_TRANSITION_ID )
WHEN MATCHED THEN UPDATE SET T.V_FROM_ACTIVITY_ID =
S.V_FROM_ACTIVITY_ID, T.V_TO_ACTIVITY_ID = S.V_TO_ACTIVITY_ID,
T.V_CONDITION_EXPR = S.V_CONDITION_EXPR, T.V_CONDITION_TYPE = S.V_CONDITION_TYPE, T.V_PRECEDENCE = S.V_PRECEDENCE, T.V_TRANSITION_TYPE
= S.V_TRANSITION_TYPE, T.V_TRANSITION_STROKE = S.V_TRANSITION_STROKE
WHEN NOT MATCHED THEN INSERT
(V_PROCESS_ID,V_TRANSITION_ID,V_FROM_ACTIVITY_ID,V_TO_ACTIVITY_ID,V_CONDITION_EXPR,V_CONDITION_TYPE,V_PRECEDENCE,V_TRANSITION_TYPE,V_TRANSITION_STROKE)VALUES
(S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_FROM_ACTIVITY_ID,S.V_TO_ACTIVITY_ID,S.V_CONDITION_EXPR,S.V_CONDITION_TYPE,S.V_PRECEDENCE,S.V_TRANSITION_TYPE,S.V_TRANSITION_STROKE)
/
MERGE INTO AAI_WF_TRANSITION_TL T USING (
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085276' V_TRANSITION_ID,
'Job_1533292500818_Job_1665486756736' V_TRANSITION_NAME, ''V_TRANSITION_DESC, 'en_US' V_LOCALE_CODE FROM DUAL) S
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID = S.V_TRANSITION_ID AND T.V_LOCALE_CODE = S.V_LOCALE_CODE )
WHEN MATCHED THEN UPDATE SET T.V_TRANSITION_NAME = S.V_TRANSITION_NAME,T.V_TRANSITION_DESC = S.V_TRANSITION_DESC
WHEN NOT MATCHED THEN INSERT
(V_PROCESS_ID,V_TRANSITION_ID,V_TRANSITION_NAME,V_TRANSITION_DESC,V_LOCALE_CODE)VALUES
(S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_TRANSITION_NAME,S.V_TRANSITION_DESC,S.V_LOCALE_CODE)
/
MERGE INTO AAI_WF_TRANSITION_TL T USING
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085277' V_TRANSITION_ID,
'Job_1665486756736_Job_1601833121763' V_TRANSITION_NAME, ''
V_TRANSITION_DESC, 'en_US' V_LOCALE_CODE FROM DUAL) S
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID = S.V_TRANSITION_ID AND T.V_LOCALE_CODE = S.V_LOCALE_CODE )
WHEN MATCHED THEN UPDATE SET T.V_TRANSITION_NAME = S.V_TRANSITION_NAME,T.V_TRANSITION_DESC = S.V_TRANSITION_DESC
WHEN NOT MATCHED THEN INSERT
(V_PROCESS_ID,V_TRANSITION_ID,V_TRANSITION_NAME,V_TRANSITION_DESC,V_LOCALE_CODE)
VALUES
(S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_TRANSITION_NAME,S.V_TRANSITION_DESC,S.V_LOCALE_CODE)
/
MERGE INTO AAI_WF_TRANSITION_B T USING(
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085276' V_TRANSITION_ID, 'Job_1533292500818' V_FROM_ACTIVITY_ID, 'Job_1665486756736' V_TO_ACTIVITY_ID, '0' V_CONDITION_EXPR, '1' V_CONDITION_TYPE, '1'
V_PRECEDENCE, 'C' V_TRANSITION_TYPE, ' ' V_TRANSITION_STROKE FROM DUAL) S
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID = S.V_TRANSITION_ID )
WHEN MATCHED THEN UPDATE SET T.V_FROM_ACTIVITY_ID = S.V_FROM_ACTIVITY_ID, T.V_TO_ACTIVITY_ID = S.V_TO_ACTIVITY_ID, T.V_CONDITION_EXPR = S.V_CONDITION_EXPR, T.V_CONDITION_TYPE = S.V_CONDITION_TYPE, T.V_PRECEDENCE = S.V_PRECEDENCE, T.V_TRANSITION_TYPE
= S.V_TRANSITION_TYPE, T.V_TRANSITION_STROKE = S.V_TRANSITION_STROKE WHEN NOT MATCHED THEN INSERT
 (V_PROCESS_ID,V_TRANSITION_ID,V_FROM_ACTIVITY_ID,V_TO_ACTIVITY_ID,V_CON DITION_EXPR,V_CONDITION_TYPE,V_PRECEDENCE,V_TRANSITION_TYPE,V_TRANSITION_STROKE) VALUES
 (S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_FROM_ACTIVITY_ID,S.V_TO_ACTIVITY_ ID,S.V_CONDITION_EXPR,S.V_CONDITION_TYPE,S.V_PRECEDENCE,S.V_TRANSITION_T YPE,S.V_TRANSITION_STROKE)
/
MERGE INTO AAI_WF_TRANSITION_B T USING(
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085277' V_TRANSITION_ID, 'Job_1665486756736' V_FROM_ACTIVITY_ID, 'Job_1601833121763' V_TO_ACTIVITY_ID, '0' V_CONDITION_EXPR, '1' V_CONDITION_TYPE, '1' V_PRECEDENCE, 'C' V_TRANSITION_TYPE, ' ' V_TRANSITION_STROKE FROM DUAL) S
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID = S.V_TRANSITION_ID )
WHEN MATCHED THEN UPDATE SET T.V_FROM_ACTIVITY_ID = S.V_FROM_ACTIVITY_ID, T.V_TO_ACTIVITY_ID = S.V_TO_ACTIVITY_ID, T.V_CONDITION_EXPR = S.V_CONDITION_EXPR, T.V_CONDITION_TYPE = S.V_CONDITION_TYPE, T.V_PRECEDENCE = S.V_PRECEDENCE, T.V_TRANSITION_TYPE
= S.V_TRANSITION_TYPE, T.V_TRANSITION_STROKE = S.V_TRANSITION_STROKE WHEN NOT MATCHED THEN INSERT
 (V_PROCESS_ID,V_TRANSITION_ID,V_FROM_ACTIVITY_ID,V_TO_ACTIVITY_ID,V_CON DITION_EXPR,V_CONDITION_TYPE,V_PRECEDENCE,V_TRANSITION_TYPE,V_TRANSITION_STROKE) VALUES
 (S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_FROM_ACTIVITY_ID,S.V_TO_ACTIVITY_ ID,S.V_CONDITION_EXPR,S.V_CONDITION_TYPE,S.V_PRECEDENCE,S.V_TRANSITION_T YPE,S.V_TRANSITION_STROKE)
/
MERGE INTO AAI_WF_TRANSITION_TL T USING(
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085276' V_TRANSITION_ID, 'Job_1533292500818_Job_1665486756736' V_TRANSITION_NAME, '' V_TRANSITION_DESC, 'en_US' V_LOCALE_CODE FROM DUAL) 
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID = S.V_TRANSITION_ID AND T.V_LOCALE_CODE = S.V_LOCALE_CODE )
WHEN MATCHED THEN UPDATE SET T.V_TRANSITION_NAME = S.V_TRANSITION_NAME, T.V_TRANSITION_DESC = S.V_TRANSITION_DESC
WHEN NOT MATCHED THEN INSERT
 (V_PROCESS_ID,V_TRANSITION_ID,V_TRANSITION_NAME,V_TRANSITION_DESC,V_LOCALE_CODE) VALUES
 (S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_TRANSITION_NAME,S.V_TRANSITION_DE SC,S.V_LOCALE_CODE)
/
MERGE INTO AAI_WF_TRANSITION_TL T USING (
SELECT 'KYC_ONBOARDING' V_PROCESS_ID, '1665487085277' V_TRANSITION_ID, 'Job_1665486756736_Job_1601833121763' V_TRANSITION_NAME, '' V_TRANSITION_DESC, 'en_US' V_LOCALE_CODE FROM DUAL) S
ON ( T.V_PROCESS_ID = S.V_PROCESS_ID AND T.V_TRANSITION_ID = S.V_TRANSITION_ID AND T.V_LOCALE_CODE = S.V_LOCALE_CODE )
WHEN MATCHED THEN UPDATE SET T.V_TRANSITION_NAME = S.V_TRANSITION_NAME, T.V_TRANSITION_DESC = S.V_TRANSITION_DESC
WHEN NOT MATCHED THEN INSERT
 (V_PROCESS_ID,V_TRANSITION_ID,V_TRANSITION_NAME,V_TRANSITION_DESC,V_LOCALE_CODE)VALUES
 (S.V_PROCESS_ID,S.V_TRANSITION_ID,S.V_TRANSITION_NAME,S.V_TRANSITION_DESC,S.V_LOCALE_CODE)
/