Results for “xtr_sys_languages”

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

Overview

XTR_SYS_LANGUAGES is a reference table owned by the XTR (Oracle Treasury) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores language- and locale-specific labels for user interface elements within the Treasury module. Each row maps a Treasury application screen or module context to a translatable item and supplies the text displayed to the end user. In this respect the table functions as the runtime source for rendered field labels, canvas captions, and prompt strings across the Treasury forms and their associated canvases.

The object is classified as VALID in the ETRM 12.2.2 data dictionary and exposes nine documented columns. The heuristic Data Vault classification mined from the foreign-key structure is standalone, meaning no parent-child (hub or link) relationships were detected. In modeling terms this suggests treating the table as an independent reference or lookup structure rather than as a component of a conformed dimensional chain. It carries its own surrogate key and does not appear to participate in a link between business entities.

Key Information Stored

The business identity of each row is defined by the composite primary key XTR_SYS_LANGUAGES_PK, which spans three columns: MODULE_NAME, CANVAS_TYPE, and ITEM_NAME. These same three columns form the unique index XTR_SYS_LANGUAGES_U1, so the primary key doubles as the business-key candidate — there is no separate meaningless surrogate column. MODULE_NAME identifies the Treasury module or functional area. CANVAS_TYPE identifies the canvas or screen surface within that module. ITEM_NAME identifies the individual field, prompt, or control being labelled.

The payload column ORIGINAL_TEXT holds the translatable or display text associated with the key triplet. The remaining five columns are standard Oracle EBS WHO (Workflow/Oracle) audit attributes: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. These record who created and last modified each language row, when, and through which login session — essential for reconciliation and change tracking during patching or language installation.

Common Use Cases and Queries

Typical use cases include verifying that a Treasury form label has been customized, auditing changes made during an upgrade or localization patch, and extracting a mapping of item names to display text for documentation or user training material.

• Retrieve all labels for a specific module and canvas: SELECT item_name, original_text FROM xtr.xtr_sys_languages WHERE module_name = :module AND canvas_type = :canvas ORDER BY item_name;
• Identify recent modifications for change control: SELECT item_name, last_updated_by, last_update_date FROM xtr.xtr_sys_languages WHERE last_update_date > SYSDATE - 30;
• Confirm that a specific prompt exists before customizing it: SELECT 1 FROM xtr.xtr_sys_languages WHERE module_name = :mod AND canvas_type = :cv AND item_name = :item;
• Reconcile installed languages against expected coverage by comparing distinct module/canvas combinations.

Related Objects

Because the table is classified as standalone with no documented foreign keys, related objects are referenced through the business-key triplet rather than through enforced constraints. The most significant dependencies are the Treasury UI metadata and form definition objects that reference MODULE_NAME, CANVAS_TYPE, and ITEM_NAME to resolve display text. These include the Treasury canvas and module definition tables within the XTR schema, the FND language and territory reference tables (FND_LANGUAGES, FND_TERRITORIES) used to interpret locale context, and the FND application and lookup structures that govern module naming. Customization and translation repositories that override ORIGINAL_TEXT, together with the standard WHO audit views, also reference this table by its key columns. Because no enforced referential integrity exists, joins to these objects should be performed explicitly on MODULE_NAME, CANVAS_TYPE, and ITEM_NAME.