How to Identify Your Oracle Cloud ERP POD Name Using fusion.ask_deployed_domains
In Oracle Fusion Cloud ERP, the POD name (the specific deployment instance a customer is on) is a critical piece of information. For BI Publisher reports, correctly identifying your POD can unlock multiple valuable use cases, including:
- Routing outputs to different destinations based on the POD.
- Creating POD-aware deep links inside reports for launcher URLs.
- Customizing report logic or data filtering per POD.
The Key Table: fusion.ask_deployed_domains
Oracle provides a table called fusion.ask_deployed_domains that stores information about all deployed domains (PODs) in the environment. You can query this table to retrieve the POD name programmatically.
SELECT external_virtual_host
, SUBSTR(dd.external_virtual_host, 1, INSTR(dd.external_virtual_host, '.') - 1) AS pod_name
FROM fusion.ask_deployed_domains dd
WHERE dd.deployed_domain_name = 'FADomain'
This query returns the deployed domain name, which corresponds to your POD name. Usually, this value looks like something:
external_virtual_host = https://pod1234-dev1.fa.us2.oraclecloud.com
pod_name = pod1234-dev1
Use Cases
Use Cases in BI Publisher
01.
Routing Outputs Based on POD
With the POD name dynamically fetched during report execution, you can:
- Send report outputs (PDFs, Excel, Flat Files) to (S)FTP or email destinations that differ according to POD.
- Configure bursting file paths dynamically, ensuring compliance with each POD’s specific handling rules.
02.
POD-specific Deeplinks in Reports
Many BI Publisher reports include deeplinks back to transactional or dashboard pages. Embedding the POD name into these URLs ensures links always point to the correct environment.
https://dev1.fa.us2.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_REQUISITION_LOBUSER&objKey=requisitionHeaderId=12345&action=VIEW
POD-awareness is a must!
Identifying your Oracle Fusion Cloud environment’s POD name using fusion.ask_deployed_domains is a simple yet powerful technique. It enhances your BI Publisher reports with environment-awareness, allowing dynamic output routing, seamless deeplink generation, and flexible report customization.
Next time you build or enhance your Oracle Fusion Cloud BI Publisher reports, consider integrating POD-awareness for a smarter, more robust reporting experience.
Need some assistance?
Ready to bring clarity to customer, supplier and employee communications? With BI Publisher, we specialise in customising customer, supplier, and employee-facing documents such as invoices, purchase orders, payslips, and statements to meet your exact branding, compliance, and operational needs. From layout design to data logic enhancements, we help you deliver clear, consistent, and impactful outputs across your organization. Contact us today to discover how our expertise in BI Publisher can streamline your document processes and elevate your business communications.
