Results for “fnd_concurrent_programs_tl”

50+ results




Overview
Explore in AI Chat

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

Overview

FND_CONCURRENT_PROGRAMS_TL is the translation (language) table for FND_CONCURRENT_PROGRAMS in the Oracle E-Business Suite Application Object Library (FND). It resides in the APPLSYS schema and stores the language-dependent attributes of concurrent program definitions — principally the user-facing program name and description — for every installed language in a multi-language installation. The base table FND_CONCURRENT_PROGRAMS holds language-independent attributes (executable, execution method, parameter definition, enablement flags), while FND_CONCURRENT_PROGRAMS_TL holds the translatable text that users see in the Submit Request and Concurrent Programs forms.

From a Data Vault modeling perspective, the metadata's FK structure suggests this object is satellite-leaning: it is a dependent child of FND_CONCURRENT_PROGRAMS and carries descriptive, descriptive-over-time attributes keyed by the parent's identity plus a LANGUAGE discriminator. The table participates in the Oracle Translations ("_TL") pattern, in which the SOURCE_LANG column identifies the language in which the base definition was authored and rows for additional languages are generated through the translation (NLS) utilities.

Key Information Stored

The documented physical schema contains twelve columns. The most significant are:

  • APPLICATION_ID — identifies the owning application (product) of the concurrent program; part of the composite primary key and the foreign key to FND_CONCURRENT_PROGRAMS.
  • CONCURRENT_PROGRAM_ID — the surrogate identifier of the program within its application; combined with APPLICATION_ID it forms the parent key.
  • LANGUAGE — the NLS language code of the translation row; completes the composite primary key.
  • USER_CONCURRENT_PROGRAM_NAME — the user-visible, translatable program name; also a business-key candidate via the unique index on APPLICATION_ID, USER_CONCURRENT_PROGRAM_NAME and LANGUAGE.
  • DESCRIPTION — the translatable long description of the program shown to users.
  • SOURCE_LANG — the language in which the original (untranslated) definition was created; used by the translation framework.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns maintained by the WHO columns convention.
  • ZD_EDITION_NAME — the edition discriminator used by Edition-Based Redefinition (EBR), present in 12.2.x; included in unique indexes U1 and U2.

The documented surrogate primary key is FND_CONCURRENT_PROGRAMS_TL_PK (APPLICATION_ID, CONCURRENT_PROGRAM_ID, LANGUAGE). Documented business-key candidates are the unique indexes FND_CONCURRENT_PROGRAMS_TL_U1 (APPLICATION_ID, CONCURRENT_PROGRAM_ID, LANGUAGE, ZD_EDITION_NAME) and FND_CONCURRENT_PROGRAMS_TL_U2 (APPLICATION_ID, USER_CONCURRENT_PROGRAM_NAME, LANGUAGE, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical uses include building concurrent program catalogs, NLS translation validation, and localization reporting. A common pattern joins the translation table to the base table filtered by the session language:

  • List enabled programs with localized names: SELECT b.concurrent_program_name, t.user_concurrent_program_name FROM fnd_concurrent_programs b, fnd_concurrent_programs_tl t WHERE b.application_id = t.application_id AND b.concurrent_program_id = t.concurrent_program_id AND t.language = USERENV('LANG').
  • Detect missing translations: compare expected language rows against the TL table for a given program.
  • Search programs by localized name using USER_CONCURRENT_PROGRAM_NAME, relying on the U2 unique index for efficient lookups.
  • Validate that SOURCE_LANG matches the base definition's source language for translation hygiene.

Because the table is keyed by LANGUAGE, reports should always constrain or join on LANGUAGE to avoid duplicate rows per program.

Related Objects

  • FND_CONCURRENT_PROGRAMS — the base table; joined via APPLICATION_ID and CONCURRENT_PROGRAM_ID (this is the documented foreign key).
  • FND_CONCURRENT_PROGRAMS_VL — the translated view combining base and TL rows, commonly queried in forms and reports.
  • FND_CONCURRENT_PROGRAMS_TL_PK / _U1 / _U2 — primary and unique indexes enforcing identity and business keys.
  • FND_EXECUTABLES — referenced by the base table, providing executable metadata.
  • FND_APPLICATION / FND_APPLICATION_TL — supplies the APPLICATION_ID and its translated application name.
  • FND_LANGUAGES / FND_LANGUAGE_TL — defines the LANGUAGE codes and their display names.