Search Results csf_r_filter_params_b




Overview
Explore in AI Chat

Overview

CSF_R_FILTER_PARAMS_B is a base table in the CSF (Field Service) product module of Oracle E-Business Suite, documented as valid in both 12.1.1 and 12.2.2. It stores the definition of filter parameters that drive how Field Service selection and scenario logic constrains the records returned to users. Each row describes a single named parameter — its data type, its owning filter, and its optional default — and is referenced from runtime value tables that hold the parameter values supplied against a scenario or a request. The table therefore functions as the metadata layer of the Field Service filtering framework: it declares what may be filtered on, while sibling tables record the values actually chosen.

The supplied ETRM metadata classifies this object heuristically as standalone. In Data Vault terms this is best read as a modeling suggestion rather than a normative statement: the table behaves as a reference or definition entity (a hub-like anchor on FILTER_PARAM_ID) whose descriptive attributes — parameter name, type, default and lookup information — would, under a strict Data Vault design, most naturally be carried on a satellite keyed by that identifier. The presence of a SECURITY_GROUP_ID foreign key to FND_SECURITY_GROUPS further indicates the rows are secured through the standard multi-tenant security group mechanism.

Key Information Stored

The physical schema comprises 29 columns in the CSF schema. The most significant are:

  • FILTER_PARAM_ID — the surrogate primary key, enforced by CSF_R_FILTER_PARAMS_B_PK. This is the value propagated to all dependent tables.
  • PARAM_NAME — the business-facing name of the filter parameter, and the principal business-key candidate for identification in queries and reports.
  • PARAM_TYPE — the datatype or control type governing how the parameter is presented and validated at runtime.
  • FILTER_ID — identifies the parent filter to which the parameter belongs, grouping parameters into coherent filter definitions.
  • DEFAULT_VALUE — the value applied when no explicit value is supplied by the scenario or request.
  • LOOKUP_TYPE — points to the lookup configuration used to populate list-of-values parameters.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, scoping visibility of the parameter definition.
  • OBJECT_VERSION_NUMBER — the standard optimistic locking column used by the OAF/ADF framework.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns, available for customer-specific extension of the parameter definition.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard audit WHO columns.

Common Use Cases and Queries

Typical usage centers on resolving which parameters belong to a filter and how they default, and on joining declared parameters to the supplied values recorded elsewhere. A representative query lists the parameters of a given filter with their types and defaults:

SELECT fp.filter_param_id, fp.param_name, fp.param_type, fp.default_value
FROM csf.csf_r_filter_params_b fp
WHERE fp.filter_id = :p_filter_id
ORDER BY fp.param_name;

Joining outward to the value tables produces a complete picture of a scenario's filter configuration:

SELECT fp.param_name, sv.value
FROM csf.csf_r_filter_params_b fp, csf.csf_r_scenario_values sv
WHERE sv.filter_param_id = fp.filter_param_id
AND sv.scenario_id = :p_scenario_id;

Reporting use cases include auditing which parameters carry default values, validating that every parameter declared against a filter has a corresponding lookup type where one is expected, and reviewing the descriptive flexfield attributes for customized parameters. The audit columns support change tracking and ownership reporting.

Related Objects

The following objects are most significant in relation to this table:

  • CSF_R_SCENARIO_VALUES — references FILTER_PARAM_ID; stores parameter values captured against a Field Service scenario.
  • CSF_R_REQUEST_VALUES — references FILTER_PARAM_ID; stores parameter values captured against a service request.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; controls which security group may see each parameter definition.
  • FND_LOOKUP_VALUES / FND_LOOKUP_TYPES — consulted via LOOKUP_TYPE to resolve list-of-values parameters and their translations.
  • CSF_R_FILTER_PARAMS_TL — the translated (TL) companion table, where present in the schema, holding language-specific parameter descriptions.
  • FND_FLEX_VALUES / FND_DESCR_FLEX_COL_USAGE — the standard flexfield infrastructure that interprets ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for customized parameter definitions.