Search Results lot_sel_attributes_rec_type

Overview

The APPS.WMS_ASN_LOT_ATT package is a Warehouse Management System (WMS) API component within Oracle E-Business Suite, documented as VALID in the APPS schema for releases 12.1.1 and 12.2.2. Its ETRM classification is OTHER, indicating it is an internal utility package rather than a public, outbound-facing API with a formal FND_API error-handling contract. The package supports Advance Shipment Notice (ASN) processing by managing lot and serial attribute validation for inbound receiving transactions. Specifically, it validates lot number attributes against flexfield context definitions and inserts serial number ranges associated with ASN receipt lines. In this role it acts as a supporting component of the inbound logistics data flow, ensuring that lot-controlled and serial-controlled items are correctly identified and that their descriptive flexfield attributes conform to the item's configured lot/serial flexfield structure before they are written to the receiving interface tables.

Key Procedures and Functions

ETRM documents two callable units within the package:

• VALIDATE_LOT — Validates a lot number supplied during ASN processing. It verifies the lot number against existing lot records and checks the associated lot attribute flexfield values against the applicable flexfield context. This ensures that a receiving transaction does not create or reference an invalid or non-conforming lot definition, and that any descriptive flexfield attributes assigned to the lot are consistent with the item's configured lot flexfield context.
• INSERT_RANGE_SERIAL — Inserts a range of serial numbers into the serial number interface structures used during ASN receipt. It supports the bulk expansion of serial-controlled quantities into individual serial number records so that subsequent receiving processing can consume discrete serial rows rather than a summarized quantity.

The metadata does not expose parameter lists for these units; callers should not assume signatures and should reference the shipped package specification in the target instance before invoking them.

Tables Accessed

The package reads and writes the following documented tables:

• MTL_LOT_NUMBERS — Source of existing lot definitions; used by VALIDATE_LOT to confirm lot existence and retrieve lot attributes.
• MTL_FLEX_CONTEXT — Provides the descriptive flexfield context definitions used to validate lot attribute values.
• MTL_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS_INTERFACE — Serial number master and interface tables populated by INSERT_RANGE_SERIAL.
• MTL_SYSTEM_ITEMS — Item definitions, used to determine lot/serial control attributes for the item under receipt.
• MTL_PARAMETERS — Organization-level inventory parameters used for context during validation and insertion.
• MTL_GEN_OBJECT_ID_S — Sequence used to generate object identifiers for inserted interface records.
• RCV_TRANSACTIONS_INTERFACE — Receiving interface table linked to the ASN transaction being processed.
• WMS_LPN_CONTENTS_INTERFACE — LPN (license plate number) contents interface for ASN receipt lines.
• DUAL and PLITBLM — Utility structures used for PL/SQL expression evaluation.

Usage Notes

WMS_ASN_LOT_ATT is not intended for direct end-user invocation. It is referenced by APPS.WMS_ASN_INTERFACE and by itself, and it depends on FND_API, FND_DESCR_FLEX_COL_USAGE_VL, and MTL_LOT_NUMBERS. It is therefore invoked indirectly when ASN receipt data is processed through the WMS inbound logistics pipeline, typically via receiving or ASN concurrent programs and the interface table processing flow. Because it directly manipulates interface tables, customizations that modify its behavior must be treated with caution; any change affects the standard ASN lot and serial validation performed at receipt. Sites implementing extensions should call the package only through its documented parent interfaces, and should verify the package specification in the specific EBS instance before relying on procedure names or behavior.