OAC Action Links on Column Value
Note: The following configuration needs to be done before navigating from Oracle Analytics Cloud to Oracle Transportation Management.
- Go to Transportation Intelligence > Ad Hoc Query.
- Select Transportation Intelligence from subject areas.
- From Shipment analysis select OTM Shipment GID.
- Click the Settings button, and then select Column Properties.
- Go to the Interaction tab. From the Value > Primary Interaction drop-down list, select Action Links.
- Click the + icon, and then create a new action. Click Navigate to Web Page.
- 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}
- Under Define Parameters click the + icon and for the newly added record enter pk as prompt.
- Under Value Column, select the option Column Value from the drop-down list Value.
- Click the down arrow beside Column Value, and select the shipment ID.
- Click OK.
- Enter Link Text, for example, “Navigate to OTM Shipment View”.
- Click OK.
- 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.
- Click OK.
- Go to the Results tab. You'll see hyperlinks in the Column Value column where you added the action.
- Click any of the value and click Execute. You'll be redirected to the shipment page.
- Similarly, you can configure URLs for others based on the column value.