Skip to content

FND Flex Values

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

FND Flex Values

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
FND Flex Values.sql
FND Flex Values.sql
 
 
README.md
README.md
 
 

README.md

layout default
title FND Flex Values | Oracle EBS SQL Report
description Report for all flex values and the hierarchies they are included in. Column 'Hierarchy Position' can be used to validate your account hierarchy setup and…
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Flex, Values, fnd_flex_value_norm_hierarchy, fnd_flex_value_sets, fnd_flex_values
permalink /FND%20Flex%20Values/

FND Flex Values – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Report for all flex values and the hierarchies they are included in. Column 'Hierarchy Position' can be used to validate your account hierarchy setup and check which account segment values are not included in any (or a specific) hierarchy yet.

In EBS R12.2., there is new flexfield value security in place, which would require the UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE role to maintain flexfield values. If you do not have this role but apps DB access, you can add it from the backend:

begin wf_local_synch.propagateuserrole( p_user_name=>'ANDY.HAACK', p_role_name=>'UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE' ); commit; end;

Report Parameters

Used by Key Flexfield, Used by Key Flex Structure, Flex Value Set, Independent Value, Flex Value like, Created By, Creation Date From, Creation Date To, Last Updated By, Last Update Date From, Last Update Date To, Active only, Missing in Hierarchy, Parent or Child, Parent Value like, Used in Rollup Group, Show DFF Attributes

Oracle EBS Tables Used

fnd_flex_value_norm_hierarchy, fnd_flex_value_sets, fnd_flex_values, fnd_flex_values_tl, fnd_flex_hierarchies_vl

Report Categories

Enginatics

Related Reports

FND Flex Value Upload, FND Flex Value Hierarchy, FND Rollup Groups, GL Account Analysis, GL Account Analysis (Distributions), GL Account Analysis 11g, GL Account Distribution Analysis

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output FND Flex Values 03-Mar-2024 002021.xlsx
Blitz Report™ XML Import FND_Flex_Values.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-flex-values/

Executive Summary

The FND Flex Values report is the standard master data report for segment values. It lists every value in an Independent or Dependent value set, along with its attributes and hierarchy status.

Business Challenge

  • Master Data Management: Reviewing the list of active Cost Centers, Accounts, or Products.
  • Hierarchy Maintenance: Identifying "Orphan" values that are missing from a parent hierarchy (using the "Missing in Hierarchy" parameter).
  • Attribute Audit: Checking settings like "Allow Budgeting" or "Allow Posting" for GL accounts.

The Solution

This Blitz Report extracts the value definition:

  • Value: The code and description.
  • Status: Enabled/Disabled, Start/End Dates.
  • Attributes: Segment qualifiers (Account Type, Reconcile, etc.).
  • Hierarchy: Shows if the value is a Parent or Child and which Rollup Group it belongs to.

Technical Architecture

The report queries FND_FLEX_VALUES and FND_FLEX_VALUES_TL. It also checks FND_FLEX_VALUE_NORM_HIERARCHY to determine hierarchy status.

Parameters & Filtering

  • Flex Value Set: The set to analyze (e.g., "Operations_Account").
  • Missing in Hierarchy: A critical filter for GL maintenance. It finds values that exist but are not rolled up to any parent.
  • Active only: Filter out disabled values.

Performance & Optimization

  • Volume: For very large charts of accounts, filter by a specific range or value set to keep the report manageable.

FAQ

  • Q: How do I see the "Compiled" attributes?
    • A: The report shows the raw attributes stored in COMPILED_VALUE_ATTRIBUTES. These are often decoded into readable columns like "Account Type".

Useful Links

© 2026 Enginatics