Oracle Fusion Analytics: Use of Deep Links to navigate to Fusion Applications from Workbooks

March 13, 2024 | 6 minute read
Craig Andrews
Senior Member of Technical Staff
Text Size 100%:

Fusion Data Intelligence provides the ability to drill to transactional detail directly from a workbook, using data presented from the subject areas as part of the product.  This uses a concept known as deep links.  Deep Links are URL links that can be distributed outside of Fusion Applications and allow users to open pages without navigating through a menu structure.

It's important to point out that the Oracle Fusion Application pages will be rendered based on the security privileges of the users and as such a Fusion Application login is required with the relevant access granted.  If the user does not have access to a page, then nothing will be rendered.  If the user is not already signed into the Fusion Application before navigating, then they will be re-directed to the login page.  If you have configured single sign-on with your Fusion Data Intelligence instance, this should appear seamless to the users.

The purpose of this blog is to demonstrate how this is possible based one particular use case, however there are many different deep link options available: -

Use Case: An Oracle Fusion Data Intelligence workbook displays Invoice Details which the users then wishes to select to open Fusion Applications in order to edit the specific invoice.

In order to see a complete list of the available Deep Links, use the Deep Links work area (Navigator > Tools > Deeps Links) within Fusion Applications.  In order to access this work area, you will need to have the View Administration Link (FND_VIEW_ADMIN_LINK_PRIV) privilege.

  • To provide a deep link from an Oracle Fusion Data Intelligence workbook displaying Invoice Detail, firstly create the workbook from your Oracle Fusion Data Intelligence instance, select "Create" and then "Workbook".

Create Workbook

  • Select the Subject area which contains reference to the transactional detail the user wishes to navigate too in Fusion Applications (i.e. invoice ID) and select “Add to Project”.  For this use case the “Financials – AP Invoices” subject area has been used as shown below.  Ensure you click on the Subject Areas tab and then select the appropriate subject area.

Choose Subject Area

  • Within the workbook, create a parameter which will contain reference to the out of the box repository variable "FUSION_HOST_NAME".  Please ensure that all users accessing the deep link have access to the subject area being referenced within the logical query.

Create Workbook parameter

  • Within the workbook add the attributes and metric you wish to include.  For this purpose Invoice Number, Invoice Description and Invoice Identifier (Under Invoice Details > Document Details folders) and Supplier Number and Supplier Name (Under the Supplier folder) have been selected.

  • Save the workbook.
  • In order to navigate from the data contained within this workbook to the appropriate Fusion Application page, create a Data Action.  Select on the action menu in the top right corner, and select "Data Actions".

Select Data Actions

  • Click on the + symbol to add a new Data Action.

Create new Data Action

  • Enter a name for the Data Action (In this example I have named this “Edit Invoice”.  Select the Type as “URL Navigation” and enter the URL in the box provided.  The URL should consist of: -

@parameter("FUSION_HOST_NAME")('FUSION_HOST_NAME_VARIABLE_NOT_FOUND')/fscmUI/faces/deeplink?objType=AP_EDITINVOICE&action=EDIT&objKey=InvoiceId=

In the above URL you can reference the parameter created earlier which prevents you having to manually update this as and when you promote to different instances.

Note: the URL above is different in each case based on the deep link being used, reference the appropriate object type and keys based on the use case.  You can do this by using the complete list of deep links referenced earlier in this blog.  In this case we have entered the prompts ‘AP_EDITINVOICE’ and ‘EDIT’.

Add Data Action Details

  • To reference the Invoice ID from the result set, enter the symbols ${ after the = sign.  This will then automatically display a list of values as shown below:

Add Data Action Details Key Values

  • Select valuesForColumn:”column”.
  • Click on ‘column’ as shown below, this will open up the attributes from the subject area.  Select Invoice Identifier (under Invoice Details > Document Details).  Then Click ‘OK’.

Add Data Action Details Column ID

  • Right click on the Data Visualization result set and select the “Edit Invoice” data actions option.  This will then display the Edit Invoice page in Fusion Applications with reference to the Invoice that was selected when clicking the data action link.  This is only rendered should you have the relevant permissions to view the page in Fusion Applications.

Select DV Menu Option

  • The “Edit Invoice” screen is opened in Fusion Applications with the Invoice displayed for Editing.

 

I have provided one particular example of how this can be used, but there are many more for you to explore.

For further information on Fusion Analytics Warehouse click here.

For further information about What's new in Fusion Analytics warehouse click here.

Craig Andrews

Senior Member of Technical Staff


Previous Post

AI and the Evolution of Self-Service Analytics

James Richardson | 5 min read

Next Post


The Role of Native Credentials in Oracle Analytics Cloud