Search Results create_movement_statistics




Overview
Explore in AI Chat

Overview

INV_MGD_MVT_STATS_PUB is a public PL/SQL package in the Oracle E-Business Suite Inventory (INV) module. Its source file, INVPMVTB.pls, was created in June 2000 and is identified in the header as the body of the movement statistics public API. The package provides the business logic that supports managed movement statistics — the periodic aggregation of inventory transactions (receipts, issues, transfers and related movements) into statistics records used for reporting, auditing and regulatory or internal analysis of stock movements by legal entity.

The package follows the standard EBS public API conventions: procedures carry an API version parameter, accept p_init_msg_list to control message list initialization, and return x_return_status, x_msg_count and x_msg_data. This design allows callers to invoke the API, inspect the outcome, and retrieve error messages through the FND message stack.

Key Procedures and Functions

ETRM documents six procedures in the package:

  • PROCESS_TRANSACTION — The top-level driver procedure. It processes all eligible inventory transactions for a specified legal entity whose transaction date falls within a supplied start and end date range, with a parameter identifying the source or transaction type (for example sales order or purchase order).
  • CREATE_MOVEMENT_STATISTICS — Creates new movement statistics records from the qualifying transactions produced by the processing step.
  • VALIDATE_MOVEMENT_Statistics — Performs validation checks on the movement statistics data before it is committed or finalized, ensuring the records satisfy the required business rules.
  • UPDATE_MOVEMENT_STATISTICS — Updates existing movement statistics records. This is the procedure users reach when searching update_movement_statistics, and it is the supported entry point for modifying statistics that already exist in the system.
  • RESET_TRANSACTION_STATUS — Resets the processing status of transactions, typically to allow reprocessing or to clear a failed run so the affected transactions can be picked up again.
  • PURGE_MOVEMENT_TRANSACTIONS — Removes old or obsolete movement transaction data, supporting data retention and housekeeping.

Tables Accessed

The ETRM metadata for this object does not enumerate specific base tables. In practice, the package operates on the inventory movement statistics tables in the INV schema (accessed through APPS synonyms), together with the underlying inventory transaction table from which movement records are derived. Because the published metadata records no referenced tables explicitly, implementers should confirm the exact table usage against the installed version of INVPMVTB.pls before building custom dependencies on those objects.

Usage Notes

INV_MGD_MVT_STATS_PUB is a public API classified as PUB, meaning it is intended to be called from outside the Inventory module — by concurrent programs, Oracle Forms, or custom PL/SQL. It is not referenced by any other packaged API, so it sits at the top of the call stack rather than acting as a shared internal library.

Typical invocation for the update path is from custom code that supplies the API version, an initialization flag, the relevant identifiers and date range, and then checks x_return_status for success or error. The same conventions apply to Process_Transaction and the remaining procedures. Because the package predates recent releases but is shipped in both 12.1.1 and 12.2.2, developers should validate behavior against the specific release and always handle the returned message list rather than assuming implicit success.