Results for “xdo_font_mapping_sets_tl”

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

Overview

XDO_FONT_MAPPING_SETS_TL is a translation (TL) table owned by the XDO schema, the repository for Oracle XML Publisher (BI Publisher) metadata within Oracle E-Business Suite. It stores the language-specific descriptive attributes for font mapping sets — the configurations that tell the XML Publisher rendering engine which physical fonts to substitute for the logical font names referenced in RTF, XSL-FO, and PDF templates. In Oracle EBS 12.1.1 and 12.2.2, this table is the linguistic companion to XDO_FONT_MAPPING_SETS_B, which holds the language-independent definition of each mapping set. Because font substitution behavior is often documented and reviewed by business users in local languages, the translated name carried here becomes the user-facing label in XML Publisher administration and concurrent program output.

The ETRM metadata classifies this object heuristically as standalone under the Data Vault modeling convention. In practice, this suggests modeling XDO_FONT_MAPPING_SETS_TL as a satellite attached to the mapping set business key, rather than as an independent hub or link. The absence of an FK-derived parent simply reflects the fact that the primary key already embeds the mapping code, making the table self-contained from a referential standpoint.

Key Information Stored

The table contains nine documented columns. The composite primary key, XDO_FONT_MAPPING_SETS_TL_PK, is defined over (LANGUAGE, MAPPING_CODE). Neither column is a surrogate identifier: the primary key is a natural composite business key. MAPPING_CODE identifies the mapping set and aligns with the corresponding row in the base table; LANGUAGE identifies the installed Oracle language for which the translated attributes apply. Together they guarantee one translated record per mapping set per language.

• MAPPING_CODE — Business-key column naming the font mapping set; joins to the base table definition.
• LANGUAGE — Business-key column holding the Oracle language code (for example, US, D, or a territory-qualified code).
• MAPPING_NAME — The translated, user-visible display name of the font mapping set.
• SOURCE_LANG — The language from which the translation was derived, used by the translation (XLIFF) framework to track provenance.
• CREATED_BY, CREATION_DATE — Standard audit columns recording row insertion.
• LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns recording the most recent change.
• LAST_UPDATE_LOGIN — Login identifier associated with the last update, supporting audit tracking.

Common Use Cases and Queries

The most frequent requirement is retrieving the localized display name for a known mapping code. A typical query joins the translated table to the base table and filters on the session language:

• Resolving a display name: SELECT t.mapping_name FROM xdo_font_mapping_sets_tl t WHERE t.mapping_code = :code AND t.language = USERENV('LANG');
• Auditing completeness of translations across installed languages by comparing row counts in the TL table against the base table.
• Listing all font mapping sets with their localized names for administrative or migration reports, ordering by mapping_code and language.
• Detecting stale or untranslated rows by inspecting SOURCE_LANG and the audit columns.
• Reconciling post-clone or post-patch state, since font mapping sets are frequently seeded and then customized.

Related Objects

The following objects are most significant in relation to this table:

• XDO_FONT_MAPPING_SETS_B — Base (language-independent) table; join on MAPPING_CODE.
• XDO_FONT_MAPPINGS — Individual font substitution entries belonging to a mapping set.
• XDO_FONT_MAPPINGS_TL — Translated attributes for individual font mapping entries.
• XDO_FONT_MAPPING_SETS_VL — The MLS view exposing base and translated columns as a single logical entity.
• XDO_TEMPLATES_B / XDO_TEMPLATES_TL — Templates referencing mapping sets during rendering.
• FND_LANGUAGES — Language definitions validating the LANGUAGE column.