My Oracle Support Banner

FA: SCM: OM: SQL Query To Identify Shipment Number And Fulfill Line Number For Split Sales Orders? (Doc ID 2659731.1)

Last updated on NOVEMBER 29, 2023

Applies to:

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

Goal

How to Identify the Sales Order, Line Number, Fulfill Line Number and Shipment Number for split sales orders through query?

For e.g. Sales Order #SO1 with one Single Line 1 - Quantity 100. And It was split into 4 lines and 3 shipments created for 3 lines (1.1, 1.2 and 1.3) and fourth lines back ordered.
In this scenario, all 3 shipments have same source number 1. So, how to identify which shipment is for which line number?

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


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