Search Results csf_r_filter_params_tl_pk

Overview

CSF_R_FILTER_PARAMS_TL is the translated (language-specific) companion table to CSF_R_FILTER_PARAMS_B within the CSF — Field Service product family of Oracle E-Business Suite, and it is present and valid in both release 12.1.1 and 12.2.2. In the Oracle EBS multilingual architecture, base tables (_B) store language-independent attributes, while translation tables (_TL) store the language-dependent, user-facing text such as display names and descriptions. CSF_R_FILTER_PARAMS_TL therefore holds the translated display text for filter parameters that drive configurable query and filtering behavior in Field Service and related self-service components. The table is owned by the CSF schema and is documented with ten columns.

From a heuristic Data Vault modeling perspective, the mined relationship structure classifies this table as standalone. In practice, however, a translation table behaves as a satellite attached to the base entity CSF_R_FILTER_PARAMS_B, keyed by the entity identifier plus language. This classification is offered as a modeling suggestion rather than a documented constraint.

Key Information Stored

The ten documented columns distinguish the table's identity, its translated content, and standard EBS audit and security attributes.

• FILTER_PARAM_ID — surrogate identifier of the parent filter parameter; part of the composite primary key.
• LANGUAGE — the language code of the translated row; the second component of the composite primary key.
• SOURCE_LANG — the source language from which the translation was seeded, used for translation-maintenance logic.
• PARAM_DISPLAY_NAME — the language-specific, user-facing name of the filter parameter; this is the primary business-content column of the table.
• SECURITY_GROUP_ID — the security grouping key, with a documented foreign key to FND_SECURITY_GROUPS, supporting multi-tenant or group-based data segregation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS auditing columns that record who created and last modified each translated row and when.

The primary key is CSF_R_FILTER_PARAMS_TL_PK, defined on the composite of FILTER_PARAM_ID and LANGUAGE. The surrogate entity key FILTER_PARAM_ID is not unique on its own; uniqueness is achieved only when combined with LANGUAGE.

Common Use Cases and Queries

Typical uses center on resolving the correct display name of a filter parameter for a given user session language, and on reporting which parameters have been translated.

• Joining the translation to its base row to retrieve the display name for a specific language.
• Auditing translation coverage, including identifying parameters missing a translated display name for a target language.
• Production support investigations into incorrect or missing filter labels presented to end users.
• Data extraction and migration of translated metadata during upgrades or localization projects.

A representative query pattern:

• SELECT b.filter_param_id, t.param_display_name FROM csf.csf_r_filter_params_b b, csf.csf_r_filter_params_tl t WHERE b.filter_param_id = t.filter_param_id AND t.language = USERENV('LANG');

Related Objects

• CSF_R_FILTER_PARAMS_B — the base table holding language-independent attributes; joined on FILTER_PARAM_ID.
• CSF_R_FILTER_PARAMS_TL_PK — the composite primary key constraint on FILTER_PARAM_ID and LANGUAGE.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID, enforcing group-based data security.
• FND_LANGUAGES — supplies the installed language values used by the LANGUAGE and SOURCE_LANG columns.
• CSF_R_FILTER_PARAMS_VL — the translated view that typically joins the _B and _TL tables for user-facing access.
• FND_APPLICATION and CSF module objects — the Field Service application context that consumes filter parameter configuration.