OAC Action Links on Column Value
Navigate to Web Page Action Link
- Go to adhoc 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.
- 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}
- 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.
- 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.
- 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.
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