Search Results fnd_svc_comp_params_vl

Overview

The FND_SVC_COMP_PARAMS_VL view is a translation-enabled (VL suffix) database view owned by the APPS schema in Oracle E-Business Suite. It belongs to the FND — Application Object Library product and exposes configuration parameters associated with service components registered within the Oracle EBS Service Infrastructure. The view presents one row per component parameter, combining the language-independent parameter definition with the language-specific display name and description resolved against the current session language.

As a _VL view, it is the report-safe, user-facing construct intended for querying parameter metadata. It is the reference object used whenever configuration parameters for service components must be inspected, reported upon, or integrated with external systems. Because it joins the base (_B) and translation (_TL) tables and filters on USERENV('LANG'), the view returns display text in the language of the querying session, making it suitable for Concurrent Program output, OAF pages, and BI Publisher data models. The documentation describes the object as VALID in ETRM 12.2.2 and equally applicable to ETRM 12.1.1, since the underlying FND service component parameter schema is consistent across both releases.

Underlying Base Objects

The view is defined over two documented base objects, both accessed through APPS synonyms:

• FND_SVC_COMP_PARAMS_B — the base table holding the language-independent definition of each component parameter, including identifiers, flags, and default values. The view aliases this table as B and drives the join.
• FND_SVC_COMP_PARAMS_TL — the translation table supplying the language-specific DISPLAY_NAME and DESCRIPTION, aliased as T. It is joined on B.PARAMETER_ID = T.PARAMETER_ID and filtered by T.LANGUAGE = USERENV('LANG').

The view text selects all significant columns from the _B table (ROWID, audit columns, OBJECT_VERSION_NUMBER, PARAMETER_ID, PARAMETER_NAME, COMPONENT_TYPE, DEFAULT_PARAMETER_VALUE, REQUIRED_FLAG, ALLOW_RELOAD_FLAG, ENCRYPTED_FLAG, CUSTOMIZATION_LEVEL) plus DISPLAY_NAME and DESCRIPTION from the _TL table. The relationship is therefore a one-to-one join, keyed on PARAMETER_ID, between the entity and its active-language translation.

Key Columns

• PARAMETER_ID — unique identifier of the parameter; the join key between the _B and _TL tables.
• PARAMETER_NAME — internal name of the configuration parameter.
• COMPONENT_TYPE — identifies the service component type to which the parameter applies.
• DEFAULT_PARAMETER_VALUE — the default value assigned to the parameter.
• REQUIRED_FLAG — indicates whether a value must be supplied.
• ALLOW_RELOAD_FLAG — indicates whether the parameter may be reloaded at runtime.
• ENCRYPTED_FLAG — the column central to the user's search; indicates whether the parameter value is stored or transmitted in encrypted form.
• CUSTOMIZATION_LEVEL — controls the degree to which the parameter may be customized.
• DISPLAY_NAME / DESCRIPTION — translated, user-facing text for the parameter.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, and ROW_ID.

Common Use Cases and Queries

Typical scenarios include enumerating component parameters for administration, auditing encryption and required-value settings, and building configuration reports. The following query lists parameters with their encryption status:

• SELECT parameter_name, component_type, encrypted_flag FROM fnd_svc_comp_params_vl;
• SELECT parameter_name, default_parameter_value FROM fnd_svc_comp_params_vl WHERE required_flag = 'Y';
• SELECT display_name, description FROM fnd_svc_comp_params_vl WHERE encrypted_flag = 'Y';

All queries return text in the session language via the USERENV('LANG') predicate.