FND Flex Values
Description
Categories: Enginatics, Toolkit - Setup & Support
Repository: Github Columns: Flex Value Set Name, Independent Value, Flex Value, Translated Value, Description, Enabled, Start Date Active, End Date Active, Parent, Rollup Group ...
Repository: Github Columns: Flex Value Set Name, Independent Value, Flex Value, Translated Value, Description, Enabled, Start Date Active, End Date Active, Parent, Rollup Group ...
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.
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.
select ffvs.flex_value_set_name, ffvv.parent_flex_value_low independent_value, ffvv.flex_value, ffvv.flex_value_meaning translated_value, ffvv.description, xxen_util.meaning(decode(ffvv.enabled_flag,'Y','Y'),'YES_NO',0) enabled, ffvv.start_date_active, ffvv.end_date_active, xxen_util.meaning(decode(ffvv.summary_flag,'Y','Y'),'YES_NO',0) parent, ffhv.hierarchy_name rollup_group, ffvv.hierarchy_level, (select distinct listagg(ffvnh.parent_flex_value,', ') within group (order by ffvnh.parent_flex_value) over () from fnd_flex_value_norm_hierarchy ffvnh where 2=2 and ffvv.summary_flag=decode(ffvnh.range_attribute,'P','Y','N') and ffvv.flex_value between ffvnh.child_flex_value_low and ffvnh.child_flex_value_high and ffvs.flex_value_set_id=ffvnh.flex_value_set_id) parent_values, &value_attributes ffvv.compiled_value_attributes, xxen_util.user_name(ffvv.created_by) created_by, xxen_util.client_time(ffvv.creation_date) creation_date, xxen_util.user_name(ffvv.last_updated_by) last_updated_by, xxen_util.client_time(ffvv.last_update_date) last_update_date from fnd_flex_value_sets ffvs, fnd_flex_values_vl ffvv, fnd_flex_hierarchies_vl ffhv where 1=1 and ffvs.flex_value_set_id=ffvv.flex_value_set_id and ffvv.structured_hierarchy_level=ffhv.hierarchy_id(+) order by ffvs.flex_value_set_name, ffvv.parent_flex_value_low, ffvv.flex_value |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Created By |
| LOV | |
Last Updated By |
| LOV | |
Active only |
| LOV | |
Used by Key Flexfield |
| LOV | |
Used by Key Flex Structure |
| LOV | |
Missing in Hierarchy |
| LOV | |
Flex Value Set |
| LOV | |
Flex Value like |
| ||
Creation Date From |
| Date | |
Last Update Date From |
| DateTime | |
Parent or Child |
| LOV | |
Parent Value like |
| ||
Flex Value Set |
|