Search Results mr_action_id




Overview
Explore in AI Chat

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

Overview

AHL_MR_ACTIONS_TL is the translation table for maintenance requirement and action associations within the Oracle E-Business Suite (EBS) Complex Maintenance Repair and Overhaul (AHL) module. It is owned by the AHL schema and holds the language-specific descriptive text that accompanies the base definitions stored in AHL_MR_ACTIONS_B. Because Oracle EBS employs a multilingual architecture that separates language-independent data from translated text, this table mirrors the standard "_TL" pattern used throughout the applications, storing one row per installed language for each associated action record.

Maintenance requirements describe scheduled or mandated work activities, and actions define the specific steps performed against those requirements in a maintenance, repair, or overhaul workflow. AHL_MR_ACTIONS_TL allows these action descriptions to be presented to end users in their session language without duplicating the underlying transactional structure.

Under the heuristic Data Vault classification derived from the foreign key structure, this table is characterized as satellite-leaning. This is a modeling suggestion: it behaves as a descriptive satellite that depends on its parent hub or link for identity, carrying attribute-level content (translated text) rather than defining new business entities on its own.

Key Information Stored

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

  • MR_ACTION_ID — The foreign key linking to AHL_MR_ACTIONS_B, identifying the base maintenance requirement and action association that this row translates.
  • LANGUAGE — The installed language code for the translated text, forming part of the composite primary key.
  • DESCRIPTION — The language-specific description of the action, the primary payload of this translation table.
  • SOURCE_LANG — The source language from which the translation originated, used by the translation framework to track derivation.
  • SECURITY_GROUP_ID — References FND_SECURITY_GROUPS and supports multi-tenant data segregation across operating units.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who created and last modified the row and when.

The composite primary key, AHL_MR_ACTIONS_TL_PK, is defined on (LANGUAGE, MR_ACTION_ID). A separate unique index, AHL_MR_ACTIONS_TL_U1, is defined on (MR_ACTION_ID, LANGUAGE), representing the business-key candidate that guarantees a single translation per action per language. Together these enforce the one-description-per-language constraint central to the translation model.

Common Use Cases and Queries

Reporting and integration scenarios typically join the translation table to the base table to retrieve language-appropriate descriptions. A representative query joins the base action definition to its translation filtered by session language:

  • Retrieving action descriptions for a specific language: SELECT t.description FROM ahl_mr_actions_tl t WHERE t.mr_action_id = :id AND t.language = USERENV('LANG').
  • Auditing translation coverage: identify base action rows in AHL_MR_ACTIONS_B lacking a matching translation row in the _TL table.
  • Extracting translated content for data warehousing or external reporting where descriptions must be resolved per locale.
  • Verifying security-group-scoped visibility when operating units partition maintenance data.

Because the table is a pure satellite, write operations generally occur through the AHL maintenance requirement and action forms, which manage the base and translation rows in tandem.

Related Objects

The table's dependencies center on its parent and the security framework, though it participates in broader AHL and foundation object relationships:

  • AHL_MR_ACTIONS_B — The base table joined on MR_ACTION_ID; it holds the language-independent action association data.
  • AHL_MR_ACTIONS_TL (self-reference via unique index) — ensures the one-row-per-language rule.
  • FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for multi-tenant segregation.
  • AHL_MR_HEADERS / AHL_MR_ACTIONS — Parent maintenance requirement structures that contextualize the actions being translated.
  • FND_LANGUAGES — Provides the valid LANGUAGE values installed in the instance.

These relationships confirm that AHL_MR_ACTIONS_TL is a dependent satellite, fully subordinate to AHL_MR_ACTIONS_B for its identity and to the foundation security and language model for its scope and validity.