Search Results hz_fin_reports_ext_tl




Overview
Explore in AI Chat

Overview

HZ_FIN_REPORTS_EXT_TL is a translation (TL) table owned by the AR (Receivables) schema in Oracle E-Business Suite. It provides multilingual support for extensible financial report attributes, allowing descriptive and user-defined report metadata to be presented in multiple installed languages. The table is classified as VALID and is present in both EBS 12.1.1 and 12.2.2.

Based on the foreign key structure, the heuristic Data Vault classification for this object is that of a link table. It connects a financial report entity (HZ_FINANCIAL_REPORTS) to the language dimension (FND_LANGUAGES), carrying descriptive translated attributes. This classification is a modeling suggestion derived from the FK topology, not a formally declared Data Vault construct.

Key Information Stored

  • EXTENSION_ID — Surrogate identifier for the extensible attribute record; part of the composite primary key (HZ_FIN_REPORTS_EXT_TL_PK).
  • LANGUAGE — The language code for the translated row; the second component of the primary key and a foreign key to FND_LANGUAGES.
  • FINANCIAL_REPORT_ID — Foreign key to HZ_FINANCIAL_REPORTS, linking the extension back to its parent financial report.
  • ATTR_GROUP_ID — Identifier for the attribute grouping to which the extensible attributes belong.
  • SOURCE_LANG — The source language from which the translation was derived.
  • TL_EXT_ATTR1 through TL_EXT_ATTR20 — Twenty translatable extensible attribute columns holding the language-specific descriptive content of the financial report extension.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified each row, and when.

The documented unique index HZ_FIN_REPORTS_EXT_TL_U1 (EXTENSION_ID, LANGUAGE) confirms the composite business-key candidate, which mirrors the primary key structure. The table is documented with 30 physical columns in ETRM 12.2.2.

Common Use Cases and Queries

This table is primarily queried in reporting and integration contexts where financial report extension attributes must be displayed in a specific language. Typical scenarios include multi-language financial statement reporting, localization of custom report metadata, and extraction of translated attributes for downstream analytics.

A representative query joining the extension to its parent report and filtering by language:

  • SELECT t.extension_id, t.financial_report_id, t.language, t.tl_ext_attr1, t.tl_ext_attr2 FROM hz_fin_reports_ext_tl t WHERE t.language = USERENV('LANG') ;
  • To retrieve all translations for a given report: SELECT * FROM hz_fin_reports_ext_tl t WHERE t.financial_report_id = :report_id ORDER BY t.language ;
  • To validate referential integrity against the parent: join to HZ_FINANCIAL_REPORTS r ON r.financial_report_id = t.financial_report_id.

Because translation tables in EBS often expose a _VL view that resolves the language based on session settings, developers should prefer the corresponding view where available for reporting rather than querying the base TL table directly.

Related Objects

  • HZ_FINANCIAL_REPORTS — Parent entity; joined via HZ_FIN_REPORTS_EXT_TL.FINANCIAL_REPORT_ID = HZ_FINANCIAL_REPORTS.FINANCIAL_REPORT_ID.
  • FND_LANGUAGES — Language dimension; joined via HZ_FIN_REPORTS_EXT_TL.LANGUAGE = FND_LANGUAGES.LANGUAGE_CODE.
  • HZ_FIN_REPORTS_EXT_B — The base (language-independent) table that the TL table translates, linked by EXTENSION_ID.
  • HZ_FIN_REPORTS_EXT_TL_PK / HZ_FIN_REPORTS_EXT_TL_U1 — Primary key and unique index enforcing the composite key on EXTENSION_ID and LANGUAGE.
  • FND_FLEX_* and attribute group utilities — Supporting objects that define the extensible attribute framework referenced by ATTR_GROUP_ID and the TL_EXT_ATTR columns.

Together with its base table, this object forms the multilingual extension layer of Oracle Receivables financial reporting.