Search Results mtl_parameters

Overview

The MTL_PARAMETERS table is a fundamental master data table within the Oracle E-Business Suite Inventory (INV) module. It serves as the central repository for defining and storing the primary control options, default accounts, and operational rules for a specific inventory organization. Each row in this table corresponds to a single inventory organization, making it a critical configuration point that governs transactional behavior, costing, and accounting for all inventory activities within that organization. Its role is pivotal in ensuring consistent application of business rules across the supply chain execution processes.

Key Information Stored

The table's primary key is ORGANIZATION_ID, linking it to the HR_ALL_ORGANIZATION_UNITS table. Its columns define the essential operational and financial parameters for an organization. Key stored information includes default general ledger accounts for inventory valuation (e.g., MATERIAL_ACCOUNT, EXPENSE_ACCOUNT, COST_OF_SALES_ACCOUNT), accounts for cost absorption (e.g., MATERIAL_OVERHEAD_ACCOUNT, OVERHEAD_ACCOUNT), and variance accounts (e.g., AVERAGE_COST_VAR_ACCOUNT). It also holds references to operational rules, such as DEFAULT_PICKING_RULE_ID and DEFAULT_ATP_RULE_ID, and organizational hierarchy data like MASTER_ORGANIZATION_ID and COST_ORGANIZATION_ID. Additional columns control defaults for calendars, exception sets, and source subinventories for replenishment.

Common Use Cases and Queries

This table is primarily queried for configuration validation, reporting on organizational setups, and as a source for default values during transaction processing. A common use case is verifying the default expense account for a given organization to ensure proper accounting. Sample queries include retrieving all parameters for a specific organization or listing organizations and their primary material account for a financial audit.

• Retrieve all parameters for organization ID 204: SELECT * FROM INV.MTL_PARAMETERS WHERE ORGANIZATION_ID = 204;
• List organizations with their default material and expense accounts: SELECT ORGANIZATION_ID, MATERIAL_ACCOUNT, EXPENSE_ACCOUNT FROM INV.MTL_PARAMETERS ORDER BY ORGANIZATION_ID;
• Find organizations that use a specific cost calendar: SELECT ORGANIZATION_ID, NAME FROM HR_ALL_ORGANIZATION_UNITS HOU, INV.MTL_PARAMETERS MP WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MP.CALENDAR_CODE = 'STANDARD';

Related Objects

As indicated by its extensive foreign key relationships, MTL_PARAMETERS is a central hub connected to numerous core EBS tables. Key related objects include:

• GL_CODE_COMBINATIONS: Referenced for nearly all default inventory accounting accounts (e.g., MATERIAL_ACCOUNT, EXPENSE_ACCOUNT).
• MTL_PARAMETERS (self-referenced): Related via COST_ORGANIZATION_ID, MASTER_ORGANIZATION_ID, and SOURCE_ORGANIZATION_ID to define inter-organization relationships.
• MTL_SECONDARY_INVENTORIES: Linked via SOURCE_SUBINVENTORY for replenishment defaults.
• Operational Rule Tables: MTL_PICKING_RULES (DEFAULT_PICKING_RULE_ID) and MTL_ATP_RULES (DEFAULT_ATP_RULE_ID).
• Other Key Tables: BOM_CALENDARS, BOM_EXCEPTION_SETS, BOM_RESOURCES, CST_COST_GROUPS, and HR_ALL_ORGANIZATION_UNITS.