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 220.127.116.11.0 and later
Oracle Fusion Shipping - Version 18.104.22.168.0 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