Search Results entity_org_id

Overview

MTL_MOVEMENT_PARAMETERS is an Oracle Inventory (INV) table that stores movement parameter values used to control the processing of inventory movements and movement statistics at the organization level. In Oracle EBS 12.1.1 and 12.2.2, the table functions as the organizational configuration master for movement-related logic, including period tracking for arrivals and dispatches, unit of measure conversion defaults, category set assignment, and tax office references. Each row is keyed by ENTITY_ORG_ID, meaning there is one parameter record per inventory organization (or entity organization) that participates in movement statistics.

Because the table is entirely controlled by its primary key column ENTITY_ORG_ID and holds descriptive configuration and last-processed period identifiers rather than transactional event data, its heuristic Data Vault classification as a standalone satellite is appropriate. It is best modeled as a satellite attached to an organization hub, capturing the changing configuration attributes of that organization over time. No foreign keys are defined from this table to other tables in the documented metadata, reinforcing its role as a reference/configuration satellite rather than a link.

Key Information Stored

The primary key of the table is ENTITY_ORG_ID, which uniquely identifies the inventory organization whose movement parameters are being defined. This is the sole documented unique key and is the principal join column for dependent objects.

• ENTITY_ORG_ID — surrogate primary key identifying the organization; also the business-key candidate for joining dependent movement statistics and ECE records.
• PERIOD_SET_NAME — the accounting period set used for movement and arrival/dispatch period tracking.
• WEIGHT_UOM_CODE — the unit of measure used for weight-related movement calculations.
• CONVERSION_TYPE and CONVERSION_OPTION — control how UOM conversions are performed for movement quantities.
• CATEGORY_SET_ID — the category set used to classify movement statistics or items involved in movements.
• LAST_ARRIVAL_PERIOD / LAST_ARRIVAL_ID — the last period and record identifier for which arrival movement statistics were processed.
• LAST_DISPATCH_PERIOD / LAST_DISPATCH_ID — the last period and record identifier for dispatch movement statistics.
• LAST_ARRIVAL_ADJ_PERIOD / LAST_ARRIVAL_ADJ_ID and LAST_DISPATCH_ADJ_PERIOD / LAST_DISPATCH_ADJ_ID — track the last processed adjustment periods for arrivals and dispatches.
• TAX_OFFICE_CODE, TAX_OFFICE_NAME, and TAX_OFFICE_LOCATION_ID — tax office information associated with the organization for movement reporting.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — the standard Oracle EBS descriptive flexfield (DFF) columns enabling extensibility without schema changes.

These fields allow the applications to resume movement processing from the correct period and apply consistent unit, category, and tax-office rules for each organization.

Common Use Cases and Queries

Typical use cases involve configuring or validating movement parameters for an organization, troubleshooting why movement statistics did not process for a period, and reporting on organization-level movement configuration.

To retrieve the movement parameters for a specific organization:

• SELECT entity_org_id, period_set_name, weight_uom_code, conversion_type, category_set_id, last_arrival_period, last_dispatch_period FROM mtl_movement_parameters WHERE entity_org_id = :org_id;

To list all organizations with their most recently processed movement periods:

• SELECT entity_org_id, last_arrival_period, last_dispatch_period FROM mtl_movement_parameters ORDER BY entity_org_id;

To join with dependent movement statistics for reconciliation:

• SELECT p.entity_org_id, s.period_name, s.transaction_quantity FROM mtl_movement_parameters p JOIN mtl_movement_statistics s ON s.entity_org_id = p.entity_org_id;

Reporting queries frequently combine these parameters with organization definitions (HR_OPERATING_UNITS or MTL_PARAMETERS) to present a consolidated organization-level movement configuration report. Because the table also carries DFF attributes, reports can expose organization-specific custom values captured in ATTRIBUTE1 through ATTRIBUTE30.

Related Objects

The documented foreign key relationships show that several tables reference MTL_MOVEMENT_PARAMETERS through the ENTITY_ORG_ID column. The most significant related objects include:

• MTL_MOVEMENT_STATISTICS — joined on ENTITY_ORG_ID; holds the aggregated movement statistics for each organization.
• ECE_MVSTO_HEADERS — joined on ENTITY_ORG_ID; represents movement statistics headers for the e-commerce gateway / ECE integration.
• ECE_MVSTO_DETAILS — joined on ENTITY_ORG_ID; holds movement statistics detail lines used in outbound movements typically for customs/tax reporting.
• MTL_PARAMETERS — while not documented as an FK, it is the general inventory organization parameter table that shares the organization dimension and is commonly queried alongside movement parameters.
• HR_OPERATING_UNITS / HR_ALL_ORGANIZATION_UNITS — provides the descriptive organization information for the ENTITY_ORG_ID values.
• MTL_SYSTEM_ITEMS_B and MTL_TRANSACTIONS — indirectly involved when movement statistics are derived from inventory transactions for the configured organization.

Together, these relationships establish MTL_MOVEMENT_PARAMETERS as the configuration anchor for movement statistics processing and the ECE movement statistics integration in Oracle Inventory.