Results for “xla_product_rules_tl”

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

Overview

The XLA_PRODUCT_RULES_TL table resides in the XLA schema (Subledger Accounting) and stores translated, language-dependent descriptive information about Application Accounting Definitions. It is the translation (TL) companion to the base XLA_PRODUCT_RULES_B table, holding the user-facing NAME and DESCRIPTION attributes for each product rule in every installed language. Product rules define how subledger transactions are accounted — the events, sources, and journal line types that determine the accounting generated for a given application context and product rule type.

Because it is a pure translation table, XLA_PRODUCT_RULES_TL carries no transactional or configuration logic of its own; it exists solely to render product rule metadata in the session language. The table belongs to the "standalone" Data Vault classification per the mined foreign key structure. As a modeling suggestion, this classifies the object as a standalone entity with no enforced parent-child link at the FK level; analysts designing a dimensional or Data Vault representation should treat the translation rows as descriptive attributes keyed by the parent product rule identity plus LANGUAGE, rather than as an independent hub.

Key Information Stored

The principal columns are:

• APPLICATION_ID — Identifies the owning application (e.g., Payables, Receivables, Assets) to which the product rule belongs.
• AMB_CONTEXT_CODE — The Accounting Methods Builder context code scoping the rule.
• PRODUCT_RULE_TYPE_CODE — Classifies the product rule type within the AMB framework.
• PRODUCT_RULE_CODE — The internal code uniquely identifying the product rule.
• LANGUAGE — The language of the translated NAME and DESCRIPTION.
• NAME — The translated display name of the Application Accounting Definition / product rule.
• DESCRIPTION — The translated descriptive text.
• SOURCE_LANG — The source language from which the translation was derived.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns tracking who created and last modified the row.
• ZD_EDITION_NAME — The edition identifier supporting edition-based redefinition and multi-version metadata.

The surrogate/business primary key is documented as XLA_PRODUCT_RULES_TL_PK over (APPLICATION_ID, AMB_CONTEXT_CODE, PRODUCT_RULE_TYPE_CODE, PRODUCT_RULE_CODE, LANGUAGE). Two additional unique indexes serve as business-key candidates: XLA_PRODUCT_RULES_TL_U1 extends the PK columns with ZD_EDITION_NAME, while XLA_PRODUCT_RULES_TL_U2 keys on (APPLICATION_ID, AMB_CONTEXT_CODE, PRODUCT_RULE_TYPE_CODE, NAME, LANGUAGE, ZD_EDITION_NAME), enforcing name uniqueness per context, type, and language.

Common Use Cases and Queries

Typical uses include resolving product rule names for a reporting language, auditing translation completeness across languages, and joining translated metadata to the base table. A representative query joining the base and translation tables is:

• SELECT b.application_id, b.product_rule_code, t.name, t.description, t.language FROM xla_product_rules_b b, xla_product_rules_tl t WHERE b.application_id = t.application_id AND b.amb_context_code = t.amb_context_code AND b.product_rule_type_code = t.product_rule_type_code AND b.product_rule_code = t.product_rule_code AND t.language = USERENV('LANG');
• Identify untranslated rules: compare row counts per LANGUAGE against the base table to find missing translations.
• Report all names for a given product rule across languages using the U2 business key to verify name consistency.

Related Objects

The following objects are most significant in relation to this table:

• XLA_PRODUCT_RULES_B — The base, language-independent table sharing the APPLICATION_ID, AMB_CONTEXT_CODE, PRODUCT_RULE_TYPE_CODE, and PRODUCT_RULE_CODE keys.
• XLA_AMB_CONTEXTS — Defines the AMB context referenced by AMB_CONTEXT_CODE.
• XLA_PRODUCT_RULE_TYPES — Defines PRODUCT_RULE_TYPE_CODE classifications.
• XLA_APPLICATIONS — Application master referenced by APPLICATION_ID.
• XLA_ACCOUNTING_DEFINITIONS / XLA_AA_DEFINITIONS — Higher-level Application Accounting Definitions that consume product rule metadata.
• FND_LANGUAGES — Reference table validating LANGUAGE and SOURCE_LANG values.
• XLA_PRODUCT_RULES_VL — The translatable view exposing base and translated columns together.