Description
In OTBI Analytics, How to find the Dynamic Instance lInk.?
Please find the below Example for Detail Case.
Use Case and Business Need
For example, I am using one invoice deep link in my 20 OTBI Analysis, (Deep link: when I click on invoice number in OTBI analytics it will redirect me to Manage Invoice Home Page with invoice details). Now suppose I need to move all 20 Analysis from one instance to another instance (XXX-TEST to XXX-DEV3). then again I need to edit all the deep links and change the instance URL.
Example :
Test Instance Deep link: https://XXX-test.fa.us2.oraclecloud.com/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId=Invoice_id
New Dev3 Instance Deep Link: https://XXX-Dev3.fa.us2.oraclecloud.com/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId=Invoice_id
More details
In BI Publisher we can fetch the Instance link using the below SQL.
SELECT external_virtual_host pod_url FROM ask_deployed_domains WHERE deployed_domain_name = 'FADomain'
But in OTBI we Don't have the option to find the Instance link
I have one solution developed by myself but it's very tricky to use.
https://jpulkit.wordpress.com/2021/07/26/oracle-fusion-how-to-add-dynamic-deep-link-in-otbi-analysis-dashboard/
Original Idea Number: f15849b82c
