Search Results mtl_generic_dispositions




Overview
Explore in AI Chat

Overview

The MTL_GENERIC_DISPOSITIONS table is a core data object within the Oracle E-Business Suite Inventory (INV) module, specifically for versions 12.1.1 and 12.2.2. It serves as the repository for defining account aliases, which are pre-configured accounting rules for material transactions. Its primary role is to map specific transaction types and sources to the correct general ledger (GL) distribution accounts, thereby automating and standardizing the accounting impact of inventory movements. This table is fundamental to ensuring that inventory transactions, such as issues, receipts, and transfers, post to the appropriate financial accounts without requiring manual account entry for each transaction.

Key Information Stored

The table's structure centers on linking transaction characteristics to a specific GL code combination. Its primary key is a composite of DISPOSITION_ID and ORGANIZATION_ID, enforcing uniqueness per inventory organization. The most critical columns include DISPOSITION_ID (a unique identifier for the alias), ORGANIZATION_ID (linking the rule to a specific inventory organization), and DISTRIBUTION_ACCOUNT (a foreign key to GL_CODE_COMBINATIONS.CODE_COMBINATION_ID that stores the target account). Other key columns typically define the transaction context for the rule, such as those referencing transaction source types, categories, or specific demand sources, allowing for granular accounting setups.

Common Use Cases and Queries

The primary use case is determining the default accounting account for a material transaction based on its attributes. For instance, when a user creates an internal sales order or a miscellaneous issue, the system queries this table to find a matching disposition rule and derive the correct charge account. Common reporting and diagnostic queries involve joining to related tables to analyze the accounting setup. A sample query to list all dispositions for an organization is:

  • SELECT disposition_id, disposition_name, distribution_account, segment1, segment2 FROM mtl_generic_dispositions mgd, gl_code_combinations gcc WHERE mgd.distribution_account = gcc.code_combination_id AND mgd.organization_id = 123;

Technical consultants often query this table to troubleshoot transaction accounting errors or to verify that new transaction sources have been properly configured with a corresponding generic disposition.

Related Objects

As indicated by the foreign key relationships, MTL_GENERIC_DISPOSITIONS is integral to several transactional and interface tables. It is directly referenced by:

  • GL_CODE_COMBINATIONS: Provides the valid accounting flexfield combination for the DISTRIBUTION_ACCOUNT.
  • MTL_PARAMETERS: Validates the ORGANIZATION_ID.
  • MTL_DEMAND & MTL_DEMAND_INTERFACE: Use the disposition to determine accounts for internal and interfaced demand.
  • MTL_MATERIAL_TRANSACTIONS_TEMP: References the table to assign accounts during transaction processing.
  • MTL_USER_SUPPLY: Uses it for accounting rules related to user-defined supply.

These relationships highlight the table's central role in bridging inventory logistics with financial accounting across the supply chain execution processes.