Search Results mtl_parameters
The MTL_PARAMETERS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical repository for inventory organization-specific parameters that govern the behavior of the Inventory Management module. This table stores configuration settings that define operational rules, default values, and control mechanisms for inventory transactions, costing, and other inventory-related functionalities. Below is a detailed summary of its structure, purpose, and key attributes.
Overview of MTL_PARAMETERS
The MTL_PARAMETERS table is part of the Oracle Inventory module and acts as a central control point for inventory organizations. Each record in this table corresponds to a single inventory organization, storing parameters that influence how transactions are processed, how costs are calculated, and how items are managed within that organization. The table is essential for maintaining consistency and enforcing business rules across the inventory management lifecycle.Key Columns and Their Significance
- ORGANIZATION_ID: A unique identifier for the inventory organization, linking to HR_ORGANIZATION_UNITS.
- MASTER_ORGANIZATION_ID: Indicates the master inventory organization for shared item definitions in a multi-org setup.
- DEFAULT_COST_GROUP_ID: Specifies the default cost group for inventory valuation.
- DEFAULT_LOCATOR_CONTROL: Controls whether locators are mandatory for item transactions (e.g., Prespecified, Dynamic Entry).
- LOT_NUMBER_UNIQUENESS: Determines if lot numbers must be unique across organizations or only within an organization.
- SERIAL_NUMBER_CONTROL: Defines whether serial number tracking is enforced (e.g., No Control, At Receipt, At Sales Order Issue).
- ALLOW_NEGATIVE_BALANCES: Permits or restricts negative on-hand quantities for items.
- DEFAULT_INCLUDE_IN_SHIPPING: Sets whether items are automatically included in shipping documents.
- REQUIRE_LOCATOR_LOCTYPE: Enforces locator type validation during transactions.
- DEFAULT_GRADE_CONTROL: Manages grade control for items, if applicable.
Functional Impact
The parameters stored in MTL_PARAMETERS directly influence core inventory processes:- Transaction Processing: Rules like locator control and negative balance allowances dictate how transactions (receipts, issues, transfers) are executed.
- Costing: Default cost groups and valuation methods impact inventory accounting and cost rollups.
- Item Traceability: Serial and lot control settings ensure compliance with traceability requirements.
- Multi-Org Operations: Master organization linkages enable shared item definitions while maintaining org-specific rules.
Integration with Other Modules
MTL_PARAMETERS interacts with several Oracle EBS modules:- Purchasing: Affects receipt and inspection workflows.
- Order Management: Influences shipping and fulfillment rules.
- Cost Management: Provides default costing structures.
- Warehouse Management: Integrates with locator and lot/serial controls.
Technical Considerations
The table is populated during inventory organization setup via the Define Organization form. Changes to parameters may require thorough testing, as they can cascade to downstream processes. In EBS 12.2.2, additional columns may exist to support newer features like enhanced lot/serial controls or advanced warehouse management.Conclusion
The MTL_PARAMETERS table is a foundational component of Oracle Inventory, enabling granular control over inventory operations. Its configuration is critical for aligning system behavior with organizational policies, ensuring accurate costing, and maintaining compliance with traceability standards. Proper setup and periodic review of this table are essential for optimizing inventory management in Oracle EBS.-
Table: MTL_PARAMETERS
12.2.2
owner:INV, object_type:TABLE, fnd_design_data:INV.MTL_PARAMETERS, object_name:MTL_PARAMETERS, status:VALID, product: INV - Inventory , description: Inventory control options and defaults , implementation_dba_data: INV.MTL_PARAMETERS ,
-
Table: MTL_PARAMETERS
12.1.1
owner:INV, object_type:TABLE, fnd_design_data:INV.MTL_PARAMETERS, object_name:MTL_PARAMETERS, status:VALID, product: INV - Inventory , description: Inventory control options and defaults , implementation_dba_data: INV.MTL_PARAMETERS ,
-
Lookup Type: MTL_PARAMETERS
12.2.2
product: INV - Inventory , meaning: MTL PARAMETERS ,
-
Lookup Type: MTL_PARAMETERS
12.1.1
product: INV - Inventory , meaning: MTL PARAMETERS ,
-
APPS.INVICGDS dependencies on MTL_PARAMETERS
12.1.1
-
APPS.WMS_RULE_2 dependencies on MTL_PARAMETERS
12.1.1
-
APPS.CSTPIDIC dependencies on MTL_PARAMETERS
12.1.1
-
APPS.AMS_BOM_PVT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.OKL_AM_CUSTOM_RMK_ASSET_PVT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.ENG_ITEM_PKG dependencies on MTL_PARAMETERS
12.1.1
-
APPS.AHL_PRD_DISP_UTIL_PVT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.ENGPKIMP dependencies on MTL_PARAMETERS
12.1.1
-
APPS.RCI_ORG_CERT_ETL_PKG dependencies on MTL_PARAMETERS
12.1.1
-
APPS.RCV_TABLE_FUNCTIONS dependencies on MTL_PARAMETERS
12.1.1
-
APPS.GMF_MIGRATION dependencies on MTL_PARAMETERS
12.1.1
-
APPS.OPI_DBI_RES_EFF_JOB_DTL_PKG dependencies on MTL_PARAMETERS
12.1.1
-
APPS.WPS_SUPPLY_DEMAND dependencies on MTL_PARAMETERS
12.1.1
-
APPS.CSI_INTERFACE_PKG dependencies on MTL_PARAMETERS
12.1.1
-
APPS.BOM_RTG_ISETUP_IMP dependencies on MTL_PARAMETERS
12.1.1
-
APPS.WIP_VALIDATEMLHEADER_PVT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.CSP_PARTS_REQUIREMENT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.INV_OPM_ITEM_MIGRATION dependencies on MTL_PARAMETERS
12.1.1
-
APPS.EAM_WORKORDERS_JSP dependencies on MTL_PARAMETERS
12.1.1
-
APPS.CSD_PROCESS_PVT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.EAM_TEXT_UTIL dependencies on MTL_PARAMETERS
12.1.1
-
APPS.PO_WF_PO_ACCRUAL_ACC dependencies on MTL_PARAMETERS
12.1.1
-
APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on MTL_PARAMETERS
12.1.1
-
APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.EAM_WO_VALIDATE_PVT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.GMD_QMSED dependencies on MTL_PARAMETERS
12.1.1
-
APPS.OPIMXRU dependencies on MTL_PARAMETERS
12.1.1
-
APPS.INV_CG_UPGRADE dependencies on MTL_PARAMETERS
12.1.1
-
APPS.INV_GMI_RSV_BRANCH dependencies on MTL_PARAMETERS
12.1.1
-
APPS.MRP_EPI dependencies on MTL_PARAMETERS
12.1.1
-
APPS.CSTPPIPV dependencies on MTL_PARAMETERS
12.1.1
-
APPS.BOMPLDCI dependencies on MTL_PARAMETERS
12.1.1
-
APPS.AHL_PRD_WORKORDER_PVT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.WSH_DEL_OI_CORE dependencies on MTL_PARAMETERS
12.1.1
-
APPS.POA_DBI_REQ_F_C dependencies on MTL_PARAMETERS
12.1.1
-
APPS.INV_PROJECT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.CSTPSCEX dependencies on MTL_PARAMETERS
12.1.1
-
APPS.EAM_CONSTRUCTION_UNIT_PVT dependencies on MTL_PARAMETERS
12.1.1
-
APPS.CST_EAMCOST_PUB dependencies on MTL_PARAMETERS
12.1.1
-
APPS.GMD_QM_UOM dependencies on MTL_PARAMETERS
12.1.1
-
APPS.WMS_TASK_DISPATCH_GEN dependencies on MTL_PARAMETERS
12.1.1
-
APPS.CSI_INV_DISCREPANCY_PKG dependencies on MTL_PARAMETERS
12.1.1
-
APPS.EAM_ASSET_LOG_PUB dependencies on MTL_PARAMETERS
12.1.1
-
APPS.WIP_WEIGHTED_AVG dependencies on MTL_PARAMETERS
12.1.1
-
APPS.INV_CUSTOMER_ITEM_GRP dependencies on MTL_PARAMETERS
12.1.1
-
APPS.WIP_JOBCLOSE_PRIV dependencies on MTL_PARAMETERS
12.1.1