Search Results update_item_serial




Overview
Explore in AI Chat

Overview

APPS.INV_LOT_TRX_VALIDATION_PUB is a public PL/SQL API package in the Oracle Inventory (INV) module. Its purpose is to centralize the validation logic applied to lot, serial, and material status information before inventory transactions are executed or staged in the transaction interface tables. The package encapsulates the rules that determine whether a given lot number, serial number, material status, cost group, quantity, or set of descriptive attributes is valid for a specific organization, subinventory, and transaction context. By exposing these checks as public procedures, Oracle EBS allows transaction processing engines, mobile supply chain applications, warehouse management flows, and customer extensions to invoke the same validation rules used by the standard Inventory forms and concurrent managers. The header comment identifies the file as INVPLTVB.pls, and the package relies on g_pkg_name and profile option INV_DEBUG_TRACE for diagnostic tracing through inv_log_util. A private helper, print_debug, controls trace output based on the INV_DEBUG_TRACE profile. The get_org_info procedure demonstrates the package's coordination with inv_txn_validations and fnd_api to obtain WMS installation and enablement flags, returning FND_API.G_RET_STS_SUCCESS and using fnd_msg_pub for message accumulation.

Key Procedures and Functions

  • VALIDATE_LOTS — Validates lot numbers supplied for a transaction, confirming that referenced lots exist and are eligible for the transaction context.
  • VALIDATE_SERIALS — Validates serial numbers against the organization and item, ensuring serial control rules are satisfied.
  • VALIDATE_START_LOT — Validates the starting lot used in lot-split or lot-generation operations.
  • VALIDATE_RESULT_LOT — Validates the resulting lot produced by an operation, such as a split or merge.
  • VALIDATE_LOT_TRANSLATE — Validates lot translation information, supporting lot number conversion and cross-referencing.
  • VALIDATE_LPN_INFO — Validates License Plate Number (LPN) information in warehouse management–enabled organizations.
  • VALIDATE_MATERIAL_STATUS — Validates the material status applied to a lot, serial, or transaction, confirming the status is permitted for the item, organization, and movement.
  • VALIDATE_COST_GROUPS — Validates cost group assignments associated with the transaction.
  • VALIDATE_QUANTITY — Validates transaction quantities against lot, serial, and on-hand constraints.
  • VALIDATE_ATTRIBUTES — Validates lot descriptive flexfield attributes and related lot-level data.
  • VALIDATE_SERIAL_ATTRIBUTES — Validates serial descriptive flexfield attributes and serial-level data.
  • VALIDATE_ORGANIZATION — Validates the organization context, including WMS-related enablement flags.
  • COMPUTE_LOT_EXPIRATION — Computes or derives lot expiration dates based on item and lot attributes.
  • GET_ORG_INFO — Returns WMS installed, WSM enabled, and WMS enabled flags for an organization, using inv_txn_validations and MTL_PARAMETERS.
  • UPDATE_ITEM_SERIAL — Updates serial-related item information used in validation.

Tables Accessed

The package reads and writes a range of Inventory and Warehouse Management tables through APPS synonyms. MTL_LOT_NUMBERS and MTL_SERIAL_NUMBERS supply the master lot and serial records validated by the lot and serial procedures. MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_TRANSACTIONS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE, and MTL_TRANSACTION_LOTS_TEMP hold transaction rows and associated lot data pending validation or processing. MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B provide item attributes such as lot and serial control flags. MTL_PARAMETERS and MTL_SECONDARY_INVENTORIES supply organization and subinventory context, including the wsm_enabled_flag read by get_org_info. MTL_ITEM_LOCATIONS supports location validation. MTL_FLEX_CONTEXT and ALL_TAB_COLUMNS support descriptive flexfield and attribute validation. WMS_LICENSE_PLATE_NUMBERS supports LPN validation, while WIP_ENTITIES supports work-in-process context checks.

Usage Notes

INV_LOT_TRX_VALIDATION_PUB is classified as a public API (PUB) and is referenced by five other packages, indicating it is a shared validation service rather than a standalone entry point. It is typically invoked from Inventory transaction forms, mobile supply chain applications, warehouse management flows, and custom PL/SQL code that stages transactions in the interface tables before submission to the transaction processor. Because the procedures are designed to return FND_API style return status, message count, and message data, callers should check X_RETURN_STATUS for FND_API.G_RET_STS_SUCCESS and inspect messages via fnd_msg_pub. Diagnostic tracing is controlled by the INV_DEBUG_TRACE profile option, which routes output through inv_log_util.TRACE. The package is compatible with Oracle EBS 12.1.1 and 12.2.2; the documented header references a later file revision (120.18.12020000.5), consistent with cumulative patching across those releases.