Deeplinks from OTBI Report to transaction details

Pre-Requisites:

    1. Access to Subject Area

Process:

1.   Create an OTBI Report with required subject Area.

2.     Get the Action Link URL.

3.     Define Parameters

4.     Complete the deep link optional setup and Save the changes.

5.     Verify the results.

Example: To add deeplinks from Payables Invoice

Step 1: Create an OTBI Report with required subject Area.

Select the subject Area – Payables Invoices - Transactions Real Time

Drag and drop the required columns along with Invoice ID (Unique Identifier)

Click on Column properties from settings

Add a new action link. In the Action Link dialog box, set the Action to Navigate to a Web Page.

Step 2: Get the Action Link URL.

In the below link Replace hostname with your Instance

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=InvoiceId=@{3}

Note: To get all the Possible Deeplink URLs, check the Reference section

Step 3: Define Parameters

Step 4: Complete the deep link optional setup and Save the changes.

In the Options dialog box, enable the Open In New Window check box. This causes the View Payable Invoice UI to open in a new window.

select the Hidden check box in the Define Parameters table. This prevents display of an additional dialog box that shows parameter values passed at run-time before navigating to the View Payable Invoice UI.

Click on OK and navigate to the results tab

 Step 5: Verify the results.

 Click on any Invoice Number, You will see the created Action

Click on the Action name, You will be navigated to the Invoice page

Common Mistakes:

While Entering URL, ensure it is in single line with no spaces in between

Correct:

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=InvoiceId=@{3}

Incorrect:

https://hostname/fscmUI/faces/ deeplink?

objType=@{1}&action=@{2}&o

 bjKey=InvoiceId=@{3}

Reference:

Oracle support Document - How To Drill Down To Fusion Financial Applications Transactions From OTBI ERP Reports (Doc ID 2603149.1)