Search Results inv_detail_util_pvt




Overview
Explore in AI Chat

Overview

INV_DETAIL_SERIAL_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Inventory Management serial number infrastructure, and its classification as a PUB (public) API indicates that Oracle supports its direct invocation from custom code, unlike private (PVT) packages such as INV_DETAIL_UTIL_PVT, which are intended solely for internal consumer use and are not guaranteed to remain stable across patch levels.

The package exposes serial number retrieval logic used when processing inventory transactions at the detail level. In EBS serial-controlled items, each unit of material processed by a transaction — a receipt, issue, transfer, or move order — carries one or more serial numbers, and the transaction detail layer must be able to resolve the serial numbers associated with a given detail record. INV_DETAIL_SERIAL_PUB provides that resolution capability through a supported, published interface. This is significant because the underlying serial data resides in INV_SERIAL_NUMBERS and related inventory tables whose physical schema is not a public contract; the PUB wrapper isolates dependents from that volatility.

Key Procedures and Functions

  • GET_USER_SERIAL_NUMBERS — The single documented program unit exposed by this package. It is the public entry point through which callers obtain the serial numbers associated with a transaction detail record. The name indicates that it returns user-entered serial numbers, distinguishing those values supplied explicitly by the user (or by an external integration) from serial numbers defaulted or generated by the system through the serial number generation rules defined for the item. Callers receive a collection of serial number values for further processing — validation, display, or persistence in a downstream table.

No other procedures or functions are documented in the ETRM metadata for this package. Parameter lists are intentionally not reproduced here; implementers should reference the package specification in the target instance directly.

Tables Accessed

The documented dependency set shows INV_DETAIL_SERIAL_PUB referencing INV_DETAIL_UTIL_PVT, which is the private utility layer that performs the actual table access. Through that dependency the package indirectly reads serial number and transaction detail data. Notably, the ETRM metadata registers no direct APPS synonym table references for INV_DETAIL_SERIAL_PUB, confirming that table access is delegated rather than embedded. This layered design is typical of the inventory transaction APIs: a public façade, a private utility package containing the cursor and DML logic, and a common standards package (SYS.STANDARD) used for type definitions and exceptions. The package is referenced by INV_DETAIL_UTIL_PVT and WMS_RULE_PVT, indicating reuse by Warehouse Management System rule processing.

Usage Notes

INV_DETAIL_SERIAL_PUB is normally invoked in three contexts. First, during inventory transaction processing, where forms and the transaction interface call it to resolve and validate serial numbers attached to transaction lines. Second, from WMS_RULE_PVT, where warehouse management rules evaluate serial data as part of directed picking and put-away logic. Third, from custom PL/SQL integrations that must retrieve serial numbers for a transaction detail without accessing inventory tables directly.

Because the package is documented as VALID and classified PUB, Oracle's compatibility guidelines apply: the signature of GET_USER_SERIAL_NUMBERS and its semantics are maintained across the 12.1.1 and 12.2.2 releases. Custom code should call this package rather than INV_DETAIL_UTIL_PVT, which Oracle may change without notice. Developers searching for INV_DETAIL_UTIL_PVT are typically tracing a dependency chain originating here, and should treat the private package as an implementation detail — the supported customization point is INV_DETAIL_SERIAL_PUB.