Search Results run_exception_verification

Overview

INV_MGD_MVT_CONC_PGM is an Oracle Inventory package body that serves as the concurrent-program driver layer for movement statistics processing. It belongs to the Managed Movement Statistics (MGD MVT) subsystem, the same functionality exposed through the Inventory Movement Statistics window and the associated concurrent requests. The package provides the entry points invoked by the Concurrent Manager to calculate, verify, reset, purge, and export movement statistics data.

The header comment records creation on 01/04/2000 and a series of revisions through 2006, including the addition of Run_Export_Data, the introduction of the p_movement_status parameter to the reset routine, the addition of currency code and exchange rate to the export routine, the use of NOCOPY for OUT parameters with conditional debug logging, and the reordering of x_errbuf and x_retcode to conform to Concurrent Manager API standards. This lineage indicates the package is a long-standing, production-grade component rather than a recent addition.

The naming convention of the internal procedures, each prefixed with Run_, reflects the Oracle EBS practice of naming the concurrent-program entry point after the request it drives. The package is classified under ETRM as API classification OTHER, meaning it is not a published open interface but is still a documented, callable program unit.

Key Procedures and Functions

• RUN_MOVEMENT_STATS — The primary concurrent program entry point for the calculation or refresh of movement statistics over a transaction date range for a given legal entity. It accepts the standard Concurrent Manager error buffer and return code, a legal entity identifier, and start and end dates delimiting the transaction range to be processed.
• RUN_EXCEPTION_VERIFICATION — Performs verification of movement statistics data, identifying records that fail validation or reconciliation rules and reporting the exceptions for review.
• RUN_RESET_STATUS (documented as Run_Reset_Movement_Stats in the body header) — Resets movement statistics records so they can be reprocessed. A later revision added the p_movement_status parameter, allowing the caller to target a specific movement status rather than resetting unconditionally.
• RUN_PURGE_MOVEMENT_STATS — Removes obsolete or superseded movement statistics records from the repository, providing the housekeeping function that keeps the movement statistics tables from growing without bound.
• RUN_EXPORT_DATA — Extracts movement statistics data to an external destination for downstream reporting or archival. Currency code and exchange rate were added to this routine in 2002, reflecting the need to present amounts in a currency-independent form.

Tables Accessed

The ETRM metadata for this package does not enumerate specific base tables. Movement statistics processing in Oracle Inventory operates against the movement statistics tables and their associated interface and error tables, accessed through APPS synonyms. The reporting routine reads transaction and movement history; the reset, purge, and verification routines write status and exception information back to the relevant statistics records.

Usage Notes

This package is invoked from the Concurrent Manager. The standard parameter signatures begin with x_errbuf and x_retcode, ordered to comply with Concurrent Manager conventions following the December 2004 revision. Because OUT parameters use NOCOPY and diagnostic output is written to the log only when the debug profile option is enabled, the package is intended for scheduled, high-volume execution rather than interactive use. It is referenced by zero other packages in the ETRM record, confirming that it functions as a top-level program unit rather than a shared utility library. Custom code should not call these routines directly; the supported interface is the concurrent program registration.