Search Results ar_cmgt_dnb_elements_tl_pk

Overview

The AR_CMGT_DNB_ELEMENTS_TL table is an Oracle Receivables (AR) table that provides multilingual support (MLS) for all Dun & Bradstreet (D&B) data points displayed in a case folder within Oracle Credit Management. Oracle Credit Management enables credit analysts to create and manage case folders that consolidate credit data about customers, and D&B data points form a significant portion of that external credit intelligence. Because Oracle EBS operates in global deployments where users may speak different languages, MLS lets organizations store and print D&B element names in multiple languages using a single logical record keyed by language code.

From a Data Vault modeling perspective, ETRM's heuristic classification for this object is standalone. This suggests the table functions most naturally as a satellite-like translation store: it carries descriptive attributes (the translated data element name) attached to a business key, without being part of a broader hub-and-link network. The table has no outbound foreign keys documented, so it is referenced rather than referencing. The object is marked VALID in the AR schema and is documented in ETRM for release 12.2.2 with an 11-column physical schema.

Key Information Stored

The table's structure separates the translation payload from its identifying keys:

• DATA_ELEMENT_ID — Surrogate identifier for the D&B data element. It is the first component of the primary key AR_CMGT_DNB_ELEMENTS_TL_PK and one of the business-key candidates in the unique index.
• LANGUAGE — The language code for the translated row, and the second component of the primary key. It distinguishes multilingual versions of the same element. It also appears in the unique index AR_CMGT_DNB_ELEMENTS_TL_U1.
• ZD_EDITION_NAME — The third component of the unique index AR_CMGT_DNB_ELEMENTS_TL_U1, supporting edition-based redefinition and enabling online patching in EBS 12.2.x. Combined with DATA_ELEMENT_ID and LANGUAGE, it forms the true business key.
• DATA_ELEMENT_NAME — The translated display name of the D&B data point shown in the case folder. This is the core multilingual payload.
• SOURCE_LANG — Indicates the source language from which the translation was derived, used by the MLS infrastructure to track translation provenance.
• OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing who last changed the row and when.
• CREATION_DATE, CREATED_BY — Standard audit columns recording row creation.

The primary key is a composite surrogate of DATA_ELEMENT_ID and LANGUAGE, while the unique index adds ZD_EDITION_NAME as the business-key candidate. The distinction matters: two rows with the same element ID but different languages are valid and expected.

Common Use Cases and Queries

The most frequent requirement is resolving a translated D&B element label for a specific user's language when rendering a credit case folder. A typical query joins the translation to the base element by identifier and filters on language:

SELECT t.data_element_id, t.data_element_name, t.source_lang
  FROM ar.ar_cmgt_dnb_elements_tl t
 WHERE t.language = USERENV('LANG')
   AND t.data_element_id = :element_id;

Reporting scenarios include building a bilingual or multilingual catalog of D&B data points for credit analysts, auditing which translations exist for which languages, and verifying edition consistency after an online patch. Administrators may also compare SOURCE_LANG values against LANGUAGE to identify rows where the displayed name falls back to the source language. Because the table is an MLS companion object, it is normally accessed indirectly through the Oracle Credit Management UI rather than maintained manually.

Related Objects

• AR_CMGT_DNB_ELEMENTS (or the corresponding base element entity) — The primary/base table that holds D&B data element definitions; joined on DATA_ELEMENT_ID.
• AR_CMGT_DNB_ELEMENTS_TL_PK — The composite primary key constraint (DATA_ELEMENT_ID, LANGUAGE) enforcing one translation per element per language.
• AR_CMGT_DNB_ELEMENTS_TL_U1 — The unique index (DATA_ELEMENT_ID, LANGUAGE, ZD_EDITION_NAME) supporting the business key.
• Credit Management case folder objects — Case folder and D&B data point display logic consume DATA_ELEMENT_NAME at runtime.
• FND_LANGUAGES — Provides the valid LANGUAGE codes referenced by the LANGUAGE column.
• D&B integration objects within AR_CMGT — Other AR_CMGT_DNB_* tables that supply the underlying D&B credit data populated into case folders.