ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4C1749CF8C621698E0630100007F383D select sys_context('userenv','db_name') environment_name, nvl(fnd_profile.value('XXEN_WEBSERVICE_CONNECTION_TYPE'),'ORDS') connection_type, xxen_webservices.instance_url, case when nvl(fnd_profile.value('XXEN_WEBSERVICE_CONNECTION_TYPE'),'ORDS')='ORDS' then xxen_webservices.ords_client_id end ords_client_id, case when nvl(fnd_profile.value('XXEN_WEBSERVICE_CONNECTION_TYPE'),'ORDS')='ORDS' then xxen_webservices.ords_client_secret end ords_client_secret, nvl(fnd_profile.value('XXEN_REPORT_SSO_ENABLED'),'N') sso_enabled, xxen_webservices.sso_url sso_url, fnd_global.user_name user_name, (select v.value from v$parameter v where v.name='nls_language') nls_language, (select dbms_lob.substr(xmlagg(xmlelement(e,nvl(flv.description,initcap(replace(lower(flv.nls_language),'_',' ')))||'='||flv.nls_language||'|') order by decode(flv.installed_flag,'B',0,1), nvl(flv.description,flv.nls_language)).extract('//text()').getclobval(),4000,1) from fnd_languages_vl flv where flv.installed_flag in ('B','I')) nls_languages from dual Y US Blitz Report Add-in Setup Environment Generates connection configuration for the Blitz Report Excel Add-in. Open the output file in Excel with the add-in installed to auto-configure the environment. Enginatics