Search Results fnd_vset




Overview
Explore in AI Chat

Overview

FND_VSET is a PL/SQL package body owned by the APPS schema that provides the runtime engine for validating Oracle E-Business Suite Flexfield values against defined value sets. In Oracle EBS 12.1.1 and 12.2.2, key and descriptive flexfields rely on value sets stored in the FND_FLEX_VALUE_SETS and FND_FLEX_VALUES tables to constrain and validate user input. The FND_VSET package encapsulates the logic required to fetch and test those values, exposing a programmatic interface that forms, concurrent programs, and other PL/SQL packages can call to determine whether a submitted value is valid for a given value set.

The package body is reported as VALID and is classified under the API classification OTHER in the ETRM repository. It depends on the APPS schema objects, PUBLIC synonyms for DBMS_SQL, and the SYS STANDARD package. A distinguishing characteristic is its asymmetry in the dependency graph: FND_VSET is referenced by 42 other database objects, but the package itself is not referenced by any database object, confirming its role as a low-level utility consumed broadly across the applications stack rather than a top-level caller.

Key Procedures and Functions

The ETRM metadata documents eight public procedures and functions within the package body:

  • GET_VALUESET — Retrieves and initializes the definition of a value set, loading its configuration for subsequent validation activity.
  • GET_VALUE_INIT — Initializes the value-fetching process, preparing the internal state needed to iterate over the values associated with a value set.
  • GET_VALUE — Returns the next value from the active value set during an iteration sequence.
  • GET_VALUE_END — Terminates the value-fetching sequence and releases the state established by GET_VALUE_INIT.
  • TEST — Validates a supplied value against a value set, returning the outcome of the check.
  • TEST_INDEPENDENT — Performs independent validation, typically for value sets whose values are not derived from a dependent parent value.
  • TEST_TABLE — Validates a value against a table-validated value set, querying the underlying validation table.
  • DEBUG — Controls debug output to assist with diagnosing validation behavior.

The GET_VALUE_INIT, GET_VALUE, and GET_VALUE_END triad mirrors a standard cursor-style iteration pattern, allowing callers to enumerate the permissible values of a value set programmatically rather than through a UI list of values.

Tables Accessed

Through APPS synonyms, the package references the following base tables:

  • FND_FLEX_VALUE_SETS — Stores the header definition of each value set, including its validation type and formatting attributes.
  • FND_FLEX_VALUES and FND_FLEX_VALUES_VL — Store the individual valid values belonging to a value set; the VL view supplies the translated value descriptions.
  • FND_FLEX_VALIDATION_TABLES — Defines the table and column mappings used by table-validated value sets, which TEST_TABLE draws upon.
  • DBMS_SQL — The dynamic SQL facility the package uses to construct and execute validation queries at runtime, enabling table-validated value sets whose target tables and columns vary by definition.

Usage Notes

FND_VSET is invoked indirectly during virtually every flexfield validation performed in Oracle EBS forms, where the Flexfield runtime calls into value-set validation logic to confirm user entries. Concurrent programs that import or interface flexfield data call it when validating incoming values before load. Custom PL/SQL code may also call TEST, TEST_INDEPENDENT, or TEST_TABLE directly to enforce the same value-set rules applied by the standard application. Because the package is referenced by 42 other database objects and depends on DBMS_SQL for dynamic validation, it should be treated as foundational infrastructure; modifications are not supported, and any direct invocation by custom code must respect the documented procedure semantics without assuming parameter contracts not published in the ETRM metadata.