Search Results fnd_cp_services_tl_u1

Overview

APPLSYS.FND_CP_SERVICES_TL is the translation (TL) table for the Oracle E-Business Suite Concurrent Processing services layer. It stores the language-specific, user-facing text associated with each service registered through the Concurrent Processing framework, providing one row for every service in each installed language. Services defined in FND_CP_SERVICES form the logical grouping mechanism for concurrent programs and their associated request submissions, and this table supplies the localized service name, plural name, and description rendered in the Submit Requests and request-group interfaces.

The object is classified as a seed data table residing in the APPS_TS_SEED tablespace, which is consistent with the delivered, code-controlled content that Oracle ships and that administrators generally extend only through supported translation tooling. From a Data Vault modeling perspective, the metadata heuristic classifies this object as a standalone structure. It carries no documented foreign key references to other database objects, though it is referenced by its internal synonym and editioning view. The absence of outbound FK relationships is characteristic of lookup and reference data that behaves as an independent hub rather than a link or dependent satellite.

Key Information Stored

The table contains twelve documented columns, with the primary key defined as FND_CP_SERVICES_TL_PK on the composite of SERVICE_ID and LANGUAGE. The most significant columns are:

• SERVICE_ID (NUMBER, 15) — Surrogate identifier that anchors the row to the base service definition in FND_CP_SERVICES. Along with LANGUAGE, it forms the composite primary key.
• LANGUAGE (VARCHAR2) — The language code in which the translated text is stored. Together with SERVICE_ID, this is a business-key candidate.
• ZD_EDITION_NAME (VARCHAR2, 30) — Editioning column used by the E-Business Suite online patching infrastructure in release 12.2.
• SOURCE_LANG (VARCHAR2) — The language whose text is mirrored when a translation is not yet available. Changes to the source language row propagate to this row until a proper translation is supplied.
• SERVICE_NAME (VARCHAR2, 240) — The translated developer key for the service.
• SERVICE_PLURAL_NAME (VARCHAR2, 240) — The translated plural form of the service name, used where a set of services is presented.
• DESCRIPTION (VARCHAR2, 240) — The translated descriptive text for the service.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard Who columns recording audit and ownership metadata.

The unique index FND_CP_SERVICES_TL_U1 spans SERVICE_ID, LANGUAGE, and ZD_EDITION_NAME. This is the strongest business-key candidate in the documented schema because it guarantees at most one translated row per service, per language, per edition.

Common Use Cases and Queries

Typical usage centers on localization audits and multilingual reporting. A common query retrieves the translated names for a given service across all installed languages:

• SELECT SERVICE_ID, LANGUAGE, SERVICE_NAME, SERVICE_PLURAL_NAME FROM APPLSYS.FND_CP_SERVICES_TL WHERE SERVICE_ID = :p_service_id ORDER BY LANGUAGE;
• Identify rows still mirroring the source language by comparing SOURCE_LANG to LANGUAGE, which reveals incomplete translations.
• Join to the base FND_CP_SERVICES table on SERVICE_ID to compare the untranslated developer key against its localized rendering.
• Query by LANGUAGE to extract a full catalog of service names for a specific locale, supporting documentation or training material generation.
• Detect edition-specific rows using ZD_EDITION_NAME to isolate content relevant to a particular patched edition.

Related Objects

The documented dependency data shows that FND_CP_SERVICES_TL references no other database object directly, so relationships are inferred through shared keys and the EBS translation pattern:

• APPLSYS.FND_CP_SERVICES — The base (non-translated) service definition table; join on SERVICE_ID.
• APPLSYS.FND_CP_SERVICES_TL# — The internal table referenced by this object within the editioning framework.
• APPLSYS.FND_CP_SERVICES_VL — The translated view layer typically exposed to forms and reports, built from the base and TL tables.
• APPLSYS.FND_CP_SERVICES_TL_U1 — The unique index enforcing the composite business key.
• APPLSYS.FND_CP_SERVICES_TL_PK — The primary key constraint on SERVICE_ID and LANGUAGE.
• Broader Concurrent Processing objects such as FND_CONCURRENT_PROGRAMS and FND_REQUEST_GROUPS reference service identifiers and rely on this table indirectly for localized display.