How to: Query and Derive Shipping Method Including Carrier, Mode of Transport and Service Level Components

(Doc ID 2251504.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Shipping - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

This note describes how to identify all Shipping Method reference data and how to then derive the cross reference values that can be used when:

1. Creating Transformation Rules
2. Populating Carrier ID, Mode of Transport and Service Level in Order creation payloads and import spreadsheets.

SQL is provided to show the ship method defined on fulfillment and shipping records. The SQL can be used to describe the Shipping Method information shown on the Order Entry UI.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms