Search Results xtr_layout_values_u2

Overview

XTR.XTR_LAYOUT_VALUES is a seed data table in the Oracle E-Business Suite XTR (Treasury/ETRM – Enterprise Treasury Risk Management) schema. It defines the common variables, also referred to as columns, from which values are derived for confirmation letter templates. Each row corresponds to a single variable (column) available for a given template type, and records the column name, its SQL text form, description, data type, length, and formatting mask. The table resides in the APPS_TS_SEED tablespace, consistent with its role as a repository of setup or seeded metadata rather than transactional data. Its status is VALID across EBS 12.1.1 and 12.2.2, and its FND Design Data reference is XTR.XTR_LAYOUT_VALUES.

Under a heuristic Data Vault classification, this object is characterized as satellite-leaning. It functions primarily as a descriptive attribute store attached to a template-type business key, rather than as a true hub or a link resolving many-to-many relationships. Modelers should treat it as a satellite keyed by template type.

Key Information Stored

The table is defined with a documented physical schema of nine columns. The most significant columns are:

• TEMPLATE_TYPE (VARCHAR2, 50) – The template type to which the variable belongs; part of the primary key and of both unique indexes.
• FIELD_NAME (VARCHAR2, 50) – The column (common variable) name; the second component of the primary key.
• COL_VALUE (VARCHAR2, 200) – The column (common variable) name expressed in SQL text format, used when the variable is resolved in generated layout SQL.
• DESCRIPTION (VARCHAR2, 100) – A human-readable description of the column (common variable); business-key candidate in XTR_LAYOUT_VALUES_U2.
• FIELD_TYPE (VARCHAR2, 15) – The data type of the variable.
• FIELD_FORMAT (VARCHAR2, 25) – A format mask applied to the variable when rendered.
• LENGTH (NUMBER) – The data length of the variable.
• VIEW_SUBSECTION (NUMBER) – Documented as not currently used.
• ZD_EDITION_NAME – The editioning column present in 12.2.2, participating in both unique indexes.

The surrogate primary key is XTR_LAYOUT_VALUES_PK (TEMPLATE_TYPE, FIELD_NAME). Business-key uniqueness is enforced by XTR_LAYOUT_VALUES_U1 (TEMPLATE_TYPE, FIELD_NAME, ZD_EDITION_NAME) and XTR_LAYOUT_VALUES_U2 (TEMPLATE_TYPE, DESCRIPTION, ZD_EDITION_NAME). The user search term xtr_layout_values_u2 therefore refers to the second unique index, which guarantees that within a template type, variable descriptions are distinct under an edition.

Common Use Cases and Queries

Typical usage centers on enumerating the variables available for a confirmation letter template type, validating that a template references only supported columns, and retrieving formatting and length metadata for rendering. A standard retrieval follows the documented query text:

• Listing all variables for one template: SELECT FIELD_NAME, DESCRIPTION, FIELD_TYPE, LENGTH FROM XTR.XTR_LAYOUT_VALUES WHERE TEMPLATE_TYPE = :p_template_type;
• Resolving the SQL text form of a variable: SELECT COL_VALUE, FIELD_FORMAT FROM XTR.XTR_LAYOUT_VALUES WHERE TEMPLATE_TYPE = :p_type AND FIELD_NAME = :p_field;
• Confirming uniqueness constraints on the business key: querying by TEMPLATE_TYPE and DESCRIPTION to detect duplicates, mirroring XTR_LAYOUT_VALUES_U2.
• Data type and length reporting for template documentation.

Related Objects

Dependency metadata records a foreign-key relationship in which TEMPLATE_TYPE in XTR_LAYOUT_VALUES references XTR_LAYOUT_WHERE_CLAUSE, tying variable definitions to the where-clause definitions of the same template type. The table is referenced by the APPS.XTR_LAYOUT_VALUES synonym/view used at the application layer. Because the documented relationship set is small, the most significant related objects are the parent XTR_LAYOUT_WHERE_CLAUSE table and the APPS-layer synonyms for this object, along with the associated XTR confirmation letter template definitions that consume these variables. Join predicates should be formed on TEMPLATE_TYPE to link layout values to their governing where clause and template definitions.