Search Results column_seq_num




Overview
Explore in AI Chat

Overview

APPS.FND_FLEX_CONC_PARAM_VSET_V is a reporting and integration view in Oracle E-Business Suite that exposes the relationship between concurrent programs and the value sets used by their descriptive flexfield–based "SRS" (Standard Report Submission) parameters. In Oracle EBS, report parameters defined against a concurrent program are stored as descriptive flexfield segments under the special descriptive flexfield name $SRS$.<concurrent_program_name>. This view joins that parameter metadata against the value sets, validation tables, and value hierarchies that govern parameter validation, producing one row per enabled parameter segment with its associated value set and, where applicable, its parent value set.

The principal purpose of the view is to flatten the multi-level relationships among concurrent programs, parameter segments, and flexfield value sets into a single queryable result set. It is documented in ETRM under both 12.1.1 and 12.2.2, and its behavior is essentially identical across those releases because it is built entirely on the long-lived FND flexfield and concurrent program dictionary views. The COLUMN_SEQ_NUM attribute referenced in the view's definition is central to how parent/child value set associations are resolved, and it also directly reflects the sequence in which parameters appear on the concurrent program submission form.

Underlying Base Objects

The view is defined over the following documented base objects:

The parent value set is resolved through a correlated subquery over FND_DESCR_FLEX_COLUMN_USAGES (aliased U3) that selects the maximum COLUMN_SEQ_NUM strictly less than the current segment's COLUMN_SEQ_NUM, with NVL defaulting to 0 when no earlier segment exists. This correlates a parameter segment to the immediately preceding segment that supplies the parent value set.

Key Columns

Common Use Cases and Queries

Typical uses include auditing which value sets back a report's parameters, identifying dependent (parent/child) parameter structures, and reconciling parameter order against COLUMN_SEQ_NUM.

SELECT concurrent_program_name,
       end_user_column_name,
       flex_value_set_id,
       parent_flex_value_set_id,
       validation_type
FROM   apps.fnd_flex_conc_param_vset_v
WHERE  concurrent_program_name = 'XXCUSTOM_REPORT'
ORDER  BY concurrent_program_name;

Because the view traverses COLUMN_SEQ_NUM to derive parent value sets, it is the authoritative source for reconstructing parameter dependencies when troubleshooting dependent concurrent program parameters in both 12.1.1 and 12.2.2.