Repository/Session variable with hostname for Drill Down

Vincent

Organization Name

Sogetrel

Description

We need a variable that contains the application hostname. This would make dynamic the URL used in action links.

Use Case and Business Need

Following procedure described in Drill Down To Fusion Financial Applications from OTBI ERP Reports, we are able to use Action Links to drill down from OTBI adhoc reports to transaction details in Oracle Fusion Applications.

In this documentation, we have to build an URL based on our POD. When we deploy the analysis in another POD, we need to rewrite the analysis to update the hostname in the URL.
https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=InvoiceId=@{3}

With this new variable, we would have the following URL: https://@{4}/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=InvoiceId=@{3} with variable 4 got from a Session/repository variable instead of a value or column value.

Original Idea Number: 903fd0d6bc