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 MARCH 02, 2022

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 - 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.

Solution

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
Goal
Solution
References


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