Skip to the content.

FND Flex Values – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports

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;

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

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, DFF Display

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

FND Flex Value Upload, FND Flex Value Hierarchy, FND Rollup Groups, GL Account Analysis, GL Account Analysis 11g, GL Account Distribution Analysis, GL Balance by Account Hierarchy, GL Balance

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output FND Flex Values 03-Mar-2024 002021.xlsx
Blitz Report™ XML Import FND_Flex_Values.xml
SQL Source FND Flex Values.sql
Full Report 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

The Solution

This Blitz Report extracts the value definition:

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

Performance & Optimization

FAQ


© Enginatics GmbH