Blitz Report Add-in Setup Environment

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
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.
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
from dual
Download
Related Blitz Reports
CAC Inventory and Intransit Value (Period-End) CAC Manufacturing Variance CAC ICP PII WIP Material Usage Variance CAC ICP PII Inventory and Intransit Value (Period-End) CAC Inventory Pending Cost Adjustment - No Currencies CAC ICP PII WIP Pending Cost Adjustment CAC Cost Type Costs Not in Period Close Inventory Snapshot CAC Item Cost & Routing CAC Missing Material Accounting Transactions
Blitz Report™