Search Results fnd_flex_conc_param_vset_v

Overview

APPS.FND_FLEX_CONC_PARAM_VSET_V is a reporting view in the Oracle E-Business Suite Application Object Library (FND) that exposes the relationship between concurrent programs, their descriptive flexfield (DFF) parameter usage, and the underlying value sets and validated values. In Oracle EBS 12.1.1 and 12.2.2, concurrent program parameters are frequently implemented using value sets attached to a "flexfield" definition named $SRS$.<program_short_name>. This view assembles the metadata that links an application, a concurrent program, its parameter columns, and the value set assigned to each parameter.

The view is primarily used for diagnostics, security review, and integration metadata extraction. It answers questions such as: which value set backs a given concurrent program parameter, whether that value set is security-enabled, what validation type applies, and which parent/child value set relationships exist. Because parameter value sets often inherit from parent flexfields, the view also exposes the parent value set and the corresponding parent column sequence, which is the source of the COLUMN_SEQ_NUM reference users frequently search for.

Underlying Base Objects

The view is defined over both views and synonyms in the APPS schema. The documented referenced base objects are:

• FND_APPLICATION_VL (view) — application ID and translated application name.
• FND_CONCURRENT_PROGRAMS_VL (view) — concurrent program definition, filtered by SRS_FLAG IN ('Y','Q').
• FND_DESCR_FLEX_COL_USAGE_VL (view) — descriptive flexfield column usage, aliased as U, joining the program's $SRS$ flexfield to its value set.
• FND_DESCR_FLEX_COLUMN_USAGES (synonym) — the underlying column usage table used in the correlated subquery to locate the parent column by COLUMN_SEQ_NUM.
• FND_FLEX_VALUE_SETS (synonym) — the value set definition, including security and validation attributes.
• FND_FLEX_VALUES (synonym) and FND_FLEX_VALUES_TL (synonym) — the independent values and their translated descriptions.
• FND_FLEX_VALIDATION_TABLES (synonym) — supplies the SUMMARY_ALLOWED_FLAG.

The join logic is significant: U.FLEX_VALUE_SET_ID = V.FLEX_VALUE_SET_ID links the DFF column usage to its value set, while V.PARENT_FLEX_VALUE_SET_ID = U2.FLEX_VALUE_SET_ID(+) resolves the parent column. The subquery on U3.COLUMN_SEQ_NUM returns the maximum enabled parent column sequence below the current column, enforcing the correct hierarchical parent mapping.

Key Columns

• APPLICATION_ID, APPLICATION_NAME — owning application of the concurrent program.
• USER_CONCURRENT_PROGRAM_NAME, CONCURRENT_PROGRAM_NAME — program identity as seen by users and developers.
• PROGRAM_DESCRIPTION — concurrent program description.
• FLEX_VALUE_SET_ID, PARENT_FLEX_VALUE_SET_ID — the parameter's value set and, where applicable, its parent value set.
• SECURITY_ENABLED_FLAG — indicates whether value set security applies.
• VALIDATION_TYPE — validation method (independent, dependent, table, etc.).
• COLUMN_SEQ_NUM (referenced in the subquery) — determines the ordering of flexfield columns and drives the parent column resolution.
• FLEX_VALUE, FVT.DESCRIPTION — the value and its translated description.
• SUMMARY_ALLOWED_FLAG — whether summary values are permitted.

Common Use Cases and Queries

A common scenario is auditing concurrent program parameter value sets for security exposure. The following query lists programs whose parameters use security-enabled value sets:

• SELECT application_name, concurrent_program_name, flex_value_set_id, security_enabled_flag, validation_type FROM fnd_flex_conc_param_vset_v WHERE security_enabled_flag = 'Y' ORDER BY application_name, concurrent_program_name;

Another frequent use is identifying parent/child value set relationships for dependent parameters, where the parent is resolved through COLUMN_SEQ_NUM:

• SELECT concurrent_program_name, flex_value_set_id, parent_flex_value_set_id, validation_type FROM fnd_flex_conc_param_vset_v WHERE parent_flex_value_set_id IS NOT NULL;

Integrators and DBAs also use this view to enumerate validated values available for a parameter, joining FLEX_VALUE and FVT.DESCRIPTION to build pick lists or reference data extracts. Restricting by APPLICATION_ID or USER_CONCURRENT_PROGRAM_NAME keeps result sets small, since the view spans all SRS-flagged programs across applications.