Search Results inv_mut_insert




Overview
Explore in AI Chat

Overview

INV_LOGICAL_TRANSACTIONS_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Inventory (INV) module, owned by the APPS schema. It supports the creation of logical inventory transactions that do not map directly to a single physical material movement, such as sales order issues, RMA receipts, and other logical movements processed through the Inventory Transaction Manager. The package body header (INVLTPVB.pls 120.5, shipped 2010) indicates it is part of the 12.1.1 code base and remains present in 12.2.2.

Because the API is classified as PVT, it is intended for internal consumption by other Inventory APIs and concurrent processing logic rather than as a public integration interface. Its core responsibility is to validate input parameters, insert rows into the material transaction and unit transaction tables, handle lot and serial number assignment, and persist serial number generation and updates. This makes it a supporting component of the transaction processing stack that ultimately feeds on-hand quantity, cost, and serial/lot tracking.

Key Procedures and Functions

  • VALIDATE_INPUT_PARAMETERS — Performs pre-insertion validation of the input records supplied by the caller, including checks on transaction type, source type, order references, and API version. An internal debug routine (debug_print) routes trace output through INV_LOG_UTIL when the INV_DEBUG_TRACE profile option is enabled. Validation may be skipped for records already validated by the transaction manager, depending on the validation flag and logical transaction type code.
  • INV_MMT_INSERT — Inserts the primary transaction rows into the material transaction tables. This is the core insertion procedure for the logical transaction flow.
  • INV_MUT_INSERT — Inserts corresponding rows into the unit transaction table (MTL_UNIT_TRANSACTIONS), aligning each logical transaction record with its unit-level representation. This is the procedure most directly associated with the "inv_mut_insert" search term.
  • INV_LOT_SERIAL_INSERT — Handles insertion of lot and serial number associations for transactions that involve lot-controlled or serial-controlled items.
  • GENERATE_SERIAL_NUMBERS — Generates new serial numbers where the transaction requires them and no serials are pre-supplied.
  • UPDATE_SERIAL_NUMBERS — Updates serial number records to reflect the completed logical transaction, including any status or association changes.

Tables Accessed

The package reads and writes against standard Inventory and Order Entry synonyms. MTL_MATERIAL_TRANSACTIONS and its intersection view MTL_MATERIAL_TRANSACTIONS_S receive the transaction rows, while MTL_UNIT_TRANSACTIONS receives the unit-level rows inserted by INV_MUT_INSERT. MTL_TRANSACTION_LOT_NUMBERS and MTL_SERIAL_NUMBERS support lot and serial tracking. MTL_SYSTEM_ITEMS, MTL_PARAMETERS, MTL_TRANSACTION_TYPES, MTL_ITEM_LOCATIONS, MTL_SECONDARY_INVENTORIES, and MTL_SECONDARY_LOCATORS supply validation and defaulting data. MTL_SALES_ORDERS and OE_DROP_SHIP_SOURCES link transactions back to sales order context. GL_CODE_COMBINATIONS and CST_COST_GROUPS are referenced for costing and accounting association.

Usage Notes

This package is invoked indirectly, typically from transaction manager routines or other Inventory private APIs that build logical transactions from sales order issue, RMA receipt, and drop-shipment flows. It is not normally called directly from forms or concurrent programs; custom code should avoid depending on it because PVT packages carry no upgrade guarantee. When troubleshooting failures involving inv_mut_insert, enable INV_DEBUG_TRACE to capture trace output routed through INV_LOG_UTIL, and confirm that the referenced transaction type and source type values were resolved correctly during validation.