My Oracle Support Banner

FA: SCM: OM: SQL QUERY: Query and Derive Ship Method Including Carrier, Mode of Transport and Service Level Components (Doc ID 2251504.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

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


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

1. Creating Transformation Rules
2. Order Management Extensions
3. 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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.