Search Results from_serial_number




Overview
Explore in AI Chat

Overview

APPS.SERIAL_CHECK is a PL/SQL package body in the Oracle E-Business Suite Inventory module that governs serial number reservation and de-reservation logic during inventory transactions. Its central business function is to mark serial numbers as reserved against a transaction header and item/organization context, and to reverse those markings when a transaction is cancelled or reworked. The package was reworked as part of the Release 12 "Enhanced Reservations" initiative, which introduced explicit reservation identifiers on serial number records. This is why the source header comment references the "$Header: INVMKUMB.pls 120.7" change history and the inline markers reading "{{ R12 Enhanced reservations code changes." The package is classified as OTHER in the API taxonomy, meaning it is an internal support package rather than a public, user-facing API, though it is referenced by twelve other packages within the EBS codebase and therefore sits on a shared dependency path.

Key Procedures and Functions

The package exposes five documented procedures, providing a symmetric pair of mark and unmark operations with reservation-aware overloads:

  • INV_MARK_SERIAL — The legacy entry point. It accepts a serial range and transaction context and delegates to the reservation-aware overload, passing a null reservation identifier and suppressing any reservation update. This preserves backward compatibility for callers that predate enhanced reservations.
  • INV_MARK_RSV_SERIAL — The overloaded procedure that accepts a reservation identifier in addition to the serial, item, organization, header, and temporary table parameters. It performs the actual serial marking and is the core routine invoked by INV_MARK_SERIAL.
  • INV_UNMARK_SERIAL — The counterpart to INV_MARK_SERIAL, releasing previously applied serial markings without reservation context.
  • INV_UNMARK_RSV_SERIAL — The reservation-aware unmark counterpart, releasing serials tied to a specific reservation identifier.
  • INV_UPDATE_MARKED_SERIAL — Refreshes or reconciles the marking state of serial numbers already recorded, used when the transaction context changes after the initial mark.

Each routine reports outcome through a success OUT parameter; an unhandled exception in INV_MARK_SERIAL sets success to -3. Debug tracing is controlled by the INV_DEBUG_TRACE profile option and emitted through INV_LOG_UTIL.TRACE.

Tables Accessed

The package operates against four documented tables accessed through APPS synonyms:

  • MTL_SERIAL_NUMBERS — The primary target. Serial number rows are marked and unmarked here, and the reservation identifier column added in R12 is populated by the reservation-aware overloads.
  • MTL_RESERVATIONS — Consulted and updated to maintain consistency between the reservation record and the serials it covers.
  • MTL_TRANSACTION_LOTS_TEMP — The temporary transaction table that holds lot and serial detail pending transaction processing; markings must align with these temporary records before the transaction commits.
  • PLITBLM — The standard EBS PL/SQL index-by table type used for passing collections of identifiers in and out of the marking routines.

Usage Notes

SERIAL_CHECK is not intended for direct invocation by end users. It is called programmatically by other Inventory packages, forms, and transaction processors whenever serial-controlled material is reserved, picked, shipped, or returned. Customizations that manipulate serial reservations should invoke the reservation-aware procedures rather than the legacy INV_MARK_SERIAL where a reservation identifier is available, to keep MTL_RESERVATIONS and MTL_SERIAL_NUMBERS synchronized. Because twelve packages reference SERIAL_CHECK, changes to its behavior carry broad impact. Debug output is available by setting INV_DEBUG_TRACE at the user or site level, which routes trace messages through INV_LOG_UTIL; this is the preferred diagnostic path when serial marking fails silently during a transaction.