Results for “fa_rx_rep_columns_tl_pk”

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

Overview

FA_RX_REP_COLUMNS_TL is a translated (Multi-Lingual Support, MLS) table in the Oracle Assets (OFA) module of Oracle E-Business Suite, owned by the FA schema. It stores the language-specific, translated attribute definitions for Report eXchange report attributes. Report eXchange is the Oracle Assets reporting framework that allows organizations to define custom asset reports by selecting and arranging asset attributes. While the companion table FA_RX_REP_COLUMNS_B holds the base (untranslated) definitions, this _TL table carries the descriptive text — such as the display name of an attribute — in each installed language.

In Data Vault modeling terms, the mined foreign-key structure classifies this object as satellite-leaning. It is a descriptive, attribute-bearing table that hangs off the FA_RX_REP_COLUMNS_B base table, which functions as the anchor or hub. The _TL table therefore serves as the source of translated descriptive context rather than as an independent business entity or a linking relationship.

Key Information Stored

The table contains twelve documented columns. The primary key, FA_RX_REP_COLUMNS_TL_PK, is a composite surrogate key composed of REPORT_ID, ATTRIBUTE_SET, COLUMN_NAME, and LANGUAGE. The true business-key candidate is captured by the unique index FA_RX_REP_COLUMNS_TL_U1, which spans REPORT_ID, ATTRIBUTE_SET, COLUMN_NAME, LANGUAGE, and ZD_EDITION_NAME — the last reflecting the editioning column introduced in EBS 12.2.

• REPORT_ID — Identifies the Report eXchange report definition; part of the primary key and the FK to the base table.
• ATTRIBUTE_SET — The attribute set grouping to which the column belongs; part of the primary key.
• COLUMN_NAME — The internal technical name of the report attribute; part of the primary key.
• LANGUAGE — The language code of the translated row; part of the primary key and the MLS discriminator.
• SOURCE_LANG — The source language of the base record from which the translation derives.
• ATTRIBUTE_NAME — The translated, user-visible display name of the attribute, the primary descriptive payload of the table.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent modification.
• CREATION_DATE, CREATED_BY — Standard WHO audit columns recording the original insert.
• ZD_EDITION_NAME — Editioning column supporting EBS 12.2 online patching and edition-based redefinition.

Common Use Cases and Queries

Typical usage centers on resolving the localized display name of a report attribute alongside its base definition. A standard join pattern is:

• SELECT b.report_id, b.column_name, t.attribute_name FROM fa_rx_rep_columns_b b, fa_rx_rep_columns_tl t WHERE b.report_id = t.report_id AND b.attribute_set = t.attribute_set AND b.column_name = t.column_name AND t.language = USERENV('LANG');
• Reporting on translated attribute labels for a specific report to build localized report layouts or documentation.
• Auditing which attributes have been translated into which languages by grouping on LANGUAGE and comparing row counts against the base table.
• Verifying completeness of MLS translations, ensuring every base attribute has a corresponding _TL row for each active language.

Related Objects

• FA_RX_REP_COLUMNS_B — The base table; the FK maps FA_RX_REP_COLUMNS_TL.REPORT_ID, .COLUMN_NAME, and .ATTRIBUTE_SET to the corresponding base columns. This is the primary join partner.
• FA_RX_REPORTS_TL / FA_RX_REPORTS_B — The parent Report eXchange report definitions that REPORT_ID ultimately references.
• FA_RX_ATTRIBUTE_SETS — Defines the attribute sets referenced by ATTRIBUTE_SET.
• FND_LANGUAGES — Provides the valid values resolved through the LANGUAGE column for MLS joins.
• FA_RX_REP_COLUMNS_TL_PK / _U1 — The primary key and unique business-key index governing row identity.

Together these objects form the metadata backbone of the Oracle Assets Report eXchange framework.