Search Results get_attr_value_tbl

Overview

APPS.OE_LOT_SERIAL_ATTR is a public PL/SQL package in the Oracle E-Business Suite Order Management (OE) module. Its name and the header comment (OEXASRLS.pls, version 120.0, dated 2005) indicate that it supports lot and serial number attribute handling within the order entry and order fulfillment flow. In EBS, lot-controlled and serial-controlled inventory items require the capture of attribute values that describe each lot or serial number instance — for example, lot attributes such as expiration date, grade, or country of origin, and serial attributes such as revision or status.

The package is classified as an OTHER API in the ETRM registry, meaning it is not a general-purpose business API but a supporting utility used internally by the Order Management application and its dependencies. It operates against the same lot/serial attribute infrastructure used by Oracle Inventory, ensuring that attribute values collected during order entry or shipping remain consistent with the values stored in the inventory item definition.

Key Procedures and Functions

The package exposes exactly two documented procedures, both of which are declared without parameters in the package specification and are therefore invoked as standalone calls. They operate in a paired fashion, reflecting a two-step pattern in which the first procedure prepares or resolves the applicable attribute structure and the second retrieves the corresponding values.

• Get_Attr_Tbl — Resolves and populates the internal table of lot/serial attribute definitions for the current processing context. This establishes which attributes are relevant, their descriptive labels, and the ordering in which they should be presented or processed. It is the prerequisite call before value retrieval.
• Get_Attr_Value_Tbl — Populates the table of attribute values corresponding to the attribute definitions prepared by Get_Attr_Tbl. This is the procedure implicated by the search term "get_attr_value_tbl." It is the value-retrieval step, returning the actual stored lot or serial attribute data for the active lot/serial context.

Both procedures follow a public global-variable or package-state pattern typical of older EBS 11i-era code: rather than accepting and returning parameters, they populate package-level PL/SQL tables that callers read after invocation. This design predates the more structured APIs introduced in later releases.

Tables Accessed

The ETRM metadata lists no directly referenced tables accessed through APPS synonyms, and no other packages are documented as referencing this package. Historically, lot and serial attribute definitions and values are held in Inventory tables such as MTL_LOT_NUMBERS, MTL_SERIAL_NUMBERS, and the lot/serial attribute interface and descriptive-flexfield structures. The package functions as a query and assembly layer over those structures, providing the Order Management application with the attribute definitions and attribute values it needs at the point of order entry, pick release, or shipment confirmation. Because the metadata does not enumerate specific tables, integrators should not assume a fixed table contract; the package should be treated as an internal read helper.

Usage Notes

OE_LOT_SERIAL_ATTR is not intended for direct customer invocation. It is invoked internally by Order Management forms and concurrent programs when lot-controlled or serial-controlled items are processed, and it may be called by other Oracle application code that needs the current lot/serial attribute set. Because it relies on package state and has no defined parameter interface or documented return contract, custom code should avoid calling it directly. Developers requiring lot/serial attribute data should use the supported Inventory lot and serial APIs or query the underlying tables instead. The package is present in both 12.1.1 and 12.2.2 with no documented behavior change; the OEXASRLS.pls header reflects a long-standing, stable implementation.