Search Results cst_mgd_ial_invalid_mmt

Overview

The table CST_MGD_IAL_INVALID_MMT is a configuration table within the Oracle E-Business Suite Bills of Material (BOM) module. Its primary role is to define a list of inventory transaction types that are explicitly excluded from key inventory valuation and analysis reports. Specifically, it controls which transactions are omitted from the Inventory Analytical Ledger and the Inventory Trial Balance reports. These reports are critical for financial reconciliation and cost management. By maintaining this table, administrators can filter out transactional noise—such as internal movements or preliminary adjustments—to ensure these reports reflect only the material transactions relevant for accounting and analytical purposes, thereby maintaining report integrity and clarity.

Key Information Stored

The table stores a simple but crucial mapping of transaction type identifiers. Its structure is defined by a composite primary key, ensuring each combination of source and action is unique. The key columns are:

• TRANSACTION_SOURCE_TYPE_ID: A foreign key referencing MTL_TXN_SOURCE_TYPES.TRANSACTION_SOURCE_TYPE_ID. This identifies the origin or category of the transaction (e.g., Inventory, Purchasing, Order Management).
• TRANSACTION_ACTION_ID: This identifies the specific action performed within that source type (e.g., Issue from Stores, Receipt, Subinventory Transfer). Together with the source type, it uniquely defines a transaction type to be excluded.

The presence of a record for a given (TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID) pair signifies that all inventory transactions of that type will be filtered out from the aforementioned reports.

Common Use Cases and Queries

The primary use case is the administrative configuration of inventory reporting. A cost or inventory manager may need to exclude non-valuable or internal transactions to simplify financial analysis. A common task is to review or modify the current exclusion list. A typical query to see all excluded transaction types, joined with descriptive names from the source types table, would be:

• SELECT immt.transaction_source_type_id, immt.transaction_action_id, mst.transaction_source_type_name FROM bom.cst_mgd_ial_invalid_mmt immt, inv.mtl_txn_source_types mst WHERE immt.transaction_source_type_id = mst.transaction_source_type_id;

Another critical use case is during report troubleshooting. If expected transactions are missing from the Inventory Analytical Ledger, consultants would query this table to verify if the transaction's type is inadvertently on the exclusion list. The table acts as a direct filter in the underlying views or programs that generate these standard Oracle reports.

Related Objects

CST_MGD_IAL_INVALID_MMT has documented relationships with other core inventory tables, primarily for data validation and obtaining descriptive information.

• Primary Key: The table's primary key constraint, CST_MGD_IAL_INVALID_MMT_PK, is defined on the columns (TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID).
• Foreign Key (References): The table has one documented foreign key relationship:
  • Referenced Table: INV.MTL_TXN_SOURCE_TYPES
  • Join Column: CST_MGD_IAL_INVALID_MMT.TRANSACTION_SOURCE_TYPE_ID = MTL_TXN_SOURCE_TYPES.TRANSACTION_SOURCE_TYPE_ID
  This ensures that any source type ID configured in the exclusion list is a valid, existing source type in the system.

While not explicitly listed in the provided metadata, this table is intrinsically linked to the underlying views or APIs that power the Inventory Analytical Ledger (CST_IAL_*) and Inventory Trial Balance reports, which read from this table to apply their filters.