Search Results process_tag

Overview

INV_PHY_INV_LOVS is an Oracle EBS Application Object Library (APPS) package that supports the Physical Inventory module within Oracle Inventory. Its primary role is to provide list-of-values (LOV) queries, serial number validation, and tag processing logic used throughout the physical inventory counting and adjustment workflow. The package header carries the identifier INVPINLS.pls 120.3 and is classified as API classification OTHER, indicating it is an internal utility package rather than a formally published public API.

The package exposes thirteen documented procedures and functions that collectively enable physical inventory operations. These range from returning valid physical inventory LOV rows, to counting tags associated with a serial number, to inserting and updating tag rows, processing adjustments, and generating summaries. In Oracle EBS 12.1.1 and 12.2.2, this package is a supporting component that is invoked from physical inventory forms and concurrent programs rather than called directly by end users.

Key Procedures and Functions

• GET_PHY_INV_LOV — Returns valid physical inventories as a reference cursor, restricted by user input text and organization. It powers the physical inventory LOV field on various forms.
• GET_SERIAL_COUNT_NUMBER — Returns the count of physical tag records for a given serial number, and additionally determines whether the serial number is within the scope of the physical inventory (i.e., exists in a covered subinventory).
• PROCESS_TAG — Handles processing of a physical inventory tag record for a given organization, subinventory, locator, item, and optional LPN context.
• INSERT_ROW — Inserts a new physical inventory tag or related record.
• UPDATE_ROW — Updates an existing physical inventory tag row.
• UPDATE_ADJUSTMENT — Updates physical adjustment records associated with inventory discrepancies.
• FIND_EXISTING_ADJUSTMENT — Locates an existing physical adjustment for a given criterion, preventing duplicate adjustments.
• PROCESS_SUMMARY — Generates or processes summary data for a physical inventory, consolidating tag and adjustment information.
• UNMARK_SERIALS — Resets or unmarks serial number flags associated with physical inventory tags, typically when a count is voided or a tag is reprocessed. This is the procedure the user searched for under the term unmark_serials.
• GET_SERIAL_NUMBER_TYPE — Determines the type of a serial number (e.g., predefined, dynamic) for validation and processing purposes.
• VALIDATE_SERIAL_STATUS — Validates the current status of a serial number prior to tag processing or adjustment.
• DELETE_DUPLICATE_ENTRIES — Removes duplicate physical inventory tag entries to maintain data integrity.
• PROCESS_PHY_INV_SUBXFER — Handles subinventory transfer processing related to physical inventory adjustments.

Tables Accessed

The package references numerous Oracle Inventory tables through APPS synonyms. MTL_PHYSICAL_INVENTORIES holds the physical inventory definitions queried by GET_PHY_INV_LOV. MTL_PHYSICAL_INVENTORY_TAGS and its _S variant store tag records inserted, updated, and de-duplicated by the package. MTL_PHYSICAL_ADJUSTMENTS and MTL_PHYSICAL_ADJUSTMENTS_S hold adjustment data updated via UPDATE_ADJUSTMENT and located by FIND_EXISTING_ADJUSTMENT. MTL_PHYSICAL_SUBINVENTORIES defines the scope used by GET_SERIAL_COUNT_NUMBER to determine serial inclusion. MTL_SERIAL_NUMBERS is central to UNMARK_SERIALS, GET_SERIAL_NUMBER_TYPE, and VALIDATE_SERIAL_STATUS. MTL_SYSTEM_ITEMS validates item definitions. MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP support adjustment transaction processing and subtransfer logic. MTL_SECONDARY_INVENTORIES and MTL_PARAMETERS provide subinventory and organization parameter context. WMS_LICENSE_PLATE_NUMBERS supports LPN handling in PROCESS_TAG, and FND_USER is referenced for audit/user context.

Usage Notes

INV_PHY_INV_LOVS is not a public API and is referenced by zero other packages, indicating it is called directly from Oracle Forms and concurrent programs within the Physical Inventory module. Typical invocation scenarios include: populating the physical inventory LOV on the Physical Inventory form; validating serial numbers during tag entry or adjustment; processing tag counts and adjustments when a physical inventory is approved or a tag is finalized; and invoking UNMARK_SERIALS when a tag or count must be reversed so the associated serial numbers can be recounted. Because it manipulates physical inventory tag and adjustment tables directly, custom code should invoke these procedures only within the supported physical inventory workflow and avoid direct DML against the underlying tables. The package is present in both 12.1.1 and 12.2.2, with the 12.2.2 ETRM metadata documenting all thirteen procedures listed above.