Search Results fnd_flex_values




Here's a detailed description of the FND_FLEX_VALUES table in Oracle E-Business Suite (EBS):

Table Name: FND_FLEX_VALUES

Purpose:
The FND_FLEX_VALUES table stores individual values for flexfield value sets used across the Oracle E-Business Suite application.

Key Columns:
1. FLEX_VALUE_ID (Primary Key)
- Unique identifier for each flex value
- Typically a number generated by a sequence

2. FLEX_VALUE_SET_ID
- Foreign key to FND_FLEX_VALUE_SETS
- Identifies the value set to which this flex value belongs

3. FLEX_VALUE
- Actual value stored in the flexfield
- Can be alphanumeric depending on value set definition

4. DESCRIPTION
- Description of the flex value
- Optional descriptive text for the value

5. ENABLED_FLAG
- Indicates if the value is currently active/usable
- 'Y' or 'N' typically

6. START_DATE_ACTIVE
- Date from which the value becomes active

7. END_DATE_ACTIVE
- Date until which the value remains active

8. PARENT_FLEX_VALUE
- Used for hierarchical value sets
- Represents parent value in a hierarchy

Common Use Cases:
- Accounting flexfields
- Descriptive flexfields
- Validating and controlling user input
- Maintaining structured value lists

Typical Queries:
```sql
SELECT flex_value, description
FROM fnd_flex_values
WHERE flex_value_set_id = :value_set_id
AND enabled_flag = 'Y';
```

Related Tables:
- FND_FLEX_VALUE_SETS
- FND_FLEX_VALUES_TL (Translation table)