Search Results inv_mgd_mvt_stats_pub




Overview
Explore in AI Chat

Overview

The APPS.INV_MGD_MVT_STATS_PUB package is a public PL/SQL API within the Oracle E-Business Suite Inventory module. Its name reflects its role in managing movement statistics — the aggregation, maintenance, and lifecycle control of transaction movement data generated as inventory transactions occur across the enterprise. In EBS 12.1.1 and 12.2.2, movement statistics underpin the ability to analyze transaction volumes, reconcile movement records, and support downstream reporting and warehouse management activity.

The package is classified as a PUB (public) API, indicating it is intended for external invocation rather than internal-only use. Its metadata status is VALID in the APPS schema, confirming it is a compiled and active object. The package depends on FND_API, the standard Oracle Application Object Library API framework used across EBS for consistent error handling and return status conventions, and on the record/collection type definition INV_MGD_MVT_DATA_STR, which provides the structured data payload used when passing movement records between procedures. Both dependencies reinforce the package's design as a conforming, integration-ready API that follows Oracle's standard development standards.

Key Procedures and Functions

The package exposes six documented procedures or functions, each addressing a distinct stage of the movement-statistics lifecycle:

  • PROCESS_TRANSACTION — Serves as the primary entry point for processing a movement transaction, driving the logic that interprets and applies the incoming transaction data.
  • CREATE_MOVEMENT_STATISTICS — Creates movement statistics records from processed transaction data, populating the underlying statistics tables.
  • UPDATE_MOVEMENT_STATISTICS — Modifies existing movement statistics records, supporting corrections or adjustments to previously generated data.
  • VALIDATE_MOVEMENT_STATISTICS — Performs validation checks against movement statistics, ensuring data integrity and conformance before or after processing.
  • RESET_TRANSACTION_STATUS — Resets the status of a movement transaction, typically to allow reprocessing or to clear an error condition.
  • PURGE_MOVEMENT_TRANSACTIONS — Removes obsolete or processed movement transaction records, supporting data retention and housekeeping requirements.

No parameter lists are documented for these procedures; the descriptions above reflect their functional purpose only.

Tables Accessed

The provided ETRM metadata does not enumerate specific tables accessed through APPS synonyms. The package's reliance on the INV_MGD_MVT_DATA_STR structure indicates that movement data is passed and manipulated using structured PL/SQL record types rather than exposed as direct table references in the documented metadata. Practically, procedures such as CREATE_MOVEMENT_STATISTICS, UPDATE_MOVEMENT_STATISTICS, and PURGE_MOVEMENT_TRANSACTIONS operate against the movement statistics and movement transaction tables in the Inventory schema, reading, inserting, updating, and deleting records as their names imply.

Usage Notes

As a public API, INV_MGD_MVT_STATS_PUB is intended for invocation from concurrent programs, Oracle Forms, and custom PL/SQL code that requires programmatic control over movement statistics. It is not referenced by any other package, so its consumers are external callers rather than internal package chains. Typical invocation patterns include scheduled concurrent programs that create or purge movement statistics, corrective utilities that reset or validate transaction status, and custom extensions that call PROCESS_TRANSACTION to submit movement data. Developers invoking the package should observe the FND_API conventions for checking return status and handling errors, and should respect the transaction status lifecycle managed through RESET_TRANSACTION_STATUS to avoid reprocessing inconsistencies.