getting direct url to instances' audit trail page (SOA11G)

Is it very slow to access an instance audit trail from EM console. So use this function to get direct url to your audit trail. Don't forget to change the admin server,port, farm and managed server name..

create or replace function get_url(v_cikey in number) return varchar2 is
  Result varchar2(1000); 
begin
  select 
   'http://servername:serverport/em/faces/ai/soa/bpelInstance?refresh=yes&&target=/Farm_SOA-PROD-DMN/SOA-PROD-DMN/MANAGEDSERVERNAME/'||domain_name||'/'||composite_name||'%20['||composite_revision||']&&type=oracle_soa_composite&&soaContext='||domain_name||'/'||composite_name||'!'||composite_revision||'/'||component_name||'/bpel:'||cikey url into Result 
   from cube_instance where cikey=v_cikey;
  return(Result);
end get_url;

the function above was for 11.1.1.6 and I use this for 11.1.1.7

   'http://servername:serverport//em/faces/ai/soa/bpelInstance?refresh=yes&&target=/Farm_SOA-PROD-DMN/SOA-PROD-DMN/MANAGEDSERVERNAME/'||c.domain_name||'/'||c.component_name||'%20['||c.composite_revision||']&type=oracle_soa_composite&soaContext='||c.domain_name||'/'||c.component_name||'!'||c.composite_revision||'/'||c.component_name||'/bpel:'||c.cikey||'&currentTab=audit' url into Result

not working for you? So install wireshark and sniff the packets when you click a link to audit trail at EM console. Get the url and change the variable parts ;)