Search Results mtl_parameters




Here's a detailed description of the MTL_PARAMETERS table in Oracle E-Business Suite (EBS):

Table Name: MTL_PARAMETERS (Material Transaction Parameters)

Purpose:
The MTL_PARAMETERS table stores organization-specific inventory parameters and configuration settings for inventory management within Oracle Inventory (INV) module.

Key Columns:
1. ORGANIZATION_ID (Primary Key)
- Unique identifier for the inventory organization
- Links to HR_ORGANIZATION_UNITS table
- Defines specific inventory organization settings

2. ORGANIZATION_CODE
- Short code representing the inventory organization
- Used for quick reference and identification

3. INVENTORY_ASSET_FLAG
- Indicates if the organization tracks inventory as an asset
- 'Y' means inventory value is tracked
- 'N' means no asset tracking

4. COST_GROUP_ACCOUNTING_FLAG
- Determines if cost group accounting is enabled
- Controls cost tracking at cost group level

5. DEFAULT_MATERIAL_COST_METHOD
- Specifies default costing method for inventory items
- Common values: Average, FIFO, LIFO

6. AVERAGE_COST_VARIANCE_ACCOUNT
- GL account for recording cost variances
- Used in standard cost environments

7. NEGATIVE_INVENTORY_ALLOWED_FLAG
- Controls whether negative inventory quantities are permitted
- 'Y' allows negative inventory
- 'N' prevents negative inventory

8. STOCK_LOCATOR_CONTROL_CODE
- Defines locator (subinventory) control level
- Manages item location tracking

Typical Use Cases:
- Configuring inventory organization parameters
- Defining costing and accounting rules
- Setting inventory control preferences

Related Tables:
- HR_ORGANIZATION_UNITS
- MTL_SYSTEM_ITEMS
- GL_CODE_COMBINATIONS

Recommendation:
Carefully configure this table during inventory organization setup to ensure proper inventory management and costing processes.