OAC Action Links on Column Value

Navigate to Web Page Action Link

  1. Go to adhoc 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. Click Define Parameters.Define the following URL in the URL field. Replace the host with the Oracle Transportation Management host. The following URL is for navigating to shipment page. '@1' in the URL will be replaced by the shipment ID. The URL is: https://<OTM host>/GC3/ShipmentCustManagement?manager_layout_gid=SHIPMENT_VIEW&management_action=view&pk=@{1}
  8. Select the option Column Value from the drop-down list Value.
  9. Click the down arrow beside Column Value, and select the shipment ID.
  10. Click OK.
  11. Select the check box Do not display in a popup if only one action link is available at runtime if you want the values to be populated automatically.
  12. Go to the Results tab. You'll see hyperlinks in the Column Value column where you added the action.
  13. Click any of the value and click Execute. You'll be redirected to the shipment page.
  14. Similarly, you can configure URLs for others based on the column value.

List of URLs

NavigateToOTMShipmentUrl

Column: OTM Shipment GID

https:// <OTM host>/GC3/ShipmentCustManagement?manager_layout_gid=SHIPMENT_VIEW&management_action=view&pk=@{1}

Example:

https:// <OTM host>/GC3/ShipmentCustManagement?manager_layout_gid=SHIPMENT_VIEW&management_action=view&pk=FTIAUTOMATION3.01036

NavigateToGTMDeclarationtUrl

Column: Declaration GID

https:// <OTM host>/GC3/GtmTransactionCustManagement?manager_layout_gid=GTM_SHIPMENT_VIEW&management_action=view&finder_set_gid=GTM_SHIPMENT&pk=@{1}

Example:

https:// <OTM host>/GC3/GtmTransactionCustManagement?manager_layout_gid=GTM_SHIPMENT_VIEW&management_action=view&finder_set_gid=GTM_SHIPMENT&pk=ANALYTICSREG.DECL-01

NavigateToGTMDeclarationtLineUrl

Column: Declaration Line GID

https:// <OTM host>/GC3/GtmTransactionLineCustManagement?manager_layout_gid=GTM_SHIPMENT_LINE_VIEW&management_action=view&finder_set_gid=GTM_SHIPMENT_LINE&pk=@{1}

Example:

https:// <OTM host>/GC3/GtmTransactionLineCustManagement?manager_layout_gid=GTM_SHIPMENT_LINE_VIEW&management_action=view&finder_set_gid=GTM_SHIPMENT_LINE&pk=ANALYTICSREG.DECL-EXPORTS-DASHBOARD-02-0001

NavigateToGTMItemUrl

Column: Item_Gid

https:// <OTM host>/GC3/GtmItemCustManagement?manager_layout_gid=GTM_ITEM_VIEW&management_action=view&finder_set_gid=GTM_ITEM&pk=@{1}

Example:

https:// <OTM host>/GC3/GtmItemCustManagement?manager_layout_gid=GTM_ITEM_VIEW&management_action=view&finder_set_gid=GTM_ITEM&pk=ANALYTICSREG.CHOCOLATE

NavigateToGTMLicenseUrl

Column: Licence GID

https:// <OTM host>/GC3/GtmLicenseCustManagement?manager_layout_gid=GTM_LICENSE_VIEW&finder_set_gid=GTM_LICENSE&management_action=view&pk=@{1}

Example:

https:// <OTM host>/GC3/GtmLicenseCustManagement?manager_layout_gid=GTM_LICENSE_VIEW&finder_set_gid=GTM_LICENSE&management_action=view&pk=FTIAUTOMATION3.US-EXPORT-LICENSE

NavigateToGTMLicenseLineUrl

Column: Licence Line GID

https:// <OTM host>/GC3/GtmLicenseLineCustManagement?manager_layout_gid=GTM_LICENSE_LINE_VIEW&finder_set_gid=GTM_LICENSE_LINE&management_action=view&pk=@{1}

Example:

https:// <OTM host>/GC3/GtmLicenseLineCustManagement?manager_layout_gid=GTM_LICENSE_LINE_VIEW&finder_set_gid=GTM_LICENSE_LINE&management_action=view&pk=FTIAUTOMATION3.US-EXPORT-LICENSE-0001

NavigateToGTMPartyUrl

Column: Party GID

https:// <OTM host>/GC3/GtmContactCustManagement?manager_layout_gid=GTM_CONTACT_VIEW&management_action=view&pk=@{1}

Example:

https:// <OTM host>/GC3/GtmContactCustManagement?manager_layout_gid=GTM_CONTACT_VIEW&management_action=view&pk=ANALYTICSREG.CARRIER

NavigateToGTMTradeTransactionUrl

Column: GTM TRADE TRANSACTION GID

https:// <OTM host>/GC3/GtmTransactionCustManagement?manager_layout_gid=GTM_TRANSACTION_VIEW&management_action=view&finder_set_gid=GTM_TRANSACTION&pk=@{1}

Example:

https:// <OTM host>/GC3/GtmTransactionCustManagement?manager_layout_gid=GTM_TRANSACTION_VIEW&management_action=view&finder_set_gid=GTM_TRANSACTION&pk=ANALYTICSREG.PO-TRANS-02

NavigateToGTMTradeTransactionLineUrl

Column: TRADE TRANSACTION Line GID

https:// <OTM host>/GC3/GtmTransactionLineCustManagement?manager_layout_gid=GTM_TRANSACTION_LINE_VIEW&management_action=view&finder_set_gid=GTM_TRANSACTION_LINE&pk=@{1}

Example:

https:// <OTM host>/GC3/GtmTransactionLineCustManagement?manager_layout_gid=GTM_TRANSACTION_LINE_VIEW&management_action=view&finder_set_gid=GTM_TRANSACTION_LINE&pk=ANALYTICSREG.LINE2