Search Results fnd_cp_services_tl

Overview

FND_CP_SERVICES_TL is a translation (TL) table in the Oracle E-Business Suite Application Object Library (FND) schema, owned by APPLSYS. It stores the language-specific, translated text attributes for records defined in the base FND_CP_SERVICES_B table. In Oracle EBS 12.1.1 and 12.2.2, this table belongs to the "CP" (Concurrent Processing / Service) family of FND objects that describe the services used by the concurrent manager and related processing infrastructure. Each row represents one service in one installed language, allowing the service name and description to be presented in the user's session language.

From a heuristic Data Vault modeling perspective, this object is classified as standalone, meaning it does not participate in a documented foreign-key relationship within the ETRM FK structure supplied. In practice, however, a TL table behaves like a satellite of its base table, carrying descriptive, language-dependent attributes keyed to the same surrogate identifier. Modelers should treat it as a dependent descriptive satellite rather than an independent hub.

Key Information Stored

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

• SERVICE_ID — the surrogate identifier of the parent service; part of the composite primary key.
• LANGUAGE — the language code for the translated row; the second component of the composite primary key.
• SERVICE_NAME — the translated display name of the service.
• SERVICE_PLURAL_NAME — the translated plural form of the service name.
• DESCRIPTION — the translated textual description of the service.
• SOURCE_LANG — the language from which the translation originated, used by the translation (TL) framework.
• ZD_EDITION_NAME — the editioning column introduced in EBS 12.2 for online patching; participates in the unique index FND_CP_SERVICES_TL_U1.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
• CREATION_DATE, CREATED_BY — standard creation audit columns.

The primary key FND_CP_SERVICES_TL_PK is defined on (SERVICE_ID, LANGUAGE). A separate unique index, FND_CP_SERVICES_TL_U1, is defined on (SERVICE_ID, LANGUAGE, ZD_EDITION_NAME), reflecting the 12.2 editioning model. The business-key candidate is therefore the combination of SERVICE_ID and LANGUAGE.

Common Use Cases and Queries

This table is primarily queried to resolve translated service names and descriptions for a given language, typically in a join with the base table. A common reporting pattern filters on the LANGUAGE of the current session via FND_GLOBAL or the NLS session parameter:

• Resolving a service name in the user's language: select service_name from fnd_cp_services_tl where service_id = :id and language = userenv('LANG');
• Cross-language comparison, listing all translations for a service: select language, service_name from fnd_cp_services_tl where service_id = :id order by language;
• Audit reporting, selecting created_by and last_update_date to track who added translations and when.

Because the table holds translated text only, it is not used for functional concurrent-processing logic directly; it is a presentation-layer dependency for any report or form that displays service names in a language other than the base language.

Related Objects

The base table FND_CP_SERVICES_B supplies the untranslated definition and is joined on SERVICE_ID, making it the most significant related object. The view FND_CP_SERVICES_VL is expected to expose the translated attributes by joining the base (B) and translation (TL) tables on SERVICE_ID and LANGUAGE. The concurrent-processing service definition, referenced through SERVICE_ID, links to FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_QUEUES by way of service associations. Standard FND audit and language reference objects such as FND_LANGUAGES and FND_APPLICATION provide the LANGUAGE and edition context. Because the FK metadata documents this object as standalone, no direct foreign-key constraint columns are recorded beyond the internal SERVICE_ID key shared with the base table.