Search Results wms_asn_interface




Overview
Explore in AI Chat

Overview

The APPS.WMS_ASN_INTERFACE package is a Warehouse Management System (WMS) utility within Oracle E-Business Suite that supports the processing of Advanced Shipment Notice (ASN) data into the warehouse execution layer. Its role is to translate inbound ASN information received through the receiving and logistics modules into the LPN (License Plate Number) and material transaction structures used by Oracle Warehouse Management. In releases 12.1.1 and 12.2.2 this package acts as the integration bridge between the Receiving open interface and WMS-managed inventory operations, ensuring that inbound shipments can be received, license plates built, and inventory staged correctly.

The package is classified as OTHER under the ETRM API classification scheme and holds a VALID status in the APPS schema. It is a documented dependency of core receiving objects, indicating that it is embedded in the standard receiving transaction flow rather than being a standalone callable API.

Key Procedures and Functions

The ETRM metadata documents a single public procedure for this package:

  • PROCESS — The main entry point that drives the processing of ASN-related interface data. It orchestrates the validation, transformation, and insertion of inbound shipment information into the appropriate WMS and receiving interface tables. It is the mechanism by which ASN records are consumed and converted into license plate and transaction records used downstream.

The internal implementation may include additional private helper routines, but only PROCESS is documented. Consultants should treat the package as a single-purpose processing engine rather than a library of individually callable APIs.

Tables Accessed

The package reads and writes the following documented objects, referenced through APPS synonyms:

  • WMS_LPN_CONTENTS_INTERFACE — The primary staging table for LPN content records awaiting validation and insertion; the package writes inbound LPN content detail here.
  • WMS_LPN_CONTENTS — The base LPN contents table into which validated records are ultimately created.
  • WMS_LICENSE_PLATE_NUMBERS — Stores LPN definitions and attributes used to confirm plate identity during processing.
  • MTL_MATERIAL_TRANSACTIONS_TEMP — Holds material transaction records pending processing, linking ASN receipt activity to inventory transactions.
  • MTL_SERIAL_NUMBERS — Provides serial number validation for serial-controlled items in the shipment.
  • MTL_SYSTEM_ITEMS — Supplies item attribute data such as WMS-control flags, lot and serial control, and unit of measure.
  • MTL_UNITS_OF_MEASURE — Used for quantity and UOM conversion validation.
  • RCV_TRANSACTIONS_INTERFACE — The Receiving open interface table where ASN receipt transactions are staged for downstream receipt processing.
  • DUAL and PLITBLM — Utility objects used for single-row selection and PL/SQL table (array) manipulation.

Usage Notes

WMS_ASN_INTERFACE is not typically invoked directly by end users. It is referenced by RCV_ASN_TRX_INSERT and RCV_ROI_TRANSACTION, meaning it is called automatically as part of the standard Receiving transaction and ASN processing flow. It may also be referenced recursively within its own package body.

Because the package operates on interface and temporary tables, it is most relevant when troubleshooting inbound ASN failures, LPN build errors, or mismatches between received shipments and expected shipment notices. Receiving and WMS administrators may also invoke it indirectly through concurrent programs that process the Receiving open interface. Customizations that write to WMS_LPN_CONTENTS_INTERFACE or RCV_TRANSACTIONS_INTERFACE should preserve the record formats this package expects, since it performs validation against item, serial, and unit-of-measure master data before committing LPN contents. Any modification to these interface tables must account for the package's processing assumptions to avoid rejected or orphaned records.