Search Results ar_cmgt_dnb_elements_tl_n1




Overview
Explore in AI Chat

Overview

The table AR.AR_CMGT_DNB_ELEMENTS_TL is a multilingual support (MLS) table within the Oracle Receivables schema (AR). It stores the translated and language-specific definitions of Dun & Bradstreet (D&B) data elements that are displayed within a case folder in Oracle Credit Management. Its central purpose is to permit organizations to store, display, and print credit data element names in multiple languages, so that the same underlying data element can be presented with a localized label appropriate to a given session language.

Physically, the table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10. It is classified as VALID and is registered in FND Design Data as AR.AR_CMGT_DNB_ELEMENTS_TL. The documented primary key is AR_CMGT_DNB_ELEMENTS_TL_PK, defined over (DATA_ELEMENT_ID, LANGUAGE). From a Data Vault modeling perspective, this object is best characterized as a reference or descriptive satellite: it carries descriptive, language-dependent attributes (the element name) attached to the business key of a D&B data element, qualified by the language code. The heuristic classification of this object is standalone, meaning it does not participate in foreign key relationships with other documented tables and functions primarily as a lookup and descriptive store keyed on the data element identifier and language.

Key Information Stored

The most important columns capture the identity, language context, and descriptive naming of each D&B data element, together with standard audit columns.

  • DATA_ELEMENT_ID (NUMBER, 15) — The identifier of the D&B data element. This forms the surrogate primary key component and is the business-key candidate that links the row to the parent data element.
  • LANGUAGE (VARCHAR2) — The installation language code in which the row's name is stored. This is the second component of the primary key and the discriminator that makes the table multilingual.
  • DATA_ELEMENT_NAME (VARCHAR2, 60) — The translated, displayable name of the D&B data element. This is the principal descriptive attribute surfaced in the case folder.
  • SOURCE_LANG (VARCHAR2) — The source language from which a translation originates, supporting MLS maintenance.
  • OBJECT_VERSION_NUMBER (NUMBER) — Optimistic locking column used to detect concurrent updates.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Who columns tracking row creation and modification.

The unique index AR_CMGT_DNB_ELEMENTS_TL_U1 is documented on the combination (DATA_ELEMENT_ID, LANGUAGE, ZD_EDITION_NAME), which serves as the business-key candidate enforcing one name per element per language per edition. A nonunique index, AR_CMGT_DNB_ELEMENTS_TL_N1, exists on (DATA_ELEMENT_NAME, LANGUAGE) to support name-based lookup. Note that ZD_EDITION_NAME appears among the eleven documented columns and participates in the unique key, reflecting the edition-aware MLS design.

Common Use Cases and Queries

This table is queried primarily to resolve the display name of a D&B data element for the current language, or to audit the available translations for a given element. A typical MLS join filters by the session language:

  • Resolve display names by language: SELECT d.DATA_ELEMENT_ID, d.DATA_ELEMENT_NAME FROM AR.AR_CMGT_DNB_ELEMENTS_TL d WHERE d.LANGUAGE = USERENV('LANG');
  • List all translations for one element: SELECT DATA_ELEMENT_ID, LANGUAGE, DATA_ELEMENT_NAME FROM AR.AR_CMGT_DNB_ELEMENTS_TL WHERE DATA_ELEMENT_ID = :element_id ORDER BY LANGUAGE;
  • Audit recently changed names: SELECT DATA_ELEMENT_ID, LANGUAGE, DATA_ELEMENT_NAME, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM AR.AR_CMGT_DNB_ELEMENTS_TL WHERE LAST_UPDATE_DATE > SYSDATE - 30;
  • Reporting: joining this table to the base element definition to produce credit management case folder labels in a chosen locale, and to verify that no translation is missing for a required language.

Related Objects

The ETRM metadata indicates that AR.AR_CMGT_DNB_ELEMENTS_TL does not reference another parent object through a documented foreign key, and the heuristic classifies it as standalone. Relationship analysis therefore relies on the shared business key rather than enforced FK constraints.

  • AR.AR_CMGT_DNB_ELEMENTS_B / base element table — The presumed base table holding the non-translated D&B data element definition, joined on DATA_ELEMENT_ID.
  • AR_CMGT_DNB_ELEMENTS_TL — shares the primary key structure (DATA_ELEMENT_ID, LANGUAGE) through AR_CMGT_DNB_ELEMENTS_TL_PK and unique index U1.
  • FND_USER — referenced indirectly through LAST_UPDATED_BY and CREATED_BY.
  • FND_LOGINS — referenced indirectly through LAST_UPDATE_LOGIN.
  • FND Languages / FND_LANGUAGES — provides the valid LANGUAGE and SOURCE_LANG codes.
  • Oracle Credit Management case folder views — consume DATA_ELEMENT_NAME to render localized labels.
  • Oracle Receivables MLS infrastructure — governs the edition-aware behavior implied by ZD_EDITION_NAME.