Search Results wms_lpn_contents_interface

Overview

WMS_LPN_CONTENTS_INTERFACE is an open interface table in the Warehouse Management (WMS) module of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It serves as a staging and preprocessing area for License Plate Number (LPN) contents associated with Advanced Shipment Notices (ASNs). Records are populated by external systems, suppliers, or upstream Oracle processes prior to validation and ingestion by the WMS inbound receiving flow, where LPN contents are ultimately materialized into the operational WMS tables. The table is owned by the WMS schema and is documented with 110 columns in ETRM 12.2.2.

Under a heuristic Data Vault classification, this object is satellite-leaning. It behaves as a descriptive, transactional staging record that hangs off a driving receiving transaction, holding the descriptive detail of LPN contents rather than acting as an independent hub or a pure associative link. Modelers should treat it as a satellite attached to the receiving transaction hub/link.

Key Information Stored

The table holds inbound LPN content detail plus extensive descriptive and flexfield attributes. The most significant columns include:

INTERFACE_TRANSACTION_ID — The pivot identifier linking each LPN content row to its parent receiving transaction in RCV_TRANSACTIONS_INTERFACE; it is the documented foreign key and the principal business-key candidate for joining inbound data.
LICENSE_PLATE_NUMBER — The LPN being described, identifying the plate or container whose contents are staged.
GROUP_ID — Groups a batch of interface rows submitted by a single run for coordinated processing.
ITEM_NUM, ITEM_DESCRIPTION, ITEM_REVISION, VENDOR_ITEM_NUM — Item identification and revision carried on the shipment.
QUANTITY, UOM_CODE — The received quantity and unit of measure for the LPN content.
LOT_NUMBER, SUPPLIER_LOT_NUMBER, EXPIRATION_DATE — Lot and shelf-life control attributes.
FROM_SERIAL_NUMBER, TO_SERIAL_NUMBER, SERIAL_TRANSACTION_INTF_ID — Serial number ranges and the serial transaction interface reference.
DOCUMENT_NUM, DOCUMENT_LINE_NUM, SHIPMENT_NUM, SHIP_TO_ORGANIZATION_CODE — Source ASN document, line, shipment, and destination organization context.
STATUS_ID, STATUS_NAME — Processing status of the interface row.
Standard who-columns (LAST_UPDATE_DATE, CREATED_BY, REQUEST_ID, PROGRAM_ID) and the flexfield groups (ATTRIBUTE1–15, C_ATTRIBUTE1–20, D_ATTRIBUTE1–10, N_ATTRIBUTE1–10, LOT_ATTRIBUTE_CATEGORY).

No surrogate single-column primary key is documented; the interface transaction identifier and LPN number function as the practical business keys used to correlate staged rows with their receiving transaction.

Common Use Cases and Queries

Typical scenarios include validating and reconciling inbound LPNs before they are consumed by the WMS receiving process, troubleshooting rejected or stuck interface rows, and reporting on ASN LPN contents. A representative query joins the interface to its parent receiving transaction:

SELECT i.LICENSE_PLATE_NUMBER, i.ITEM_NUM, i.QUANTITY, i.UOM_CODE, r.TRANSACTION_ID FROM WMS.WMS_LPN_CONTENTS_INTERFACE i, RCV.RCV_TRANSACTIONS_INTERFACE r WHERE i.INTERFACE_TRANSACTION_ID = r.INTERFACE_TRANSACTION_ID;
Filter by STATUS_ID or STATUS_NAME to isolate rows pending processing.
Group by GROUP_ID and REQUEST_ID to audit a specific submission run.
Reconcile LOT_NUMBER, SERIAL ranges, and quantities against the ASN for exception reporting.

Related Objects

RCV_TRANSACTIONS_INTERFACE — Referenced via WMS_LPN_CONTENTS_INTERFACE.INTERFACE_TRANSACTION_ID; the primary parent driving inbound transactions.
RCV_SERIAL_TRANSACTIONS_INTERFACE — Related through SERIAL_TRANSACTION_INTF_ID for serialized content.
WMS_LPN_CONTENTS — The operational target table where validated LPN contents are ultimately stored.
WMS_LICENSES / WMS_LPN_HU_RELATIONSHIPS — LPN master and hierarchy tables resolving the LICENSE_PLATE_NUMBER.
INV_ITEM_MASTER (MTL_SYSTEM_ITEMS_B) — Source of ITEM_NUM, revision, and UOM validation.
WMS inbound receiving concurrent programs — Processes that read, validate, and consume this interface table.

Table: WMS_LPN_CONTENTS_INTERFACE 12.1.1
owner:WMS, object_type:TABLE, fnd_design_data:WMS.WMS_LPN_CONTENTS_INTERFACE, object_name:WMS_LPN_CONTENTS_INTERFACE, status:VALID, product: WMS - Warehouse Management , description: Open interface table for preprocessing LPNs shipped with ASN , implementation_dba_data: WMS.WMS_LPN_CONTENTS_INTERFACE ,
Table: WMS_LPN_CONTENTS_INTERFACE 12.2.2
owner:WMS, object_type:TABLE, fnd_design_data:WMS.WMS_LPN_CONTENTS_INTERFACE, object_name:WMS_LPN_CONTENTS_INTERFACE, status:VALID, product: WMS - Warehouse Management , description: Open interface table for preprocessing LPNs shipped with ASN , implementation_dba_data: WMS.WMS_LPN_CONTENTS_INTERFACE ,
SYNONYM: APPS.WMS_LPN_CONTENTS_INTERFACE 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WMS_LPN_CONTENTS_INTERFACE, status:VALID,
PACKAGE: APPS.WMS_ASN_INTERFACE 12.2.2
APPS.WMS_ASN_INTERFACE SQL Statements 12.1.1
SYNONYM: APPS.WMS_LPN_CONTENTS_INTERFACE 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WMS_LPN_CONTENTS_INTERFACE, status:VALID,
APPS.WMS_ASN_INTERFACE SQL Statements 12.2.2
PACKAGE: APPS.WMS_ASN_INTERFACE 12.1.1
PACKAGE BODY: APPS.WMS_ASN_INTERFACE 12.1.1
VIEW: WMS.WMS_LPN_CONTENTS_INTERFACE# 12.2.2
owner:WMS, object_type:VIEW, object_name:WMS_LPN_CONTENTS_INTERFACE#, status:VALID,
Table: RCV_TRANSACTIONS_INTERFACE 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_TRANSACTIONS_INTERFACE, object_name:RCV_TRANSACTIONS_INTERFACE, status:VALID, product: PO - Purchasing , description: Receiving transactions interface table , implementation_dba_data: PO.RCV_TRANSACTIONS_INTERFACE ,
PACKAGE BODY: APPS.WMS_ASN_INTERFACE 12.2.2
PACKAGE BODY: APPS.WMS_ASN_LOT_ATT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_ASN_LOT_ATT, status:VALID,
PACKAGE BODY: APPS.WMS_ASN_LOT_ATT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_ASN_LOT_ATT, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 FND Design Data 12.1.1
PACKAGE BODY: APPS.RCV_NORMALIZE_DATA_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:RCV_NORMALIZE_DATA_PKG, status:VALID,
PACKAGE BODY: APPS.RCV_NORMALIZE_DATA_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:RCV_NORMALIZE_DATA_PKG, status:VALID,
PACKAGE BODY: APPS.WMS_ASN_INTERFACE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_ASN_INTERFACE, status:VALID,
Table: RCV_TRANSACTIONS_INTERFACE 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_TRANSACTIONS_INTERFACE, object_name:RCV_TRANSACTIONS_INTERFACE, status:VALID, product: PO - Purchasing , description: Receiving transactions interface table , implementation_dba_data: PO.RCV_TRANSACTIONS_INTERFACE ,
PACKAGE BODY: APPS.WMS_ASN_INTERFACE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_ASN_INTERFACE, status:VALID,
12.2.2 DBA Data 12.2.2
VIEW: WMS.WMS_LPN_CONTENTS_INTERFACE# 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 FND Design Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
APPS.RCV_NORMALIZE_DATA_PKG SQL Statements 12.2.2
PACKAGE BODY: APPS.INV_RCV_INTEGRATION_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_INTEGRATION_PVT, status:VALID,
PACKAGE BODY: APPS.INV_RCV_INTEGRATION_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_INTEGRATION_PVT, status:VALID,
APPS.RCV_NORMALIZE_DATA_PKG SQL Statements 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.WMS_ASN_LOT_ATT 12.2.2
PACKAGE: APPS.WMS_ASN_LOT_ATT 12.1.1
TABLE: WMS.WMS_LPN_CONTENTS_INTERFACE 12.2.2
owner:WMS, object_type:TABLE, fnd_design_data:WMS.WMS_LPN_CONTENTS_INTERFACE, object_name:WMS_LPN_CONTENTS_INTERFACE, status:VALID,
TABLE: WMS.WMS_LPN_CONTENTS_INTERFACE 12.1.1
owner:WMS, object_type:TABLE, fnd_design_data:WMS.WMS_LPN_CONTENTS_INTERFACE, object_name:WMS_LPN_CONTENTS_INTERFACE, status:VALID,
PACKAGE BODY: APPS.RCV_NORMALIZE_DATA_PKG 12.1.1
PACKAGE BODY: APPS.RCV_NORMALIZE_DATA_PKG 12.2.2
APPS.WMS_ASN_LOT_ATT dependencies on WMS_LPN_CONTENTS_INTERFACE 12.2.2
APPS.RCV_NORMALIZE_DATA_PKG dependencies on WMS_LPN_CONTENTS_INTERFACE 12.2.2
APPS.WMS_ASN_INTERFACE dependencies on WMS_LPN_CONTENTS_INTERFACE 12.2.2
APPS.INV_RCV_INTEGRATION_PVT dependencies on WMS_LPN_CONTENTS_INTERFACE 12.2.2
APPS.WMS_ASN_LOT_ATT dependencies on WMS_LPN_CONTENTS_INTERFACE 12.1.1
APPS.RCV_NORMALIZE_DATA_PKG dependencies on WMS_LPN_CONTENTS_INTERFACE 12.1.1
APPS.INV_RCV_INTEGRATION_PVT dependencies on WMS_LPN_CONTENTS_INTERFACE 12.1.1
APPS.WMS_ASN_INTERFACE dependencies on WMS_LPN_CONTENTS_INTERFACE 12.1.1
APPS.WMS_ASN_LOT_ATT SQL Statements 12.1.1
APPS.WMS_ASN_LOT_ATT SQL Statements 12.2.2