Search Results inv_parent_mmtt_pvt




Overview
Explore in AI Chat

Overview

INV_PARENT_MMTT_PVT is a private (PVT) PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name derives from "Inventory Parent Material Management Transaction Temp," reflecting its role in the Oracle Inventory module's material transaction processing framework. Specifically, this package supports the parent-child material transaction temporary table (MMTT) architecture, a mechanism used by Oracle Inventory and Warehouse Management to stage hierarchical, multi-level transaction data before it is validated and committed to the permanent transaction tables.

The package header carries a version marker referencing the source file INVVPMTS.pls (version 115.0, dated May 19, 2004), indicating a long-stable lineage that has survived multiple EBS upgrade cycles, including 12.1.1 and 12.2.2. As a private package, it is not part of the published, supported API surface. Oracle classifies it as internal, meaning it is subject to change without notice and should not be called directly by customer code.

Key Procedures and Functions

The package exposes a single documented procedure:

  • PROCESS_PARENT — This procedure performs the core processing of a parent record in the material transaction temporary staging area. It accepts an output return status parameter (x_return_status) used to communicate success, warning, or error outcomes to the calling code, and a numeric identifier (p_parent_temp_id) that keys the specific parent row in the temporary table to be processed. The procedure orchestrates the validation and propagation of a parent transaction along with its associated child detail lines.

The package specification also declares two package-level constants (g_pkg_spec_ver and g_pkg_name) used for internal version tracking and error messaging.

Tables Accessed

The documented table references, resolved through APPS synonyms, reveal the package's position in the transaction pipeline:

  • MTL_MATERIAL_TRANSACTIONS_TEMP — The core scratch table holding pending material transactions before validation and posting. PROCESS_PARENT reads staged parent rows here for processing.
  • MTL_MATERIAL_TRANSACTIONS_S — The permanent (or interface) transaction store where validated transactions are ultimately written.
  • WMS_DISPATCHED_TASKS and WMS_DISPATCHED_TASKS_HISTORY — Warehouse Management tables holding active and historical dispatched task records. Interaction with these tables confirms that the package integrates with WMS-directed task execution, linking material transactions to warehouse task fulfillment.
  • DUAL — Used for singleton queries, such as retrieving system values or performing conditional checks.

Together these references confirm the package operates at the intersection of Oracle Inventory transaction processing and Warehouse Management task dispatch.

Usage Notes

INV_PARENT_MMTT_PVT is invoked internally by the Inventory transaction processing stack rather than by user-facing forms or concurrent programs directly. It is documented as being referenced by exactly one other package, consistent with its role as a subordinate, private worker module called by a parent driver package during the parent-child transaction commit cycle. Typical invocation occurs when material transactions are posted through the Transaction Manager, Mobile Supply Chain Applications (MSCA), or WMS-directed picking and shipping flows, and the system must expand a parent transaction into its constituent child records.

Because the package is classified PVT and is AUTHID CURRENT_USER, customers should not invoke PROCESS_PARENT directly. Customizations requiring similar behavior should use supported, public Inventory APIs. The package is present in both 12.1.1 and 12.2.2, though internal logic may differ across releases without documentation. Any modification risks breaking the transaction pipeline.