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.

1. Navigate to the Product Development work area.

2. To create an analysis, click the Reports and Analytics side tab and click Browse Catalog.

3. 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.

4. 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.

5. 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

6. 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.

7. In the Create New Action dialog, add the reference to Item ID in the URL field.

8. Click Options to open the Action Options window.

9. Select the Open in New Window check box and click OK. You return to the Create New Action window.

10. Click OK. You return to the New Action link window.

11. 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.

12. Click Save Analysis.

13. Click the Results tab. Click a link in the search results and notice that the object opens in a new window.