Search Results wcs_enabled

Overview

MTL_PARAMETERS_VIEW is an APPS-owned database view in the Oracle E-Business Suite Inventory (INV) product. It is documented in ETRM as a retrofitted object, meaning it was introduced or re-engineered to provide a stabilized, security-aware projection of inventory organization parameters across release levels. In EBS 12.1.1 and 12.2.2 the view serves as the principal read interface for organization-level Inventory setup: cost method, valuation accounts, locator and subinventory defaults, lot and serial controls, ATP and picking rules, inter-org transfer behavior, and the attributes and DFF columns that support extension.

Because it consolidates parameters that are otherwise spread across MTL_PARAMETERS, cost group definitions, HR organization units, and lookup tables, the view is heavily used by reports, concurrent programs, and inbound integrations that must resolve the operating configuration of a warehouse or costing organization without joining each base entity separately. The view also applies HR security and organization hierarchy logic, so queries against it respect the organization access of the connected user.

Underlying Base Objects

The documented base objects behind the view are: BOM_RESOURCES, CST_COST_GROUPS, FND_COMMON_LOOKUPS, FND_GLOBAL, HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, HR_GENERAL, HR_ORG_UNITS_NO_JOIN, HR_SECURITY, MFG_LOOKUPS, MTL_ATP_RULES, MTL_PARAMETERS, WMS_CROSSDOCK_CRITERIA_VL, and WMS_RULES_VL. Most are referenced through public synonyms or subordinate views.

• MTL_PARAMETERS supplies the core row per organization, including PRIMARY_COST_METHOD, COST_ORGANIZATION_ID, DEFAULT_MATERIAL_COST_ID, NEGATIVE_INV_RECEIPT_CODE, MATERIAL_ACCOUNT, and the range of valuation accounts.
• HR_ALL_ORGANIZATION_UNITS and its _TL and NO_JOIN variants provide the organization definition and translated name; HR_SECURITY and HR_GENERAL enforce access; FND_GLOBAL supplies session context such as organization and user identifiers.
• MFG_LOOKUPS and FND_COMMON_LOOKUPS resolve code meanings; CST_COST_GROUPS links costing configuration; MTL_ATP_RULES supplies the default ATP rule; BOM_RESOURCES supports resource-related defaults; and the WMS views contribute crossdock and warehouse rule references.

Key Columns

The view exposes the full MTL_PARAMETERS column set with an added ROWID alias and ORGANIZATION_CODE. Notable columns include ORGANIZATION_ID, MASTER_ORGANIZATION_ID, PRIMARY_COST_METHOD, COST_ORGANIZATION_ID, DEFAULT_MATERIAL_COST_ID, CALENDAR_CODE and CALENDAR_EXCEPTION_SET_ID, GENERAL_LEDGER_UPDATE_CODE, DEFAULT_ATP_RULE_ID, DEFAULT_PICKING_RULE_ID, DEFAULT_LOCATOR_ORDER_VALUE and DEFAULT_SUBINV_ORDER_VALUE, NEGATIVE_INV_RECEIPT_CODE and STOCK_LOCATOR_CONTROL_CODE.

The accounting block covers MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, MATL_OVHD_ABSORPTION_ACCT, RESOURCE_ACCOUNT, PURCHASE_PRICE_VAR_ACCOUNT, AP_ACCRUAL_ACCOUNT, OVERHEAD_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, INTRANSIT_INV_ACCOUNT, INTERORG_RECEIVABLES_ACCOUNT, INTERORG_PRICE_VAR_ACCOUNT, INTERORG_PAYABLES_ACCOUNT, COST_OF_SALES_ACCOUNT, ENCUMBRANCE_ACCOUNT, INTERORG_TRANSFER_CR_ACCOUNT, INVOICE_PRICE_VAR_ACCOUNT, AVERAGE_COST_VAR_ACCOUNT, SALES_ACCOUNT, and EXPENSE_ACCOUNT. Lot and serial governance is expressed by SERIAL_NUMBER_TYPE, SERIAL_NUMBER_GENERATION, AUTO_SERIAL_ALPHA_PREFIX, START_AUTO_SERIAL_NUMBER, LOT_NUMBER_UNIQUENESS, LOT_NUMBER_GENERATION, LOT_NUMBER_ZERO_PADDING, LOT_NUMBER_LENGTH, and STARTING_REVISION. Inter-org movement is governed by MATL_INTERORG_TRANSFER_CODE, INTERORG_TRNSFR_CHARGE_PERCENT, SOURCE_ORGANIZATION_ID, SOURCE_SUBINVENTORY, and SOURCE_TYPE. ATTRIBUTE1 through ATTRIBUTE15, ATTRIBUTE_CATEGORY, and the audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) complete the projection, along with REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE. Although a COST_CUTOFF_DATE column is sometimes anticipated by users searching on that term, it is not part of the documented view text; cutoff-related behavior is generally represented elsewhere, such as the perpetual costing period close interface, not in this inventory parameter view.

Common Use Cases and Queries

Typical uses include resolving the cost method and valuation accounts for an organization during accounting reconciliation, validating lot and serial setup before data conversion, and driving inter-org transfer logic in integration programs.

• Retrieve costing configuration: SELECT organization_id, organization_code, primary_cost_method, cost_organization_id, default_material_cost_id FROM mtl_parameters_view WHERE organization_id = :org_id;
• List valuation accounts: SELECT organization_code, material_account, cost_of_sales_account, purchase_price_var_account FROM mtl_parameters_view ORDER BY organization_code;
• Check lot and serial controls: SELECT organization_code, serial_number_control_code, lot_number_uniqueness, lot_number_generation, start_auto_serial_number FROM mtl_parameters_view;
• Resolve transfer defaults: SELECT organization_code, matl_interorg_transfer_code, interorg_trnsfr_charge_percent, source_organization_id, source_subinventory FROM mtl_parameters_view WHERE source_type IS NOT NULL;

Because access is filtered through HR security, integrations should set the FND_GLOBAL organization context before querying, and should treat the view as read-only. Joins back to MTL_PARAMETERS are unnecessary unless a column is absent from the projection; the view already carries the complete parameter set and DFF attributes required by most custom reporting and interface logic in both 12.1.1 and 12.2.2.