This chapter covers the following topics:
Oracle Shipping Execution integrates with third party carriers through the following common APIs (application programming interfaces) in the wsh_custom_pub custom hook to provide common solutions for customers who use both Oracle Shipping Execution and third party carriers:
Carrier Address Validation: WSH_CUSTOM_PUB.csp_shipment_services
Carrier Rate and Service: WSH_CUSTOM_PUB.rate_shipment_services
Carrier Time in Transit: WSH_CUSTOM_PUB.tnt_shipment_services
Carrier Tracking: WSH_CUSTOM_PUB.trk_shipment_services
See: Step 17: Specify Carrier Options in wsh_custom_pub Custom Hook, Oracle Order Management Implementation Manual.
The integration enables you to perform the following shipping-related tasks:
Estimate shipping costs for packages.
Track lines and LPNs (containers).
Find time in transit for ground shipments.
Validate address and postal code information for a shipment.
When you specify the third party carrier details in the wsh_custom_pub custom hook, the carrier related actions available in the Shipping Transactions window and Shipping Execution Simplified User Interface are:
Calculating rate and selecting service (only available in the Shipping Transactions window)
Tracking lines and containers
Viewing time in transit for a delivery, deliver line, and container.
Viewing carrier address validation for a delivery, delivery line, and container.
The following topics explain these actions for the carrier.
In the Carrier Rate and Service Selection window, you can calculate rates in US dollars, and select carrier services for deliveries, lines, and LPNs (containers).
You can update freight cost values for a delivery line. Lines and deliveries with the same Ship From and Ship To address are grouped into Rate and Service Groups, and total charges for each group can be calculated. When you calculate the total charges for a line item, you can also update the freight costs for that item.
You can compare charges for different carrier services, for example, between two-day express versus overnight delivery. You can also select different tracking options, view charges, and surcharges for an item, and enter dimensions for an item.
To Calculate Carrier Rate and Service Costs for a Delivery Using the Shipping Transactions Window
Navigate to the Carrier Rate and Service Selection window.
Navigate to the Rate and Service Group tabbed region. It displays the total freight charges in US dollars for a group and the Ship From and Ship To addresses for a delivery. You can view freight costs for a group or update freight costs for an item after completing your entries in the remaining tabs.
Select the rate chart and service such as ground or worldwide express.
Navigate to the Address Details tabbed region and view the detailed Ship From and Ship To address information.
Navigate to the Service Options tabbed region.
Select one or more service options such as Saturday Pickup or Additional Handling.
Navigate to the Tracking Options tabbed region.
Select the First and Second Ship Notification. Choose None, Domestic, or International.
Select the Call Tag.
Select the Delivery Confirmation.
Enable the Verbal Confirmation box if you want verbal confirmation.
Click Calculate to calculate the charges.
Navigate to the Charges tabbed region and view the product charge and surcharge and each line and item.
Navigate to the Weight tabbed region and view the default weight (from Oracle Inventory) for the line item displays in pounds.
Navigate to the Dimensions tabbed region.
Optionally, enter the length, width, and height for each line item.
Navigate to the Value tabbed region.
Select the packaging type and declared value for each item.
Click Update Freight Costs to update freight costs for the delivery lines.
Navigate to the Errors tab and view any errors that occur when calculating charges.
Click Done to save your work.
You can track carrier ground shipments for lines and containers (LPNs) and view information such as tracking numbers, status, and service type. You can also view detailed tracking information for a selected line such as the date and location where a package was picked up or dropped off.
To Track Lines and Containers Using the Shipping Transactions Window
Navigate to the Carrier Tracking Summary window.
The window displays the most recent tracking information including tracking number, status such as undelivered or delivered, service type, and date.
To view tracking details, select a line and click View Details to display the Carrier Tracking Detail window.
The Carrier Tracking Detail window displays the package progress including the date, location, and activity such as the arrival and departure scan.
Click Done.
To Track Lines and Containers Using the Shipping Execution Simplified User Interface (Alternate Method)
Navigate to the Details page.
Click Search.
The Search Details page appears.
Enter search criteria for the delivery lines or containers to which you want to track, and click Go.
Perform one of these procedures:
To Track Lines and Containers Using the Search Details Page
Select one or more delivery lines and container lines by clicking the corresponding check boxes in the Select column.
From the Actions menu, select Carrier Tracking.
Click Go.
The Carrier Tracking page appears. This page displays the most recent tracking information including tracking number, status such as undelivered or delivered, service type, shipped to, shipped/billed on date, location, and weight.
To view tracking details, click the Select to Show Information icon in the Details column.
The tracking details displays including date, location, and activity such as the arrival or departure scan.
Click OK.
Note: You can also track lines for a delivery line by performing the steps above from the Details page when any infotile is selected.
To Track Lines and Containers Using the Line Details Page
Click the Detail link for a delivery line in the search results table of the Search Details page.
The Line Detail page appears.
From the Actions menu, select Carrier Tracking.
Click Go.
The Carrier Tracking page appears. This page displays the most recent tracking information including tracking number, status such as undelivered or delivered, service type, shipped to, shipped/billed on date, location, and weight.
To view tracking details, click the Select to Show Information icon in the Details column.
The tracking details displays including date, location, and activity such as the arrival or departure scan.
Click OK.
To Track Lines and Containers Using the LPN Page
Click the Detail link for a container line in the search results table of the Search Details page.
The LPN page appears.
From the Actions menu, select Carrier Tracking.
Click Go.
The Carrier Tracking page appears. This page displays the most recent tracking information including tracking number, status such as undelivered or delivered, service type, shipped to, shipped/billed on date, location, and weight.
To view tracking details, click the Select to Show Information icon in the Details column.
The tracking details displays including date, location, and activity such as the arrival or departure scan.
Click OK.
The time in transit refers to the time in business days that it takes to ship between two sites using carrier ground service. The Carrier Time In Transit window and the Carrier Time In Transit page display the time in transit, ship from and ship to addresses, and the corresponding origin and destination addresses used by a carrier for a delivery.
To View Time In Transit for a Delivery Using the Shipping Transactions Window
Navigate to the Carrier Time in Transit window.
The Carrier Time in Transit window displays the selected items, the Ship From and Ship To codes, and the number of business days in transit.
Click Done to close the window.
To View Time In Transit for a Delivery Using the Shipping Execution Simplified User Interface (Alternate Method)
Navigate to the Deliveries page.
Click Search.
The Search Deliveries page appears.
Enter search criteria for the deliveries for which you want to view time in transit, and click Go.
Perform one of these procedures:
To View Time In Transit for a Delivery Using the Search Deliveries Page
Select one or more deliveries by clicking the corresponding check boxes in the Select column.
From the Actions menu, select Carrier Time In Transit.
Click Go.
The Carrier Time In Transit page appears displaying the deliveries, the ship from and ship to codes, the ship from and ship to addresses, the number of business days in transit, and the carrier origin and destination.
Click Done.
Note: You can also view time in transit for a delivery by performing the steps above from the Deliveries page when any infotile is selected.
View Time In Transit for a Delivery Using the Delivery Page
Click the Name link for a delivery in the search results table of the Search Deliveries page.
The Delivery page appears.
From the Actions menu, select Carrier Time In Transit.
Click Go.
The Carrier Time In Transit page appears displaying the deliveries, the ship from and ship to codes, the ship from and ship to addresses, the number of business days in transit, and the carrier origin and destination.
Click Done.
The time in transit refers to the time in business days that it takes to ship between two sites using carrier ground service. The Carrier Time in Transit window and the Carrier Time In Transit page display the time in transit, ship from and ship to addresses, and the corresponding origin and destination addresses used by a carrier for a delivery line or container.
To View Time in Transit for a Delivery Line or Container Using the Shipping Transactions Window
Navigate to the Carrier Time in Transit window.
The Carrier Time in Transit window displays the selected items, the Ship From and Ship To codes, and the number of business days in transit.
Click Done to close the window.
To View Time In Transit for a Delivery Line or Container Using the Shipping Execution Simplified User Interface (Alternate Method)
Navigate to the Details page.
Click Search.
The Search Details page appears.
Enter search criteria for the delivery lines or containers to which you want to view time in transit, and click Go.
Perform one of these procedures:
To View Time In Transit for a Delivery Line or Container Using the Search Details Page
Select one or more delivery lines and container lines by clicking the corresponding check boxes in the Select column.
From the Actions menu, select Carrier Time in Transit.
Click Go.
The Carrier Time In Transit page appears displaying the delivery line and containers, the ship from and ship to codes, the ship from and ship to addresses, the number of business days in transit, and the carrier origin and destination.
Click Done.
Note: You can also view time in transit for a delivery line by performing the steps above from the Details page when any infotile is selected.
To View Time In Transit for a Delivery Line Using the Line Details Page
Click the Detail link for a delivery line in the search results table of the Search Details page.
The Line Detail page appears.
From the Actions menu, select Carrier Time in Transit.
Click Go.
The Carrier Time In Transit page appears displaying the delivery line, the ship from and ship to codes, the ship from and ship to addresses, the number of business days in transit, and the carrier origin and destination.
Click Done.
To View Time In Transit for a Container Using the LPN Page
Click the Detail link for a container line in the search results table of the Search Details page.
The LPN page appears.
From the Actions menu, select Carrier Time in Transit.
Click Go.
The Carrier Time In Transit page appears displaying the container, the ship from and ship to codes, the ship from and ship to addresses, the number of business days in transit, and the carrier origin and destination.
Click Done.
The Carrier Address Validation window and the Carrier Address Validation page display the carrier address validation results. The validation process takes the Ship From and Ship To address postal codes for a delivery and matches it against the UPS address information. Matches are ranked using a quality rating system with 1.000 being the closest (highest) match.
To View Carrier Address Validation for a Delivery Using the Shipping Transactions Window
Navigate to the Carrier Address Validation window.
The top half of the window displays the results of the validation such as the number of address candidates and the accuracy of the validation.
The lower half of the window displays a ranking of matches from highest to lowest for the Ship From and Ship To addresses.
Click Done.
To View Carrier Address Validation for a Delivery Using the Shipping Execution Simplified User Interface (Alternate Method)
Navigate to the Deliveries page.
Click Search.
The Search Deliveries page appears.
Enter search criteria for the deliveries for which you want to view carrier address validation, and click Go.
Perform one of these procedures:
To View Carrier Address Validation for a Delivery Using the Search Deliveries Page
Select one or more deliveries by clicking the corresponding check boxes in the Select column.
From the Actions menu, select Carrier Address Validation.
Click Go.
The Carrier Address Validation page appears displaying the address validation for the deliveries.
The top half of the page displays the results of the validation such as the number of address candidates and the accuracy of the validation.
The lower half of the page displays a ranking of matches from highest to lowest for the Ship From and Ship To addresses.
Click Done.
Note: You can also view carrier address validation for a delivery by performing the steps above from the Deliveries page when any infotile is selected.
View Carrier Address Validation for a Delivery Using the Delivery Page
Click the Name link for a delivery in the search results table of the Search Deliveries page.
The Delivery page appears.
From the Actions menu, select Carrier Address Validation.
Click Go.
The Carrier Address Validation page appears displaying the address validation for the delivery.
The top half of the page displays the results of the validation such as the number of address candidates and the accuracy of the validation.
The lower half of the page displays a ranking of matches from highest to lowest for the Ship From and Ship To addresses.
Click Done.
The Carrier Address Validation window and the Carrier Address Validation page display the carrier address validation results. The validation process takes the Ship From and Ship To address postal codes for a delivery line or container and matches it against the UPS address information. Matches are ranked using a quality rating system with 1.000 being the closest (highest) match.
To View Carrier Address Validation for Delivery Lines Using the Shipping Transactions Window
Navigate to the Carrier Address Validation window.
The top half of the window displays the results of the validation such as the number of address candidates and the accuracy of the validation.
The lower half of the window displays a ranking of matches from highest to lowest for the Ship From and Ship To addresses.
Click Done.
To View Carrier Address Validation for a Delivery Line or Container Using the Shipping Execution Simplified User Interface (Alternate Method)
Navigate to the Details page.
Click Search.
The Search Details page appears.
Enter search criteria for the delivery lines or containers to which you want to view carrier address validation and click Go.
Perform one of these procedures:
To View Carrier Address Validation for a Delivery Line or Container Using the Search Details Page
Select one or more delivery lines and container lines by clicking the corresponding check boxes in the Select column.
From the Actions menu, select Carrier Address Validation.
Click Go.
The Carrier Address Validation page appears displaying the address validation for the delivery lines and containers.
The top half of the page displays the results of the validation such as the number of address candidates and the accuracy of the validation.
The lower half of the page displays a ranking of matches from highest to lowest for the Ship From and Ship To addresses.
Click Done.
Note: You can also view carrier address validation for a delivery line by performing the steps above from the Details page when any infotile is selected.
To View Carrier Address Validation for a Delivery Line Using the Line Details Page
Click the Detail link for a delivery line in the search results table of the Search Details page.
The Line Detail page appears.
From the Actions menu, select Carrier Address Validation.
Click Go.
The Carrier Address Validation page appears displaying the address validation for the delivery line.
The top half of the page displays the results of the validation such as the number of address candidates and the accuracy of the validation.
The lower half of the page displays a ranking of matches from highest to lowest for the Ship From and Ship To addresses.
Click Done.
To View Carrier Address Validation for a Container Using the LPN Page
Click the Detail link for a container line in the search results table of the Search Details page.
The LPN page appears.
From the Actions menu, select Carrier Address Validation.
Click Go.
The Carrier Address Validation page appears displaying the address validation for the container.
The top half of the page displays the results of the validation such as the number of address candidates and the accuracy of the validation.
The lower half of the page displays a ranking of matches from highest to lowest for the Ship From and Ship To addresses.
Click Done.