Results for “mtl_mvt_stats_rule_sets_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTL_MVT_STATS_RULE_SETS_TL is the translation table that supports MTL_MVT_STATS_RULE_SETS_B within the Oracle Inventory (INV) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores language-specific, user-facing text for material movement statistics rule sets, which govern how Oracle Inventory aggregates and reports movement statistics such as receipts, issues, transfers, and adjustments. The "_TL" suffix denotes the translation layer of the standard Oracle EBS multi-language table pair: the base table (_B) holds language-independent attributes, while this table holds the translated display name and description keyed by language.

Each row represents one rule set code combined with one language, and the combination of rule set code and language uniquely identifies a record. The metadata describes this object as translation-oriented and relationship-classified in heuristic Data Vault terms as satellite-leaning: it carries descriptive, language-dependent attributes that depend on the parent business key rather than defining new business entities. In a Data Vault model it would therefore typically be modeled as a satellite attached to the rule set hub, not as an independent hub or link.

Key Information Stored

The table contains 11 documented columns. The most significant are:

• RULE_SET_CODE — the business identifier shared with the base table; part of the primary and unique keys and the foreign key to MTL_MVT_STATS_RULE_SETS_B.
• LANGUAGE — the language code for the translated row; combined with RULE_SET_CODE it uniquely identifies a translation record.
• SOURCE_LANG — the source language of the base record, used by the translation framework to indicate the original language of the untranslated content.
• RULE_SET_DISPLAY_NAME — the translated, user-visible name of the rule set shown in Inventory setup and reporting screens.
• RULE_SET_DESCRIPTION — the translated descriptive text for the rule set.
• CREATED_BY, CREATION_DATE — standard audit columns capturing record creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns capturing the most recent change.
• LAST_UPDATE_LOGIN — the login context associated with the last update.
• ZD_EDITION_NAME — the edition identifier supporting Oracle EBS edition-based redefinition and online patching, particularly relevant in 12.2.2.

The documented primary key is RULE_SET_PK, expressed over the columns RULE_SET_CODE and LANGUAGE. A unique index, MTL_MVT_STATS_RULE_SETS_TL_UK, is defined over RULE_SET_CODE, LANGUAGE, and ZD_EDITION_NAME, confirming the business-key candidate includes the edition column.

Common Use Cases and Queries

The primary use case is presenting rule set names and descriptions in the session or reporting language. Application logic joins this translation table to the base table on RULE_SET_CODE and filters by LANGUAGE to return localized text. A typical reporting query pattern is:

• SELECT b.rule_set_code, t.rule_set_display_name, t.rule_set_description FROM mtl_mvt_stats_rule_sets_b b, mtl_mvt_stats_rule_sets_tl t WHERE b.rule_set_code = t.rule_set_code AND t.language = USERENV('LANG').
• Localization audits that identify rule sets lacking a translation for a given language by comparing distinct LANGUAGE values against the base table rows.
• Setup verification reports that list all defined rule sets with their translated names for a chosen language.
• Upgrade and patching validation in 12.2.2, where filtering on ZD_EDITION_NAME ensures queries resolve to the correct edition.

Related Objects

• MTL_MVT_STATS_RULE_SETS_B — the base table; joined on RULE_SET_CODE and the direct foreign key target of this translation table.
• MTL_MVT_STATS_RULE_SETS_TL — its own unique index MTL_MVT_STATS_RULE_SETS_TL_UK and primary key RULE_SET_PK enforce key integrity.
• MTL_MOVEMENT_STATISTICS — the movement statistics data that rule sets control and categorize.
• MTL_MVT_STATS_DEFAULT_RULES — default rule assignments that reference rule sets for automatic categorization.
• FND_LANGUAGES — the language definition table referenced conceptually by the LANGUAGE and SOURCE_LANG columns.
• Standard Inventory movement statistics concurrent programs and lookup views that consume the localized rule set names when generating reports.