Download Oracle Warehouse Management Implementation Guide

Overview
License Plate Data (Line Detail)
LICENSE_PLATE_NUMBER
This column identifies the License Plate Number that identifies the container for
this line of material. To be successfully processed, this number must be a new LPN
number, not previously defined in Oracle WMS. If the number already exists, WMS
import will fail and the ASN will be processed without LPN data. In that case, a
Confirmed Receipt must be performed. One ASN can be packed in to more than one
LPN. But one LPN cannot contain more than one ASN.
LOT_NUMBER
This column identifies the lot number of the material shipped. If this number
violates the lot uniqueness constraints, WMS import will fail and a Confirmed
Receipt must be performed. Note that lot expiration date is not sent with the ASN.
If the lot expiration date for the item is shelf life based, the lot expiration date will
be the current date/time of importing, incremented by the shelf life days. If the lot
expiration date is pre-defined, the current date/time of importing will be used as
the expiration date. You need to modify the lot expiration date through the Lot
Number Maintenance form after a receipt has been performed against this ASN.
The above discussion about the lot expiration date only applies to a new lot
number.
FROM_SERIAL_NUMBER, TO_SERIAL_NUMBER
The two columns identify the serial numbers shipped. If the serial numbers violate
the serial uniqueness constraints, WMS import will fail and a Confirmed Receipt
must be performed.
QUANTITY
This column represents the quantity of material packed on this LPN. It is possible
for more than one line detail record to exist for one interface transaction record. The
total quantity of the line detail records that belong to one interface transaction line
record has to match the quantity of that interface transaction line record. If the
quantity does not match, WMS import will fail and a Confirmed Receipt must be
performed. Detail of the quantity relationship will be presented below in an
example.
Oracle EDI Inbound ASN Enhancement for WMS
22-3