My Oracle Support Banner

Oracle WMS Shipping Question (Doc ID 2677155.1)

Last updated on JUNE 09, 2020

Applies to:

Oracle Shipping Execution - Version 12.2.4 and later
Information in this document applies to any platform.


Please consider below scenario:

Sales order is created in Oracle Order Management having 3 items, so OE_ORDER_LINES_ALL table have 3 lines for this order. After processing the Order in Oracle WMS, once LPNs are created and loaded on to trucks, delivery ID is for the order and related delivery information is inserted into corresponding WSH tables. Entries in various WSH tables for this delivery id would have Container (LPN) related information in addition to the 3 items on Sales Order. It is also observed that there is a parent- child relation between LPN and items.


1. is there a way to publish delivery details related to items on Sales Order to WSH tables and not the Container information?
2. Is there a separate place that could be used to hold Container information?


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

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