Configure Action Links to Items from Reports
You can create action links (or deep links) to navigate from Oracle Transactional Business Intelligence (OTBI) reports to specific items.
-
Navigate to the Product Development work area.
-
To create an analysis, click the Reports and Analytics side tab and click Browse Catalog.
-
To create a report about items and add fields:
-
In the Catalog page, from the New menu, click Analysis.
-
Select Product Management: Item Revision Real Time from the Select Subject Area menu.
-
From the Subject Areas panel, click Item > Main. Use the scroll bar to select Item Name, Item ID, and Organization ID. Other columns of data are optional.
-
-
The Item ID and Organization ID don't' work with a decimal value. To set a non-decimal value for the item ID:
-
Click Inventory Item ID. From the menu, click Column Properties.
-
In the Column Properties dialog, click the Data Format tab.
-
Select the Override Default Data Format check box.
-
Set the value in Decimal Places to a non-decimal value. Click OK.
-
Similarly set the Organization ID to a non-decimal value.
-
-
To configure the name column as a URL that opens the selected object in another tab:
-
In Selected Columns, select the Item Name.
-
From the menu, click Column Properties. In the Column Properties dialog click the Interaction tab.
-
From the Primary Interaction menu, select Action Links and create a link format.
-
Click the + icon to add an action link.
-
From the New Action Link dialog, select Navigate to a Web Page.
-
In the Create New Action dialog, add the URL. This creates a web page and passes dynamic values to load the selected object. The template of the dynamic URL is:
https://<hostname>/productLifecycleManagement/faces/deeplink?objType=ITEMS&action=EDIT&objKey=itemId=<INVENTORY_ITEM_ID>&orgId=<ORGANIZATION_ID>
Note that:
-
Object Type is Item
-
Action is Edit
-
Object Key is Item ID
-
-
-
To define parameters:
-
Click Define Parameters. The value for the object key is dynamic and the object ID is retrieved from the report data.
-
Click the menu available in the Values column and the third row. Select Column Value and then select Item ID.
-
Click the menu available in the Values column and the fourth row. Select Column Value and then Organization ID.
-
To ensure that the URLs work automatically, select the Fixed and Hidden check boxes in all the rows.
-
-
In the Create New Action dialog, add the reference to Item ID in the URL field.
-
Click Options to open the Action Options window.
-
Select the Open in New Window check box and click OK. You return to the Create New Action window.
-
Click OK. You return to the New Action link window.
-
Click OK. In the Column Properties window, select the 'Do not display pop-up if only one addition link is available at runtime' check box. This helps when there are multiple links with different actions. Click OK.
-
Click Save Analysis.
-
Click the Results tab. Click a link in the search results and notice that the object opens in a new window.