Results for “validation_tmplt_id”

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

Overview

OE_PC_VTMPLTS_TL is a translation (TL) table in the ONT (Order Management) schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the language-specific, translatable text columns associated with validation templates used by Oracle Order Management's constraint and validation framework. Validation templates define configurable rules that govern order capture, pricing, and processing constraints. While the base table OE_PC_VTMPLTS holds language-independent attributes, OE_PC_VTMPLTS_TL carries the human-readable display names and descriptions for each installed language, allowing the same template to be presented in the user's session language.

From a dimensional modeling perspective, the mined Data Vault classification is satellite-leaning. This reflects the table's role as a descriptive, dependent store whose lifecycle is tied to its parent. It is not a hub or a link, but rather attribute context keyed to a parent entity plus a language discriminator.

Key Information Stored

The table is keyed by a composite primary key, OE_PC_VTMPLTS_TL_PK, defined over VALIDATION_TMPLT_ID and LANGUAGE. VALIDATION_TMPLT_ID is the surrogate primary key that ties each translated row back to its parent record in OE_PC_VTMPLTS, while LANGUAGE identifies the language of the translated text (for example, US for English). A unique index, OE_PC_VTMPLTS_TL_U1, spans VALIDATION_TMPLT_ID, LANGUAGE, and ZD_EDITION_NAME, making it the documented business-key candidate and supporting edition-based redefinition.

• VALIDATION_TMPLT_ID — surrogate identifier and FK to the parent template.
• LANGUAGE — the language code for the translated content.
• SOURCE_LANG — the source language from which the translation was derived, used by the translation tooling.
• DISPLAY_NAME — the translated, user-facing label for the validation template.
• DESCRIPTION — the translated descriptive text explaining the template's purpose.
• ZD_EDITION_NAME — editioning column supporting online patching in 12.2.x.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit and concurrency columns maintained by the framework.

In total the documented physical schema contains 11 columns. Together these separate the descriptive, translatable attributes (DISPLAY_NAME, DESCRIPTION) from the structural identity of the template.

Common Use Cases and Queries

Typical usage involves joining the translation table to its base table to retrieve localized labels for validation templates in order-entry screens, setup reports, and custom inquiries. A common reporting pattern restricts rows to the session or reporting language:

• Joining OE_PC_VTMPLTS to OE_PC_VTMPLTS_TL on VALIDATION_TMPLT_ID and filtering by LANGUAGE to produce a language-specific list of template names.
• Auditing translation coverage by comparing SOURCE_LANG against LANGUAGE to detect untranslated or missing rows.
• Building picklists or LOV queries that surface DISPLAY_NAME for constraint configuration.
• Extracting setup metadata for migration, documentation, or reconciliation between environments.

Because the table is small and primarily read during setup and runtime display, queries should always filter by LANGUAGE and join on the primary key columns to avoid cross-language duplication in results.

Related Objects

• OE_PC_VTMPLTS — the parent base table; joined on OE_PC_VTMPLTS_TL.VALIDATION_TMPLT_ID = OE_PC_VTMPLTS.VALIDATION_TMPLT_ID. This is the documented foreign key.
• OE_PC_VTMPLTS_TL_PK — primary key constraint over VALIDATION_TMPLT_ID and LANGUAGE.
• OE_PC_VTMPLTS_TL_U1 — unique index including ZD_EDITION_NAME.
• FND_LANGUAGES — reference for valid LANGUAGE and SOURCE_LANG values.
• OE_PC_VTMPLTS_VL / related validation-template views — presentation layers that combine base and translation rows for the UI.

These objects collectively support the Order Management constraint framework and its multilingual presentation.