Search Results run_purge_movement_stats




Overview
Explore in AI Chat

Overview

INV_MGD_MVT_CONC_PGM is an APPS-owned PL/SQL package in Oracle E-Business Suite, classified under the ETRM API taxonomy as OTHER (i.e., an internal utility package rather than a published open interface or public API). Its name associates it with the Oracle Inventory "managed movement" processing area, and the "_CONC_PGM" suffix indicates that its entry points are designed to be called as concurrent program execution logic rather than invoked interactively from a form or from third-party code. The package consolidates the batch-side processing of inventory movement statistics: collection, exception/quality verification, status resets, purging of aged data, and export of results. In effect, it is the "worker" layer that the Inventory concurrent programs submit to, keeping the orchestration (parameter validation, request submission, logging) separate from the row-level DML performed here.

Key Procedures and Functions

The ETRM repository documents five callable units within the package:

  • RUN_MOVEMENT_STATS — the primary driver that gathers and (re)computes inventory movement statistics for the requested range, populating the movement-statistics staging/result tables consumed by downstream reporting.
  • RUN_EXCEPTION_VERIFICATION — evaluates the collected movement data against the defined exception or tolerance rules, identifying movements that fail verification so they can be reviewed or reprocessed.
  • RUN_RESET_STATUS — returns processed records to an unprocessed/initial state, enabling a re-run of movement statistics or exception verification without manual data cleanup.
  • RUN_PURGE_MOVEMENT_STATS — removes historical movement-statistics rows, supporting the housekeeping and retention policy that keeps the statistics tables at a manageable volume.
  • RUN_EXPORT_DATA — writes the finalized movement-statistics or exception results out to an external/interface destination, typically a flat file on the database or application server tier.

Consistent with the extract-only nature of this documentation, no formal parameter signatures are published; the procedures are entered as concurrent program executables and take their inputs from the concurrent program parameter set.

Tables Accessed

ETRM lists no explicit table references for this package; the dependency extract records only the SYS.STANDARD package (the implicit PL/SQL base package) plus the package's own body, and shows no other APPS package referencing it. The absence of documented table dependencies means any DML is performed through unqualified or synonym-based references that the extract did not resolve. Functionally, the procedures necessarily read and write the Inventory movement-statistics tables and their associated exception/staging tables, and the purge routine deletes from those same structures. Because the metadata does not confirm specific object names, implementers should verify the actual table list against the package body in the target instance before building custom dependencies on it.

Usage Notes

INV_MGD_MVT_CONC_PGM is intended to be invoked through Oracle Inventory concurrent programs (movement-statistics generation, exception verification, reset, purge, and export), not directly from forms or from customer PL/SQL. In Oracle EBS 12.1.1 and 12.2.2 the executable is registered with the concurrent manager and called from the request-submission layer; scheduling frequency, retention windows, and output destinations are controlled through concurrent program parameters and profile options. Custom code should not call these procedures directly, since processing order matters — statistics must be generated before verification, and verification before export — and the package offers no documented public API contract or error-handling interface. For integration or extension requirements, the supported approach is to submit the corresponding concurrent program and consume its output, or to build read-only queries against the resulting statistics tables.