My Oracle Support Banner

(WMS) Back To Back Sales Orders Consume Sales Order Reservations Randomly When Multiple Lines For The Same Item An Requirement Date After Advance Shipment Notice Is Created (Doc ID 3038736.1)

Last updated on AUGUST 06, 2024

Applies to:

Oracle Inventory Management - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

Back to Back Sales Order Reservation Issue when there are multiple lines for the same item with same dates.
 
STEPS
1- Order management > Orders > Sales orders > Create a Back to Back (B2B) Sales Order with 5 lines, all having the same item number "A1001", request date "22-FEB-2024", and total quantity of "1500". (100, 200, 300, 400, 500 on 5 lines)
2- Order entry > Lines > Actions > Progress line > Progress the B2B Sales Order lines. > Line status changes to 'External Req Requested'
3- Order Management > Requests > Run Requisition Import, resulting in a requisition created with 5 lines with total quantity "1500". (Requisition qty is aggregated to a single line as requirement is for the same item, supplier)
4- All sales order lines are reserved with supply type "External Requisition".
5- Purchasing > Purchase Orders > Create a Blanket Release with one line having a quantity of "1500".
6- Inventory > Reservations > Query for the Sales Order > See all sales order lines are reserved with supply type "Purchase Order".
7- iSupplier portal > Advance Shipment Notices > Create an ASN with partial quantity "350". (partial qty) > Approve > Run Receiving transaction processor > See ASN Created.
8- Inventory > Reservations > Query for the Sales Order > See Lines 1.1, 2.1, and 5.1 are reserved with supply type "Advanced Shipment Notice".
> User expects - The system should reserve Line Number 1.1, 2.1, 3.1 (partial) are reserved before Line Number 5.1.

Cause

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