Results for “hz_fin_numbers_ext_tl”

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

Overview

HZ_FIN_NUMBERS_EXT_TL is a translation (TL) table in the Oracle E-Business Suite Receivables (AR) schema. It provides multilingual support for extensible financial number attributes defined against the HZ_FINANCIAL_NUMBERS entity. In EBS 12.1.1 and 12.2.2 the table follows the standard Oracle Applications MLS pattern, storing one row per extension record per installed language, so that user-defined descriptive attribute values can be presented in the session language while the base (source) values remain anchored on the underlying non-translated table.

From a Data Vault modeling perspective, the metadata (a composite primary key of EXTENSION_ID and LANGUAGE, combined with foreign keys to HZ_FINANCIAL_NUMBERS and FND_LANGUAGES) suggests a link classification: the table associates a financial number, an attribute group, and a language. It should be regarded as a modeling suggestion only, since the object is a transactional MLS child table rather than a formally modeled Data Vault construct.

Key Information Stored

The surrogate primary key is defined by HZ_FIN_NUMBERS_EXT_TL_PK over (EXTENSION_ID, LANGUAGE). A unique index, HZ_FIN_NUMBERS_EXT_TL_U1, covers the same (EXTENSION_ID, LANGUAGE) combination and serves as the business-key candidate for the extension row in a given language.

• EXTENSION_ID — Surrogate identifier of the translated extension record; part of the primary key and unique index.
• LANGUAGE — Installed language code from FND_LANGUAGES; second component of the primary key, determining the row's translation context.
• FINANCIAL_NUMBER_ID — Foreign key to HZ_FINANCIAL_NUMBERS; ties the translated attributes to a specific financial number.
• SOURCE_LANG — The language in which the source attribute values were originally entered, used by MLS processing to determine translation status.
• ATTR_GROUP_ID — Identifies the extensible attribute group to which the translated attributes belong.
• TL_EXT_ATTR1 through TL_EXT_ATTR20 — Twenty translated attribute columns holding the language-specific values of the extensible financial number attributes; these are the columns a user views or reports on in a given language.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording row creation and update context.

The documented physical schema lists 30 columns in total; the table carries no descriptive flexfield segment columns of its own beyond the TL_EXT_ATTR series, and all translated text resides in those attribute columns.

Common Use Cases and Queries

Typical usage centers on retrieving extensible financial number attributes in a specific language, auditing translation completeness, and reporting across languages.

• Retrieve translated attributes for a financial number in the session language:
  SELECT t.extension_id, t.tl_ext_attr1, t.tl_ext_attr2 FROM hz_fin_numbers_ext_tl t WHERE t.financial_number_id = :p_id AND t.language = USERENV('LANG');
• Identify rows lacking a translation for a required language by comparing the base table against this TL table on FINANCIAL_NUMBER_ID and LANGUAGE.
• Join to HZ_FINANCIAL_NUMBERS to display the untranslated number alongside its translated descriptive attributes for reporting.
• Validate that SOURCE_LANG and LANGUAGE differ correctly, to detect rows still pending translation.

Related Objects

• HZ_FINANCIAL_NUMBERS — Parent entity; joined on HZ_FIN_NUMBERS_EXT_TL.FINANCIAL_NUMBER_ID = HZ_FINANCIAL_NUMBERS.FINANCIAL_NUMBER_ID.
• FND_LANGUAGES — Reference table for installed languages; joined on HZ_FIN_NUMBERS_EXT_TL.LANGUAGE = FND_LANGUAGES.LANGUAGE_CODE.
• HZ_FIN_NUMBERS_EXT — The base (non-translated) extension table holding the primary language rows.
• FND_TERRITORIES — Frequently joined for language/territory reporting scenarios.
• AR/HZ Receivables APIs — Financial number maintenance APIs and concurrent programs that populate and maintain these extension attributes.