7 Post-Installation Steps - Pack on Pack

This section provides the pack on pack, post installation steps for Sanctions application pack.

To perform the pack on pack post installation of the Sanctions application pack above the ECM application pack, execute the following queries in the Config Schema:

Note:

ECM application pack version 8.1.2.0.0 must be already installed.

MERGE INTO AAI_AOM_APP_COMP_ATTR_MAPPING T USING ( SELECT '1' APP_COMP_
ATTR_MAP_ID, '1' N_ATTRIBUTE_ID, 'Action' V_ATTR_CODE, '1002' N_ATTR_-
TYPE_ID, 'select t.action_cd,t.action_nm from kdd_action t where
t.action_category_code is not null and t.action_category_code not in
(''ENT'',''PR'',''EXP'',''AS'',''DD'', ''OBS'')' V_ATTRIBUTE_VALUE1, ''
V_ATTRIBUTE_VALUE2,'OFS_NGECM' N_APP_ID, '-1' N_COMP_ID, '' V_UDP_CODE,
''V_ATTR_CONTROL_TYPE FROM DUAL) S
ON ( T.APP_COMP_ATTR_MAP_ID = S.APP_COMP_ATTR_MAP_ID AND T.N_APP_ID =
S.N_APP_ID )
WHEN NOT MATCHED THEN INSERT
(APP_COMP_ATTR_MAP_ID,N_ATTRIBUTE_ID,V_ATTR_CODE,N_ATTR_TYPE_ID,V_ATTRIB
UTE_VALUE1,V_ATTRIBUTE_VALUE2,N_APP_ID,N_COMP_ID,V_UDP_CODE,V_ATTR_CONTROL_
TYPE)VALUES
(S.APP_COMP_ATTR_MAP_ID,S.N_ATTRIBUTE_ID,S.V_ATTR_CODE,S.N_ATTR_TYPE_ID,
S.V_ATTRIBUTE_VALUE1,S.V_ATTRIBUTE_VALUE2,S.N_APP_ID,S.N_COMP_ID,S.V_UDP_
CODE,S.V_ATTR_CONTROL_TYPE)
/
MERGE INTO AAI_AOM_APP_COMP_ATTR_MAPPING T USING ( SELECT '2' APP_COMP_
ATTR_MAP_ID, '2' N_ATTRIBUTE_ID, 'Status' V_ATTR_CODE, '1002' N_ATTR_-
TYPE_ID, 'select t.status_cd,t.status_nm from kdd_status t where
t.viewd_result_status_cd is null or t.viewd_result_status_cd <>
''OBS''' V_ATTRIBUTE_VALUE1, '' V_ATTRIBUTE_VALUE2,'OFS_NGECM' N_APP_ID,
'-1' N_COMP_ID, '' V_UDP_CODE, ''V_ATTR_CONTROL_TYPE FROM DUAL) S
ON ( T.APP_COMP_ATTR_MAP_ID = S.APP_COMP_ATTR_MAP_ID AND T.N_APP_ID =
S.N_APP_ID )
WHEN NOT MATCHED THEN INSERT
(APP_COMP_ATTR_MAP_ID,N_ATTRIBUTE_ID,V_ATTR_CODE,N_ATTR_TYPE_ID,V_ATTRIB
UTE_VALUE1,V_ATTRIBUTE_VALUE2,N_APP_ID,N_COMP_ID,V_UDP_CODE,V_ATTR_CONTROL_
TYPE)VALUES
(S.APP_COMP_ATTR_MAP_ID,S.N_ATTRIBUTE_ID,S.V_ATTR_CODE,S.N_ATTR_TYPE_ID,
S.V_ATTRIBUTE_VALUE1,S.V_ATTRIBUTE_VALUE2,S.N_APP_ID,S.N_COMP_ID,S.V_UDP_
CODE,S.V_ATTR_CONTROL_TYPE)
/
MERGE INTO AAI_AOM_APP_COMP_ATTR_MAPPING T USING ( SELECT '9' APP_COMP_
ATTR_MAP_ID, '9' N_ATTRIBUTE_ID, 'NextStatus' V_ATTR_CODE, '1002'
N_ATTR_TYPE_ID, 'select t.status_cd,t.status_nm from kdd_status t where
t.viewd_result_status_cd is null or t.viewd_result_status_cd <>
''OBS''' V_ATTRIBUTE_VALUE1, '' V_ATTRIBUTE_VALUE2,'OFS_NGECM' N_APP_ID,
'-1' N_COMP_ID, '' V_UDP_CODE, ''V_ATTR_CONTROL_TYPE FROM DUAL) S
ON ( T.APP_COMP_ATTR_MAP_ID = S.APP_COMP_ATTR_MAP_ID AND T.N_APP_ID =
S.N_APP_ID )
WHEN NOT MATCHED THEN INSERT
(APP_COMP_ATTR_MAP_ID,N_ATTRIBUTE_ID,V_ATTR_CODE,N_ATTR_TYPE_ID,V_ATTRIB
UTE_VALUE1,V_ATTRIBUTE_VALUE2,N_APP_ID,N_COMP_ID,V_UDP_CODE,V_ATTR_CONTROL_
TYPE)VALUES
(S.APP_COMP_ATTR_MAP_ID,S.N_ATTRIBUTE_ID,S.V_ATTR_CODE,S.N_ATTR_TYPE_ID,
S.V_ATTRIBUTE_VALUE1,S.V_ATTRIBUTE_VALUE2,S.N_APP_ID,S.N_COMP_ID,S.V_UDP_
CODE,S.V_ATTR_CONTROL_TYPE)
/