Deep linking lets you to navigate from an analysis on the interface pages to specific attributes and objects in your work areas so that you can work with them directly. Deep links allow you to open pages without navigating through the menu structure. They come in handy if you want users to go directly from various locations to the Oracle Applications Cloud. You can add deep links to a business intelligence report, an email notification, or a company website hosted on Oracle Cloud.
Deep links provide several key advantages:
- Allows you to access an object and its data directly using an url
- Eliminates the need for menu navigation and query of data.
- Can be embedded as an url in OTBI reports, emails, custom applications for quick access.
- Security is enforced based on user login privileges.
- Improves user productivity by reducing the number of clicks needed to reach information.
A typical deep link URL follows this structure:
For example, the following URL opens a specific Manufacturing Work Order directly in Oracle Fusion:
https://<pod-name>/fscmUI/faces/deeplink?objType=WIE_WORK_ORDER&action=VIEW&objKey=organizationCode=M1;workOrderNumber=WO1005
Creating deep links in Oracle Transactional Business Intelligence (OTBI) enables direct navigation from report results to specific transactional pages (e.g., invoices, work orders) in Oracle Fusion Applications. This is achieved by embedding a navigation URL as an action link within the report column properties, passing necessary object IDs dynamically.
Here are the detailed steps to add a deep link to the Work Order column in an OTBI report so that clicking the Work Order opens the Oracle Fusion Work Order page.
- Created an Open Work Orders OTBI Report using “Manufacturing – Work Order Performance Real Time” subject area, including the columns# Organization Code, Work Order Id and Work Order. Applied filters on Status (only Released & Unreleased) and Organization Code columns in the report.
2. Construct link to the work order page:
https://<pod-name>/fscmUI/faces/deeplink?objType=<objType>&action=<action>&objKey=name1=value1;name2=value2>
- Replace pod-name with the URL of your instance
- Replace objType with the WIE_WORK_ORDER
- Replace action with EDIT/VIEW
- Replace Objkey with the organizationCode and workOrderNumber
3. Open the Column Properties for the Work Order column in the report and open the Interaction tab. Set the Primary Interaction for Value to Action Links.
4. Add Action link. In the popup, set the Link Text and set the Action to “Navigate to a Web Page”.
4. Enter URL as
then click on Define Parameters > “Create New Action” window popups as below
5. In the “Edit “Create New Action” popup,
- Change URL from https://fa-euth-dev45-saasfademo1.ds-fa.oraclepdemos.com/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=@{3} to
https://fa-euth-dev45-saasfademo1.ds-fa.oraclepdemos.com/fscmUI/faces/deeplink?objType=WIE_WORK_ORDER&action=VIEW&objKey=@{3}
- Delete parameters 1 (objType) & 2 (action)
- Under Define Parameters
- Name=1, Prompt=objKey and set the value to be “Column Value” of the Inventory Organization Code column in the report
- Add second parameter for Work Order number as below
Change the final URL as
- Check Hidden” for both the pramters.
- Click on Options > Action Options pop window > Enable “Open In New Window”
- Click on OK (Action Options) and Click on Ok (Create New Actions) popup windows.
6. Click on OK (New Action Link) – Brings back to the Work Order column properties – Interaction tab.
- Enable “Do not display in a popup if only one action link is available at runtime” under Interaction tab
- Click on “OK”
7. Run the report (Results) >> Displays the OTBI Report output
- Click on Work Order number > Opens the Work Order Page for the selected work order in View only mode in a separate window
Note:
The Work Order page URL can also be constructed using the WorkOrderId instead of the Organization Code and Work Order Number. However, for some reason, it did not work for me and returned a blank page.
For the Work Order Id Column, Make sure that Work Order Id data format set to 0 decimals.
SCM Deep Link Documentation: