Search Results allow_reload_flag




Overview
Explore in AI Chat

Overview

APPS.FND_SVC_COMP_PARAMS_VL is a multilingual (language-resolved) view in the Oracle E-Business Suite Applications schema. It exposes the parameter definitions that belong to service components registered with the Service Component (FND_SVC) framework, which underpins features such as Workflow Mailer, Notification Mailer, and other background service infrastructure. The view presents translated, user-facing parameter metadata alongside the operational attributes that govern how each parameter behaves at runtime.

Because it is a VL view, it returns display text (DISPLAY_NAME, DESCRIPTION) in the session's current language by joining the base table to its translation table, applying the standard Oracle language resolution logic. This makes it suitable for reporting, diagnostics, and integration scenarios where parameter names must be presented in a specific locale without the report author having to write the translation join manually.

The object was of interest in this search because of the ALLOW_RELOAD_FLAG column, which indicates whether a component parameter can be reloaded (that is, whether a change to its value can be applied to a running service without a restart of the owning service component).

Underlying Base Objects

The view is defined over two documented base objects:

  • FND_SVC_COMP_PARAMS_B — the base table holding the language-independent parameter definition, including identifiers, flags, default values, and audit columns.
  • FND_SVC_COMP_PARAMS_TL — the translation table holding the language-dependent display strings (DISPLAY_NAME and DESCRIPTION) keyed by language.

The VL view joins _B to _TL on the primary key (PARAMETER_ID) and filters the translation rows to the appropriate language, exposing a single row per parameter for the current session language. The design data reference is FND.FND_SVC_COMP_PARAMS_VL, and the view status is VALID in the documented environment.

Key Columns

  • PARAMETER_ID — primary identifier of the parameter definition; the join key between the _B and _TL tables.
  • PARAMETER_NAME — the internal, language-independent name of the parameter.
  • COMPONENT_TYPE — the service component type to which the parameter belongs.
  • DEFAULT_PARAMETER_VALUE — the seeded/default value applied if no explicit value is supplied.
  • REQUIRED_FLAG — indicates whether a value must be provided for the parameter.
  • ALLOW_RELOAD_FLAG — indicates whether the parameter value may be reloaded into a running component without a restart. This is the column most relevant to the search term.
  • ENCRYPTED_FLAG — indicates whether the parameter value is stored/handled as encrypted data.
  • CUSTOMIZATION_LEVEL — the level at which the parameter may be customized.
  • DISPLAY_NAME and DESCRIPTION — translated, user-facing text resolved from the _TL table.
  • 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 uses include identifying reloadable parameters for a component, validating required or encrypted parameters, and generating locale-specific parameter listings for administration or diagnostics reports.

List parameters that permit reload for a given component type:

  • SELECT parameter_name, display_name, default_parameter_value FROM apps.fnd_svc_comp_params_vl WHERE component_type = :p_component_type AND allow_reload_flag = 'Y';

Identify required parameters:

  • SELECT parameter_id, parameter_name, display_name FROM apps.fnd_svc_comp_params_vl WHERE required_flag = 'Y' ORDER BY parameter_name;

General inspection of all parameters with their translated text:

  • SELECT parameter_id, parameter_name, component_type, allow_reload_flag, required_flag, encrypted_flag, display_name FROM apps.fnd_svc_comp_params_vl ORDER BY component_type, parameter_name;

Because language resolution is handled within the view, these queries return text in the session's NLS language, eliminating the need to join FND_SVC_COMP_PARAMS_TL directly. For the operational values assigned to each parameter, query FND_SVC_COMP_PARAM_VALS_V, which references this view.