Search Results inv_cyc_lovs




Overview
Explore in AI Chat

Overview

INV_CYC_LOVS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Inventory cycle counting functionality. Its primary business purpose is to furnish List of Values (LOV) queries and the associated validation and table-handling logic required by the Oracle Inventory cycle count forms. The package supplies the query result sets that populate cycle count LOV fields and, in parallel, provides the procedural engine that manipulates cycle count entry rows during data entry, saving, recounting, and adjustment processing. It is classified as an OTHER-type API rather than a formal public interface, meaning it is a supporting utility package invoked internally by the Inventory application rather than a documented integration point for external consumers.

The package is marked VALID in the ETRM repository and exposes a substantial set of 58 documented procedures and functions. It depends on the FND_API foundation package, indicating that it participates in the standard EBS API error-handling and message framework, and it works against both the current cycle count tables and their shadow (_S) tables commonly used for flexible-form block coordination.

Key Procedures and Functions

The documented procedures and functions fall into several functional groups:

These routines collectively implement the business rules governing cycle count entry, recount decisions, tolerance comparison, and adjustment eligibility.

Tables Accessed

The package references its data through APPS synonyms. The core cycle count tables are MTL_CYCLE_COUNT_ENTRIES, MTL_CYCLE_COUNT_ENTRIES_S, MTL_CYCLE_COUNT_HEADERS, MTL_CYCLE_COUNT_ITEMS, and MTL_CYCLE_COUNT_CLASSES, which store count entries, count headers, counted items, and the cycle count classes that schedule counting frequency. MTL_CC_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS support serial-controlled item counting. On-hand and transaction context is drawn from MTL_ONHAND_QUANTITIES_DETAIL, MTL_MATERIAL_TRANSACTIONS_S, and MTL_MATERIAL_TRANSACTIONS_TEMP. Location, subinventory, and parameter setup data come from MTL_ITEM_LOCATIONS, MTL_SECONDARY_INVENTORIES, and MTL_PARAMETERS. FND_USER resolves the operating user, and MRP_PROJECT_PARAMETERS supplies project-related settings. This combination lets the package validate entries, resolve serial and locator information, and drive adjustment transactions.

Usage Notes

INV_CYC_LOVS is invoked from the Oracle Inventory cycle count forms, where it backs LOV fields and the entry-processing logic executed during count entry, save, recount, and approval. It is referenced by four other packages, notably INV_CYC_LOVS and INV_PHY_INV_LOVS, indicating shared use across cycle count and physical inventory LOV/processing packages, and is also used by MTL_INV_UTIL_GRP. Because it is an internal utility package rather than a formal public API, customizations should avoid calling it directly where a supported API exists, and any reliance on it should be validated against the target release (12.1.1 or 12.2.2), since its signature and behavior are not guaranteed across versions.