My Oracle Support Banner

How To Prevent Split Lines From Scheduling In Random Order? (Doc ID 2813749.1)

Last updated on OCTOBER 11, 2021

Applies to:

Oracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

Lines schedule in random order. 

Very often when customer orders an item, it is not immediately known that there is only partial available quantity for the item ordered
This requires business to be able to schedule and ship the partial quantity on the same day the order was placed and split the line to schedule and ship the backordered quantity at a later date.

For example:
Item X has 160 quantity on hand, but the customer has ordered 200.
The order line imports and splits during order import.

Order line 1.1 will import for an ordered quantity of 160 which is available in inventory at the time the order is placed. 
Line 1.2 is created by splitting line 1.1 for a quantity of 40 which is not available at the time the order is placed, but will become available at a later date.


The problem is that when the order books, it does not schedule lines in order of the line number,  shipment number or line_id but instead appears to be scheduled in a completely random order.
Expectation is that line 1.1 for an ordered quantity of 160 EA would be scheduled for the day the order was placed and for this example, will use 25-May-21.
Expectation for line 1.2  for an ordered quantity of 40 EA which is NOT available would be scheduled on 03-JUN-21.

Instead lines are being scheduled as follows:

Line 1.1 for 160 EA is scheduled for 03-Jun-21. <<--qty available
Line 1.2 for  40 EA is scheduled for 25-May-21. <<--qty not available

This indicates that the lines are scheduled in random order and not according to the line number sequence or item availability.
How can lines be scheduled in the order they were placed?

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.