Results for “fnd_svc_comp_params_tl”

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

Overview

FND_SVC_COMP_PARAMS_TL is the multi-language support (MLS) translation table for FND_SVC_COMP_PARAMS_B, owned by the APPLSYS schema within the FND – Application Object Library product. It stores the language-dependent attributes of service component parameters—specifically the translatable text a user sees for a parameter's display name and description. The "_TL" suffix identifies translation tables whose non-translatable structure and relationships live in a corresponding "_B" base table; each row in this table maps to one language translation of a base parameter definition.

From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning. FND_SVC_COMP_PARAMS_TL functions as an attached descriptive construct keyed by an identifier that is foreign to its own context: PARAMETER_ID references the base table rather than originating here. The natural hub is FND_SVC_COMP_PARAMS_B, and this table behaves as a satellite carrying attribute payload (translated text) that varies by LANGUAGE, a dependent child key of the same parent hub. Mapping it as a satellite of the base parameter hub, rather than as an independent hub, aligns with the documented FK direction.

Key Information Stored

The table contains 11 documented columns. The most significant are:

• PARAMETER_ID — Surrogate-style identifier that joins to the base table; the leading column of both the primary key and the foreign key to FND_SVC_COMP_PARAMS_B.
• LANGUAGE — Language code identifying the translation; the second column of the primary key.
• SOURCE_LANG — The language of the source text from which a translation was derived.
• DISPLAY_NAME — The translatable display label of the parameter, presented to users in the corresponding language.
• DESCRIPTION — The translatable descriptive text for the parameter.
• ZD_EDITION_NAME — Edition identifier supporting Oracle's Edition-Based Redefinition (EBR), present in 12.2.x.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each translated row.

The primary key FND_SVC_COMP_PARAMS_TL_PK1 spans (PARAMETER_ID, LANGUAGE). The unique index FND_SVC_COMP_PARAMS_TL_U1 spans (PARAMETER_ID, LANGUAGE, ZD_EDITION_NAME) and serves as a business-key candidate, confirming that in an EBR context a parameter may hold one translation per language per edition.

Common Use Cases and Queries

The primary use case is retrieving user-facing text for service component parameters in a language-specific report or configuration screen. A typical query joins the translation to its base table and filters by the runtime language:

• Localized parameter listing: SELECT b.parameter_id, tl.display_name, tl.description FROM fnd_svc_comp_params_b b, fnd_svc_comp_params_tl tl WHERE b.parameter_id = tl.parameter_id AND tl.language = USERENV('LANG').
• Translation completeness audit: compare counts of rows per PARAMETER_ID in the _B and _TL tables to find parameters lacking a translation for a target LANGUAGE.
• Source vs. translated comparison: filter WHERE tl.language <> tl.source_lang to isolate rows that are genuinely translated rather than copied from the source language.
• Edition-aware queries: in 12.2.2, constrain ZD_EDITION_NAME to the desired edition to avoid mixing translations across edition boundaries.

Because DISPLAY_NAME and DESCRIPTION are the only free-text attributes, reporting generally projects these alongside structural columns from the base table.

Related Objects

The relationship data identifies the following significant objects:

• FND_SVC_COMP_PARAMS_B — The base table holding non-translatable parameter attributes. Joined on FND_SVC_COMP_PARAMS_TL.PARAMETER_ID = FND_SVC_COMP_PARAMS_B.PARAMETER_ID; this is the sole documented foreign key and the parent of the translation.
• FND_SVC_COMP_PARAMS_TL_PK1 — Primary key index on (PARAMETER_ID, LANGUAGE), enforcing one translation per language.
• FND_SVC_COMP_PARAMS_TL_U1 — Unique index on (PARAMETER_ID, LANGUAGE, ZD_EDITION_NAME), the business-key candidate.

Beyond the documented links, this table participates in the broader FND service component configuration model, where parameters are consumed by service component parameter APIs and by concurrent program and service component setup screens. Any reporting or integration that surfaces localized parameter labels should treat this table as the text-supplying satellite of FND_SVC_COMP_PARAMS_B.