Results for “fnd_flex_values”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_FLEX_VALUES is the core Application Object Library table that stores the valid values belonging to a flexfield value set. Owned by the APPLSYS schema, it is the central repository from which Oracle EBS validates any key flexfield, descriptive flexfield, or global descriptive flexfield segment that draws its list of values from an independent or dependent value set. Every value a user selects during data entry in a flexfield segment ultimately originates from a row in this table, making it one of the most heavily referenced objects in the EBS data model.

Each row represents a single flexfield value, uniquely identified by the surrogate primary key FLEX_VALUE_ID enforced through FND_FLEX_VALUES_PK. The table links to FND_FLEX_VALUE_SETS through the foreign key column FLEX_VALUE_SET_ID, establishing the parent value set to which the value belongs. Additional unique indexes, FND_FLEX_VALUES_U1 on (FLEX_VALUE_ID, ZD_EDITION_NAME) and FND_FLEX_VALUES_U2 on (FLEX_VALUE_SET_ID, PARENT_FLEX_VALUE_LOW, FLEX_VALUE, ZD_EDITION_NAME), serve as business-key candidates that enforce value uniqueness within a value set and its hierarchy context. The heuristic Data Vault classification of this object is hub-leaning: it behaves as a durable keyed entity from which dependent descriptive and mapping structures radiate.

Key Information Stored

Although the documented physical schema contains seventy columns, the functionally significant attributes are concentrated in a small set. The most important columns include:

• FLEX_VALUE_ID – surrogate primary key that uniquely identifies each value row.
• FLEX_VALUE_SET_ID – foreign key to FND_FLEX_VALUE_SETS, defining the value set ownership.
• FLEX_VALUE – the actual value string stored against the segment, and part of the unique business key.
• ENABLED_FLAG and SUMMARY_FLAG – control whether the value is active and whether it is a summary (parent) node.
• START_DATE_ACTIVE and END_DATE_ACTIVE – effective-dating window governing value availability.
• PARENT_FLEX_VALUE_LOW and PARENT_FLEX_VALUE_HIGH – define parent/child ranges for hierarchical and dependent value sets.
• STRUCTURED_HIERARCHY_LEVEL and HIERARCHY_LEVEL – level placement within a value hierarchy.
• COMPILED_VALUE_ATTRIBUTES – cached compilation of the descriptive attributes for performance.
• VALUE_CATEGORY – metadata classification applied to the value.
• ATTRIBUTE1 through ATTRIBUTE50 – the flexfield value attribute columns that hold segment-specific descriptive data.
• ATTRIBUTE_SORT_ORDER – controls presentation ordering of attribute values.
• Standard audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Because virtually all flexfield validation resolves to this table, it is central to value set maintenance, chart of accounts reporting, and reconciliation of dependent segments. Typical queries resolve active values for a given value set or reconstruct a hierarchy.

• Listing enabled values for a value set: SELECT FLEX_VALUE, DESCRIPTION FROM FND_FLEX_VALUES_VL WHERE FLEX_VALUE_SET_ID = :set_id AND ENABLED_FLAG = 'Y';
• Joining to the value set definition to translate set names: SELECT fv.FLEX_VALUE, fvs.FLEX_VALUE_SET_NAME FROM FND_FLEX_VALUES fv JOIN FND_FLEX_VALUE_SETS fvs ON fv.FLEX_VALUE_SET_ID = fvs.FLEX_VALUE_SET_ID;
• Recovering parent-child structure using PARENT_FLEX_VALUE_LOW to walk hierarchies.
• Auditing effective dates by filtering on START_DATE_ACTIVE and END_DATE_ACTIVE.
• Reporting on descriptive attributes held in ATTRIBUTE1 through ATTRIBUTE50 for a specific value set.

Related Objects

The following objects are most significant in relation to FND_FLEX_VALUES:

• FND_FLEX_VALUE_SETS – parent of the FLEX_VALUE_SET_ID foreign key; defines the value set each value belongs to.
• FND_FLEX_VALUES_TL – translation table joined on FLEX_VALUE_ID, holding language-specific descriptive text.
• JL_CO_GL_NIT_ACCTS – references FLEX_VALUE_ID, linking values to Colombian GL NIT account definitions.
• FV_FACTS_PRC_DTL – references FLEX_VALUE_ID within the Federal financials process detail structure.
• PSB_FLEX_MAPPING_SET_VALUES – references FLEX_VALUE_ID in public sector budgeting mapping configurations.
• The FND_FLEX_VALUES_VL and FND_FLEX_VALUES_V views – translated and validation views exposing value data for concurrent programs and forms.

Together these dependencies confirm FND_FLEX_VALUES as the hub entity anchoring value validation, translation, and downstream mapping across multiple EBS product modules.