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. Click 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. Click the + icon, and then create a new action. Click Navigate to Web Page.
  7. Enter the following URL by replacing the host with theyour Oracle Transportation Management host and click 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 click 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. Click the down arrow beside Column Value, and select the shipment ID.
  11. Click OK.
  12. Enter Link Text, for example, “Navigate to OTM Shipment View”.
  13. Click 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. Click OK.
  16. Go to the Results tab. You'll see hyperlinks in the Column Value column where you added the action.
  17. Click any of the value and click Execute. You'll be redirected to the shipment page.
  18. Similarly, you can configure URLs for others based on the column value.