OAC Action Links on Column Value

Note: The following configuration needs to be done before navigating from Oracle Analytics Cloud to Oracle Transportation Management.

1. Go to Transportation Intelligence > Ad Hoc Query.
2. Select Transportation Intelligence from subject areas.
3. From Shipment analysis select OTM Shipment GID.
4. Select the Settings button, and then select Column Properties.
5. Go to the Interaction tab. From the Value > Primary Interaction drop-down list, select Action Links.
6. Select the + icon, and then create a new action. Select Navigate to Web Page.
7. Enter the following URL by replacing the host with theyour Oracle Transportation Management host and select Define Parameters. This URL is for navigating to the shipment page. "@{3}" in the URL will be replaced by the shipment ID. The URL format is: https://<OTM host>/GC3/ShipmentCustManagement?manager_layout_gid=SHIPMENT_VIEW&management_action=view&pk=@{3}
8. Under Define Parameters select the + icon and for the newly added record enter pk as prompt.
9. Under Value Column, select the option Column Value from the drop-down list Value.
10. Select the down arrow beside Column Value, and select the shipment ID.
11. Select OK.
12. Enter Link Text, for example, “Navigate to OTM Shipment View”.
13. Select OK.
14. Select the checkbox Do not display in a popup if only one action link is available at runtime if you want the values to be populated automatically.
15. Select OK.
16. Go to the Results tab. You'll see hyperlinks in the Column Value column where you added the action.
17. Select any of the value and select Execute. You'll be redirected to the shipment page.
18. Similarly, you can configure URLs for others based on the column value.