Search Results ams_object_rules_tl




Overview
Explore in AI Chat

Overview

AMS_OBJECT_RULES_TL is the translation ("TL") table for object rules within the Oracle EBS Marketing (AMS) module. In Oracle EBS multi-language architecture, base transactional and setup data resides in a "_B" table (here AMS_OBJECT_RULES_B), while user-facing, translatable descriptive text is stored in the corresponding "_TL" table. AMS_OBJECT_RULES_TL therefore holds the language-dependent attributes of object rules — those columns that must be presented in the session language of each user — while the language-independent columns remain in the base table.

The table is owned by the AMS schema and is documented as VALID in ETRM 12.2.2. Its physical schema contains twelve columns and is keyed by AMS_OBJECT_RULES_TL_PK on the composite (OBJECT_RULE_ID, LANGUAGE). Under the heuristic Data Vault classification mined from the foreign-key structure, this object is satellite-leaning: it hangs off the base entity AMS_OBJECT_RULES_B via OBJECT_RULE_ID and carries descriptive, context-dependent attributes rather than defining new business entities or relationships. This is a modeling suggestion, not a formal Data Vault declaration.

Key Information Stored

The table's most significant columns fall into three groups:

  • OBJECT_RULE_ID — The surrogate/foreign key linking each translation row to its parent rule in AMS_OBJECT_RULES_B. It forms part of the primary key.
  • LANGUAGE — The language code identifying which translation this row represents. Together with OBJECT_RULE_ID it constitutes the primary key AMS_OBJECT_RULES_TL_PK.
  • SOURCE_LANG — Indicates the source language of the row, used by the translation framework to track origin language.
  • OBJECT_RULE_NAME — The translatable display name of the object rule, presented to users in their session language.
  • DESCRIPTION — The translatable free-text description of the rule.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security-group access control on the row.
  • ZD_EDITION_NAME — Editioning column supporting Oracle EBS online patching (part of the unique index AMS_OBJECT_RULES_TL_U1).
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide standard Who-column auditing.

Business-key candidates are reflected in the unique index AMS_OBJECT_RULES_TL_U1 across (OBJECT_RULE_ID, LANGUAGE, ZD_EDITION_NAME), which mirrors the primary key plus the editioning discriminator.

Common Use Cases and Queries

Typical uses center on resolving translatable rule text for display and reporting in a specific language. A common pattern joins the translation table to its base table by OBJECT_RULE_ID and filters on LANGUAGE:

  • Retrieving rule names/descriptions for a user's session language: SELECT b.object_rule_id, t.object_rule_name, t.description FROM ams_object_rules_b b, ams_object_rules_tl t WHERE b.object_rule_id = t.object_rule_id AND t.language = USERENV('LANG');
  • Auditing translation coverage — identifying rules lacking a translation in a target language by outer-joining AMS_OBJECT_RULES_TL and testing for NULL names.
  • Security-scoped reporting by joining to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to restrict results to permitted operating units.
  • Data extraction for analytics or migration, selecting SOURCE_LANG and ZD_EDITION_NAME to preserve translation lineage across editions.

Related Objects

  • AMS_OBJECT_RULES_B — The base table; joined on OBJECT_RULE_ID. This is the principal parent relationship documented for AMS_OBJECT_RULES_TL.
  • FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for access-control enforcement.
  • FND_LANGUAGES — Supplies the valid LANGUAGE codes used in translation rows (via the language framework).
  • AMS_OBJECT_RULES_VL — The likely translation-enabled view that merges _B and _TL columns for user-facing queries.
  • FND_APPLICATION / AMS module objects — Broader Marketing metadata objects (rules, campaign objects) that consume object-rule definitions.

Together these objects form the rule-translation layer of the AMS Marketing data model.