Results for “ahl_mc_rules_tl”

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

Overview

AHL_MC_RULES_TL is the translation (TL) table for Maintenance Crew Rules within the Oracle E-Business Suite product AHL — Complex Maintenance Repair and Overhaul (CMRO). In the Oracle EBS multilanguage architecture, every translatable entity is split into a base table that stores language-independent columns and a companion _TL table that stores the language-dependent descriptive attributes keyed by a language code. AHL_MC_RULES_TL holds the translated user-facing text (principally the rule description) for each maintenance-crew rule defined in the base table AHL_MC_RULES_B, enabling a single rule definition to present localized text to users working in different installed languages.

The object resides in the AHL schema, carries a VALID status, and is documented in ETRM for both release 12.1.1 and 12.2.2 with a physical column count of ten. Its primary key, AHL_MC_RULES_TL_PK, is composed of RULE_ID and LANGUAGE, which is the canonical translation-table pattern: the entity identifier joined to the language code. The heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning; from a modeling perspective this table behaves as a descriptive satellite attached to the rule hub, carrying attribute history/context scoped to a language dimension rather than introducing new business entities or relationships.

Key Information Stored

Only ten columns are documented for this table, and the most consequential are:

• RULE_ID — surrogate identifier of the parent maintenance-crew rule; the component that links the translation row back to the base rule definition.
• LANGUAGE — the language code (for example US for American English) identifying which installed language the row's text belongs to.
• DESCRIPTION — the translated long description of the rule; this is the primary payload the table exists to store.
• SOURCE_LANG — the language in which the source text was originally authored; used by the translation and multi-language infrastructure to determine whether the row is the original or a translated variant.
• SECURITY_GROUP_ID — the operating-unit/multi-org security group to which the row is scoped, referenced from FND_SECURITY_GROUPS.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard Oracle EBS "Who" audit columns recording when and by whom the translation row was created and last modified.

The surrogate primary key is the composite (RULE_ID, LANGUAGE). The unique index AHL_MC_RULES_TL_U1 (RULE_ID, LANGUAGE) is the documented business-key candidate, enforcing that at most one translation row may exist per rule per language. Note that the metadata's foreign-key listing shows RULE_ID mapping to a placeholder ("%"), indicating the reference into the base rule table, and SECURITY_GROUP_ID referencing FND_SECURITY_GROUPS.

Common Use Cases and Queries

The principal use case is localized display of maintenance-crew rule text. Applications join the base rule table to this translation table on RULE_ID and filter by the session language, falling back to the source language when a translation is absent. Reporting and validation queries typically detect missing translations or orphaned TL rows:

• Retrieve the description of a rule in a specific language, joining base to TL on RULE_ID where LANGUAGE = :p_lang.
• Identify rules that have no row for a target language, to drive translation maintenance.
• Audit who last changed a rule's translated text using LAST_UPDATED_BY and LAST_UPDATE_DATE.
• Scope translated rule listings to a security group via SECURITY_GROUP_ID for multi-org deployments.

A representative pattern is a base-to-translation join: select the rule columns from the base table and the DESCRIPTION from AHL_MC_RULES_TL, restricting on the desired LANGUAGE and SOURCE_LANG as appropriate.

Related Objects

The most significant related objects, grounded in the documented relationship data, include:

• AHL_MC_RULES_B (or the corresponding base rule table) — the language-independent parent referenced by RULE_ID; joined on RULE_ID.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for multi-org security scoping.
• AHL_MC_RULES_TL_PK — the composite primary key enabling direct lookup by rule and language.
• AHL_MC_RULES_TL_U1 — the unique index enforcing one translation per rule per language.
• FND_LANGUAGES — the reference list of installed languages that qualifies the LANGUAGE and SOURCE_LANG columns.
• Application-tier APIs and concurrent programs in the AHL module that maintain crew-rule metadata and depend on the translation rows for display.

Together these objects form a hub-and-satellite style cluster in which AHL_MC_RULES_TL supplies the localized descriptive attributes for the maintenance-crew rule entity.