Examples for Deriving Supply Information for Transfer Orders from Sales Order Fulfillment Lines During Collections

This topic provides examples of how supply information is derived for transfer orders from sales order fulfillment lines during collections from an Oracle Fusion source system.

Example 1: Scheduled Ship Date Is Different from Requested Ship Date

In this example, the scheduled ship date is different from the requested ship date for the sales order fulfillment line that's created by Oracle Order Management for a transfer order in Oracle Inventory Management. After the collections, the ship date, dock date, and due date are updated for the collected transfer order. The in-transit lead time is 2 days.

This table provides information for the transfer order in Inventory Management:

Item Header Line Quantity Expected Delivery Date Source Organization Destination Organization Shipping Method
AS7311 TO1 1 10 Day 10 M2 M1 ABC-2Day

This table provides information for the sales order fulfillment line in Order Management:

Item Sales Order Line Quantity Fulfillment Line Shipping Warehouse Requested Ship Date Scheduled Ship Date Shipping Method
AS7311 SO1 1 10 1 M2 Day 8 Day 12 ABC-2Day

The requested ship date is Day 8, but the scheduled ship date is Day 12.

This table provides the details of the collected transfer order and sales order fulfillment line in Oracle Fusion Cloud Supply Chain Planning:

Item Organization Source Organization Order Type Order Number Line Fulfillment Line Due Date Dock Date Ship Date Quantity Shipping Method
AS7311 M1 M2 Transfer order TO1 1.1 NA Day 14 Day 14 Day 12 10 ABC-2Day
AS7311 M2 NA Sales order SO1 1 1 Day 12 NA NA –10 ABC-2Day

The due date and dock date for the collected transfer order have been adjusted after allowing for the 2-day shipping method to reflect the changed scheduled ship date of Day 12 for the sales order fulfillment line in Order Management.

Example 2: Shipping Method Changed in Sales Order

In this example, the shipping method is different in the sales order fulfillment line that's created by Order Management for a transfer order in Inventory Management. After the collections, the ship date, dock date, and due date are updated for the collected transfer order. The in-transit lead time is 2 days for the transfer order and 3 days for the sales order fulfillment line.

This table provides information for the transfer order in Inventory Management:

Item Header Line Quantity Expected Delivery Date Source Organization Destination Organization Shipping Method
AS7312 TO1 1 10 Day 10 M2 M1 ABC-2Day

This table provides information for the sales order fulfillment line in Order Management:

Item Sales Order Line Quantity Fulfillment Line Shipping Warehouse Requested Ship Date Scheduled Ship Date Shipping Method
AS7312 SO1 1 10 1 M2 Day 8 Day 13 DEF-3Day

The requested ship date is Day 8, but the scheduled ship date is Day 13. The shipping method has been changed from ABC-2Day to DEF-3Day.

This table provides the details of the collected transfer order and sales order fulfillment line in Oracle Supply Chain Planning:

Item Organization Source Organization Order Type Order Number Line Fulfillment Line Due Date Dock Date Ship Date Quantity Shipping Method
AS7312 M1 M2 Transfer order TO1 1.1 NA Day 16 Day 16 Day 13 10 DEF-3Day
AS7312 M2 NA Sales order SO1 1 1 Day 13 NA NA –10 DEF-3Day

The shipping method has been changed for the collected transfer order. The due date and dock date for the collected transfer order have been adjusted after allowing for the 3-day shipping method to reflect the changed scheduled ship date of Day 13 for the sales order fulfillment line in Order Management.

Example 3: Sales Order Fulfillment Lines Are Split

In this example, for a transfer order in Inventory Management, separate sales order fulfillment lines with different scheduled ship dates are created in Order Management. After the collections, three transfer orders are collected that align with each open sales order fulfillment line. The ship dates, dock dates, and due dates are updated for the collected transfer orders. The in-transit lead time is 2 days.

This table provides information for the transfer order in Inventory Management:

Item Header Line Quantity Expected Delivery Date Source Organization Destination Organization Shipping Method Requested Quantity
AS7313 TO1 1 10 Day 10 M2 M1 ABC-2Day 10

This table provides information for the sales order fulfillment lines in Order Management:

Item Sales Order Line Quantity Fulfillment Line Shipping Warehouse Requested Ship Date Scheduled Ship Date Shipping Method Status
AS7313 SO1 1 3 1 M2 Day 8 Day 12 ABC-2Day Awaiting Shipping
AS7313 SO1 1 5 2 M2 Day 8 Day 16 ABC-2Day Awaiting Shipping
AS7313 SO1 1 2 3 M2 Day 8 Day 18 ABC-2Day Awaiting Shipping

The requested ship date is Day 8, but the scheduled ship dates are Day 12, Day 16, and Day 18.

This table provides the details of the collected transfer orders and sales order fulfillment lines in Oracle Supply Chain Planning:

Item Organization Source Organization Order Type Order Number Line Fulfillment Line Due Date Dock Date Ship Date Quantity Shipping Method
AS7313 M1 M2 Transfer order TO1 1.1 NA Day 14 Day 14 Day 12 3 ABC-2Day
AS7313 M1 M2 Transfer order TO1 1.2 NA Day 18 Day 18 Day 16 5 ABC-2Day
AS7313 M1 M2 Transfer order TO1 1.3 NA Day 20 Day 20 Day 18 2 ABC-2Day
AS7313 M2 NA Sales order SO1 1 1 Day 12 NA NA –3 ABC-2Day
AS7313 M2 NA Sales order SO1 1 2 Day 16 NA NA –5 ABC-2Day
AS7313 M2 NA Sales order SO1 1 3 Day 18 NA NA –2 ABC-2Day

The due dates and dock dates for the collected transfer orders have been adjusted after allowing for the 2-day shipping method to reflect the changed scheduled ship dates of Day 12, Day 16, and Day 18 for the sales order fulfillment lines in Order Management.

Example 4: Sales Order Fulfillment Line Is Partially Shipped

In this example, the sales order fulfillment line that's created by Order Management for a transfer order in Inventory Management is partially shipped. After the partial shipment, two sales order fulfillment lines are created, one for the shipped units and the other for the units that are awaiting shipment. After the collections, the ship dates, dock dates, and due dates are updated for the collected transfer orders. The in-transit lead time is 2 days.

This table provides information for the transfer order in Inventory Management:

Item Header Line Quantity Expected Delivery Date Source Organization Destination Organization Shipping Method
AS714 TO1 1 10 Day 10 M2 M1 ABC-2Day

This table provides information for the sales order fulfillment line in Order Management:

Item Sales Order Line Quantity Fulfillment Line Shipping Warehouse Requested Ship Date Scheduled Ship Date Shipping Method
AS7314 SO1 1 10 1 M2 Day 8 Day 12 ABC-2Day

The requested ship date is Day 8, but the scheduled ship date is Day 12.

This table provides the details of the transfer order after the partial shipment:

Item Header Line Quantity Expected Delivery Date Source Organization Destination Organization Shipping Method Requested Quantity Shipped Quantity
AS714 TO1 1 10 Day 10 M2 M1 ABC-2Day 10 4

This table provides information for the sales order fulfillment lines in Order Management after the partial shipment:

Item Sales Order Line Quantity Fulfillment Line Shipping Warehouse Requested Ship Date Scheduled Ship Date Shipping Method Status
AS7314 SO1 1 4 1 M2 Day 8 Day 12 ABC-2Day Shipped
AS7314 SO1 1 6 2 M2 Day 8 Day 16 ABC-2Day Awaiting Shipping

For the sales order fulfillment line that's awaiting shipping, the requested ship date is Day 8, but the scheduled ship date is Day 16.

This table provides the details of the collected transfer orders and sales order fulfillment lines in Oracle Supply Chain Planning:

Item Organization Source Organization Order Type Order Number Line Fulfillment Line Due Date Dock Date Ship Date Quantity Completed Quantity Shipping Method
AS7314 M1 M2 Transfer order TO1 1.2 NA Day 18 Day 18 Day 16 6 NA ABC-2Day
AS7314 M1 M2 In-Transit Shipment TO1 1 NA Day 14 Day 14 Day 12 4 NA ABC-2Day
AS7314 M2 NA Sales order SO1 1 1 Day 12 NA NA 0 4 ABC-2Day
AS7314 M2 NA Sales order SO1 1 2 Day 16 NA NA –6 NA ABC-2Day

The due dates and dock dates for the collected transfer orders have been adjusted after allowing for the 2-day shipping method to reflect the changed scheduled ship dates of Day 12 and Day 16 for the sales order fulfillment lines in Order Management.