This script will update the node definitions and all the routings associated with those nodes in a database. The prior node name is assumed to start with the Application prefix (HR, FS, ELM), so you need to change that value to match your system. You will be prompted for the new node names.

UpdateNodeRoutings.sql

declare
  v_elmnode varchar2(8);
  v_hrnode varchar2(8);
  v_fsnode varchar2(8);
  
begin
  v_elmnode := '&ELMNodeName';
  v_hrnode 	:= '&HRNodeName';
  v_fsnode	:= '&FSNodeName';

  -- Update Node Name
  update psmsgnodedefn set msgnodename = v_hrnode where msgnodename like 'HR%';
  update psmsgnodedefn set msgnodename = v_hrnode where msgnodename like 'FS%';
  update psmsgnodedefn set msgnodename = v_hrnode where msgnodename like 'ELM%';
   
  -- Node URI Text
  -- URI_TEXT field also needs to be updated   
  update psnodeuritext set msgnodename = v_hrnode where msgnodename like 'HR%';
  update psnodeuritext set msgnodename = v_hrnode where msgnodename like 'FS%';
  update psnodeuritext set msgnodename = v_hrnode where msgnodename like 'ELM%';

  -- Update HR Node Name in Routings
  update PSIBRTNGDEFN set sendernodename = v_hrnode where sendernodename like 'HR%';
  update PSIBRTNGDEFN set receivernodename = v_hrnode where receivernodename like 'HR%';

  -- Update FS Node Name in Routings
  update PSIBRTNGDEFN set sendernodename = v_hrnode where sendernodename like 'FS%';
  update PSIBRTNGDEFN set receivernodename = v_fsnode where receivernodename like 'FS%';

  -- Update ELM Node Name in Routings
  update PSIBRTNGDEFN set sendernodename = v_elmnode where sendernodename like 'ELM%';
  update PSIBRTNGDEFN set receivernodename = v_elmnode where receivernodename like 'ELM%';

  -- Update Trusted Nodes
  update pstrustnodes set msgnodename = v_hrnode where msgnodename like 'HR%';
  update pstrustnodes set msgnodename = v_hrnode where msgnodename like 'FS%';
  update pstrustnodes set msgnodename = v_hrnode where msgnodename like 'ELM%';
  
  commit;  
  
end;