Search Results inv_shortcheckexec_pvt




Overview
Explore in AI Chat

Overview

APPS.INV_SHORTCHECKEXEC_PVT is a private PL/SQL package within the Oracle E-Business Suite Inventory module. Its name reflects its role: it executes "short check" processing logic. A short check is an inventory verification procedure used to confirm that on-hand quantities for selected items and organizations match what the system records, typically in support of cycle counting, physical reconciliation, or replenishment planning. The package orchestrates the comparison of expected versus actual stock levels and drives notifications when discrepancies are detected.

As a private (PVT) API, the package is not intended for direct external invocation. It is consumed by its public counterpart INV_SHORTCHECKEXEC_PUB and by related internal packages such as INV_SHORTCHECKPROCESSTRX_PVT and INV_RCV_COMMON_APIS. The package is classified with an API classification of PVT under the APPS schema and is listed as VALID. It depends on FND_API for standardized return status handling, consistent with Oracle's API design conventions.

Key Procedures and Functions

The ETRM metadata documents six procedures/functions. Their names indicate their functional roles without disclosing parameter signatures.

  • EXECCHECK — The principal driver that executes the short check logic across the selected scope of items, organizations, and subinventories.
  • CHECKPREREQUISITES — Validates the preconditions required before a short check can run, ensuring parameter and setup integrity.
  • SENDNOTIFICATIONS — Dispatches alerts or messages to relevant users (such as planners) when short check results require action.
  • PURGETEMPTABLE — Cleans up the temporary workspace used during execution, removing stale staging data.
  • PREPAREMESSAGE — Constructs the message content used in notifications, formatting results for user consumption.
  • GET_REP_CURR_OPEN_QTY — Retrieves the current open quantity for a replenishment context, supporting comparison against expected levels.

Tables Accessed

The package reads and writes several core Inventory tables through APPS synonyms. MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_KFV supply item definitions and descriptive flexfield information, while MTL_PARAMETERS provides organization-level Inventory setup. MTL_PLANNERS and FND_USER support planner identification and notification routing, and HR_ORGANIZATION_INFORMATION resolves organizational attributes.

Transaction and supply context come from MTL_TRANSACTION_TYPES, OE_ORDER_HEADERS, WIP_DISCRETE_JOBS, and WIP_ENTITIES, allowing the check to consider demand from sales orders and work in process. Calendar logic uses BOM_CALENDAR_DATES. The short check configuration and output are held in MTL_SHORT_CHK_PARAM, MTL_SHORT_CHK_STATEMENTS, MTL_SHORT_CHK_TEMP, and MTL_SHORT_CHK_TEMP_S, the last being the temporary staging table purged after execution.

Usage Notes

INV_SHORTCHECKEXEC_PVT is invoked indirectly. It is referenced by the public package INV_SHORTCHECKEXEC_PUB, by the transaction-processing package INV_SHORTCHECKPROCESSTRX_PVT, and by INV_RCV_COMMON_APIS and the report package INV_INVTRSHS_XMLP_PKG. Typical invocation paths include concurrent programs that submit short check runs and inventory forms or internal processing that call the public API layer. Customizations should call INV_SHORTCHECKEXEC_PUB rather than this private package, relying on FND_API-compliant return statuses. Administrators should ensure prerequisite Inventory setup is complete and that temporary short check staging tables are purged regularly to prevent accumulation.