Search Results mtl_parameters




Overview
Explore in AI Chat

Overview

MTL_PARAMETERS is the Inventory organization parameters table owned by the INV schema in Oracle E-Business Suite. It stores the inventory control options, defaults, and account assignments that govern how Inventory, Cost Management, and adjacent modules behave for each inventory organization. In Oracle EBS 12.1.1 and 12.2.2, every inventory organization defined in HR_ALL_ORGANIZATION_UNITS carries exactly one row in MTL_PARAMETERS, making this table the authoritative configuration record for that organization. Business flows such as material transactions, cost processing, inter-org transfers, receiving, WMS, and lot/serial control all read their defaults and validation rules from this table before executing.

The table is documented with 198 columns and a single-column primary key, MTL_PARAMETERS_PK, on ORGANIZATION_ID. It carries extensive outbound foreign keys to GL_CODE_COMBINATIONS for accounting account assignments, and it is referenced by a very large set of INV, CST, BOM, MRP, WMS, and EAM tables via ORGANIZATION_ID. From a data-vault modeling perspective, the metadata characterizes MTL_PARAMETERS as hub-leaning: ORGANIZATION_ID behaves as a durable business key, and the remaining columns are largely descriptive configuration attributes.

Key Information Stored

The primary key, ORGANIZATION_ID, identifies the inventory organization and is also the documented unique business-key candidate via MTL_PARAMETERS_U1. Other columns in the table are descriptive configuration attributes rather than surrogate identifiers. The most consequential columns include:

Common Use Cases and Queries

Consultants and developers query MTL_PARAMETERS to retrieve organization-level accounting defaults, confirm costing method configuration, troubleshoot transaction errors caused by missing defaults, and drive reporting on how inventory organizations are configured. Typical retrievals include organization setup reports, cross-module reconciliation of account assignments, and integration extracts where downstream systems need the inventory organization's defaults.

A representative query retrieves core configuration for a single organization:

  • SELECT organization_id, organization_code, primary_cost_method, cost_organization_id, master_organization_id, negative_inv_receipt_code FROM mtl_parameters WHERE organization_id = :p_org_id;

To reconcile inventory account assignments against the chart of accounts for an organization:

  • SELECT mp.organization_id, mp.material_account, mp.material_overhead_account, mp.resource_account, mp.overhead_account FROM mtl_parameters mp WHERE mp.organization_id = :p_org_id;

To identify all inventory organizations using a given costing method for reporting or migration analysis:

  • SELECT organization_id, organization_code FROM mtl_parameters WHERE primary_cost_method = 'AVERAGE';

Reporting scenarios include organization parameter audits, WMS and lot/serial control compliance checks, and costing method validation during data conversions or upgrades between 12.1.1 and 12.2.2.

Related Objects

MTL_PARAMETERS is referenced by a large number of objects across INV and adjacent modules. The most significant relationships include:

The breadth of these references confirms MTL_PARAMETERS as a hub-style configuration object: the majority of INV and cost-related child tables resolve their organization context through it.