Results for “fnd_conc_release_classes_tl”

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

Overview

FND_CONC_RELEASE_CLASSES_TL is the translation (language-specific) table for FND_CONC_RELEASE_CLASSES in the Oracle E-Business Suite Application Object Library (FND). It resides in the APPLSYS schema and stores the user-facing, translatable text attributes of a concurrent program release class — principally the display name held in USER_RELEASE_CLASS_NAME and the DESCRIPTION — in each installed and enabled language. Concurrent release classes group concurrent programs so that incompatible programs are prevented from running simultaneously; the base table FND_CONC_RELEASE_CLASSES holds the language-independent definition, while this sibling table holds the translated presentation of that definition.

Under the heuristic Data Vault classification supplied in the metadata, this object is modeled as a link, because its primary key and foreign-key structure associate a release class with a language (and with audit actors). From a dimensional-modeling standpoint, however, the table behaves as a language-dependent satellite of FND_CONC_RELEASE_CLASSES: it carries descriptive attributes that vary by LANGUAGE rather than independent business relationships. Either interpretation is reasonable; the link classification reflects only the mined foreign-key topology.

Key Information Stored

The table is keyed by the composite primary key FND_CONC_RELEASE_CLASSES_TL_PK, defined over (APPLICATION_ID, RELEASE_CLASS_ID, LANGUAGE). APPLICATION_ID and RELEASE_CLASS_ID together identify the parent release class in FND_CONC_RELEASE_CLASSES, and LANGUAGE identifies the translation. The documented unique index FND_CONC_RELEASE_CLASSES_TL_U1, defined over (APPLICATION_ID, RELEASE_CLASS_ID, LANGUAGE, ZD_EDITION_NAME), extends this business-key candidate to accommodate editioned (online patching) data in 12.2.2.

• APPLICATION_ID — identifies the application owning the release class; part of the primary key and of the foreign key to FND_CONC_RELEASE_CLASSES.
• RELEASE_CLASS_ID — the surrogate identifier of the release class; part of the primary key and foreign key to the parent table.
• LANGUAGE — the language of this translation row; foreign key to FND_LANGUAGES.
• SOURCE_LANG — the language of the source (base) row from which this translation was derived; foreign key to FND_LANGUAGES.
• USER_RELEASE_CLASS_NAME — the translated display name of the release class, the principal user-visible attribute.
• DESCRIPTION — the translated descriptive text for the release class.
• CREATED_BY / CREATION_DATE — standard audit columns; CREATED_BY references FND_USER.
• LAST_UPDATED_BY / LAST_UPDATE_DATE — audit columns for the most recent change; LAST_UPDATED_BY references FND_USER.
• LAST_UPDATE_LOGIN — the login that performed the last update; foreign key to FND_LOGINS.
• ZD_EDITION_NAME — the edition discriminator used by the 12.2 online patching architecture, also present in the unique index.

Common Use Cases and Queries

The most frequent requirement is to display a release class in the session's language, falling back to the base row when no translation exists. A typical query joins the translation table on the full business key and filters by the current language, for example:

• SELECT b.release_class_id, t.user_release_class_name, t.description FROM fnd_conc_release_classes b, fnd_conc_release_classes_tl t WHERE b.application_id = t.application_id AND b.release_class_id = t.release_class_id AND t.language = USERENV('LANG');
• Detecting missing or stale translations by comparing the set of languages present in FND_LANGUAGES against rows in this table for a given release class.
• Auditing translation changes over time using LAST_UPDATED_BY and LAST_UPDATE_DATE, joined to FND_USER for the updater's identity.
• Reporting on the inventory of release classes and their localized names for documentation or migration planning.

Related Objects

• FND_CONC_RELEASE_CLASSES — the base (language-independent) table; joined on APPLICATION_ID and RELEASE_CLASS_ID.
• FND_LANGUAGES — referenced twice, via LANGUAGE and SOURCE_LANG, to validate and describe the translation languages.
• FND_USER — referenced by CREATED_BY and LAST_UPDATED_BY for audit identity.
• FND_LOGINS — referenced by LAST_UPDATE_LOGIN.
• FND_CONC_RELEASE_CLASSES_TL_PK and FND_CONC_RELEASE_CLASSES_TL_U1 — the primary-key constraint and unique index that enforce the business key, including ZD_EDITION_NAME.