
UPDATE app_configuration SET value = '#PAMnamespaceID#' where variable = 'application_namespace_id';
UPDATE app_configuration SET value = '#root_oid#.12' where variable = 'hl7v3_organization_oid';
UPDATE app_configuration SET value = '#root_oid#.13' where variable = 'hl7v3_pdq_pdc_device_id';
UPDATE app_configuration SET value = '#root_oid#.14' where variable = 'hl7v3_pdq_pds_device_id';
UPDATE app_configuration SET value = '#root_oid#.8' where variable = 'hl7v3_pix_consumer_device_id';
UPDATE app_configuration SET value = '#root_oid#.10' where variable = 'hl7v3_pix_mgr_device_id';
UPDATE app_configuration SET value = '#root_oid#.9' where variable = 'hl7v3_pix_organisation_oid';
UPDATE app_configuration SET value = '#root_oid#.11' where variable = 'hl7v3_pix_src_device_id';
UPDATE app_configuration SET value = '#root_oid#.15' where variable = 'hl7v3_xcpd_initgw_device_id';
UPDATE app_configuration SET value = '#root_oid#.16' where variable = 'hl7v3_xcpd_respgw_device_id';
UPDATE app_configuration SET value = '#root_oid#.12' where variable = 'hl7v3_xcpd_initgw_home_community_id';
UPDATE app_configuration SET value = '#root_oid#.12' where variable = 'hl7v3_xcpd_respgw_home_community_id';
UPDATE pam_message_id_generator set oid = '#root_oid#.4' where issuing_actor_id = 1 ;
UPDATE pam_message_id_generator set oid = '#root_oid#.5' where issuing_actor_id = 2;
UPDATE pam_message_id_generator set oid = '#root_oid#.6' where issuing_actor_id = 5;
UPDATE pam_message_id_generator set oid = '#root_oid#.7' where issuing_actor_id = 6;
UPDATE pam_message_id_generator set oid = '#root_oid#.8' where issuing_actor_id = 7;
UPDATE pam_message_id_generator set oid = '#root_oid#.18' where issuing_actor_id = 12;
UPDATE pam_message_id_generator set oid = '#root_oid#.17' where issuing_actor_id = 11;




UPDATE oid_generator SET root = '#root_oid#.3.3.' where target = 'profile';
UPDATE oid_generator SET root = '#root_oid#.3.1.' where target = 'resource';




UPDATE cmn_application_preference set preference_value = '#root_oid#.14.' where preference_name = 'x_validation_log_root_oid';
UPDATE cmn_application_preference set preference_value = '#root_oid#.13.3.' where preference_name = 'x_validator_root_oid';
UPDATE evsc_calling_tool set oid = '#root_oid#.2' where tool_type = 1;
UPDATE evsc_calling_tool set oid = '#root_oid#.22' where tool_type = 2 and label = 'GWT';


UPDATE cmn_application_preference SET preference_value='#root_oid#.18.3' WHERE preference_name='religion_oid';
UPDATE cmn_application_preference SET preference_value='#root_oid#.18.1' WHERE preference_name='scorecard_root_oid';
UPDATE cmn_application_preference SET preference_value='#root_oid#.18.4' WHERE preference_name='sex_oid';


UPDATE app_configuration SET value='#root_oid#.23.2' WHERE variable='epsos_source_root_oid';
UPDATE app_configuration SET value='#root_oid#.23.4' WHERE variable='home_root_oid';
UPDATE app_configuration SET value='#root_oid#.23.5' WHERE variable='ihe_source_root_oid';
UPDATE app_configuration SET value='#root_oid#.23.6.' WHERE variable='ihe_source_root_oid';


UPDATE om_number_generator set universal_id = '#root_oid#.8.3' where namespace_id = 'IHE_OM_ANALYZER_MGR';
UPDATE om_number_generator set universal_id = '#root_oid#.8.4' where namespace_id = 'IHE_OM_ANALYZER';
UPDATE om_number_generator set universal_id = '#root_oid#.8.5' where namespace_id = 'IHE_OM_OF';
UPDATE om_number_generator set universal_id = '#root_oid#.8.6' where namespace_id = 'IHE_OM_OP';
UPDATE om_number_generator set universal_id = '#root_oid#.8.7' where namespace_id = 'IHE_OM_AM';