Results for “ahl_approval_rules_tl”

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

Overview

AHL_APPROVAL_RULES_TL is the translation (TL) table for approval rules within the AHL - Complex Maintenance Repair and Overhaul product module of Oracle EBS 12.1.1 and 12.2.2. In the Oracle E-Business Suite multilanguage architecture, every translatable entity is implemented as a pair of tables: a base table (suffix _B) that stores language-independent data and operational columns, and a translation table (suffix _TL) that stores the language-dependent descriptive attributes for each supported installed language. AHL_APPROVAL_RULES_TL fulfills the _TL role for approval rules, holding the translatable text associated with each approval rule defined in AHL_APPROVAL_RULES_B.

The object is owned by the AHL schema and is documented as VALID in ETRM. It contains 12 documented columns in the 12.2.2 physical schema. Based on the foreign key structure mined from the schema, the heuristic Data Vault classification for this object is satellite-leaning: its rows carry descriptive, language-dependent attributes keyed by a parent business entity, which is characteristic of a satellite table attached to a hub or link. Under this modeling suggestion, AHL_APPROVAL_RULES_B acts as the parent (hub-like) entity and AHL_APPROVAL_RULES_TL behaves as the descriptive satellite that hangs off it.

Key Information Stored

The most significant columns in AHL_APPROVAL_RULES_TL are the following:

• APPROVAL_RULE_ID — The identifier of the approval rule being translated. This is the join column to the base table AHL_APPROVAL_RULES_B and forms part of the composite primary key.
• LANGUAGE — The language code for the translated row, forming the second component of the composite primary key.
• APPROVAL_RULE_NAME — The translated name of the approval rule, the primary user-visible descriptive attribute.
• DESCRIPTION — The translated long description of the approval rule.
• SOURCE_LANG — The language of the source row from which the translation was derived, used by the multilanguage translation framework.
• ZD_EDITION_NAME — The edition identifier used by the Oracle EBS Editioning (ZD) feature, present in 12.2.x schemas.
• SECURITY_GROUP_ID — A foreign key to FND_SECURITY_GROUPS, controlling row-level access to the record.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — The standard Oracle EBS who-columns that record audit and concurrent-program context for the row.

The surrogate primary key is AHL_APPROVAL_RULES_TL_PK, defined over (APPROVAL_RULE_ID, LANGUAGE). APPROVAL_RULE_ID is simultaneously the foreign key to AHL_APPROVAL_RULES_B, meaning the surrogate identifier is inherited from the parent entity rather than generated locally. The combination of the rule identifier and the language code constitutes the business-key candidate that guarantees one translated row per rule per language.

Common Use Cases and Queries

Typical usage of this table involves retrieving the translated name and description of an approval rule for the session language while joining to the base table for the language-independent attributes. A representative query pattern is:

• Joining to resolve translations: SELECT b.approval_rule_id, t.approval_rule_name, t.description FROM ahl_approval_rules_b b, ahl_approval_rules_tl t WHERE b.approval_rule_id = t.approval_rule_id AND t.language = USERENV('LANG').
• Finding untranslated rules: outer-joining AHL_APPROVAL_RULES_B to this table for a target language and filtering on NULL name values, to identify gaps in translation coverage.
• Reporting on configured approval rules in the user's language for maintenance and repair approval configuration screens.
• Auditing translation changes by querying LAST_UPDATED_BY and LAST_UPDATE_DATE restricted to a language and date range.

Related Objects

• AHL_APPROVAL_RULES_B — The base table holding language-independent data; joined on APPROVAL_RULE_ID. The FK AHL_APPROVAL_RULES_TL.APPROVAL_RULE_ID references this table, making it the primary parent of the translation rows.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID and used for row-level security filtering.
• FND_LANGUAGES — The installed-language repository against which the LANGUAGE column values are validated in practice.
• AHL_APPROVAL_RULES_TL_PK — The primary key constraint enforcing uniqueness of (APPROVAL_RULE_ID, LANGUAGE).
• AHL_APPROVAL_RULE_ASSIGNMENTS and related AHL approval configuration objects — downstream consumers that surface approval rules, using the base and translation tables together to present rules to users.
• Multilanguage (MLS) views over the _B/_TL pair, used by the EBS translation framework to present translated approval rule data.