Search Results fnd_flex_value_rule_lines




Overview
Explore in AI Chat

Overview

The FND_FLEX_VALUE_RULE_LINES table is a core data object within the Oracle E-Business Suite (EBS) Application Object Library (FND). It functions as the detailed repository for rule elements that constitute flexfield value security rules. These rules are a critical component of the application's security model, governing user access to specific ranges or lists of key flexfield segment values. The table operates in conjunction with the parent FND_FLEX_VALUE_RULES table to define and enforce data-level security, ensuring users can only view or select authorized values within a flexfield, such as specific cost centers, account codes, or product categories.

Key Information Stored

Each record in this table defines a single rule element, which is a value range or a discrete value within a flexfield value set. The primary key is a composite of FLEX_VALUE_RULE_ID, FLEX_VALUE_HIGH, and FLEX_VALUE_LOW, ensuring uniqueness for each line under a rule. The FLEX_VALUE_RULE_ID column is a foreign key linking the line to its parent security rule in the FND_FLEX_VALUE_RULES table. The FLEX_VALUE_SET_ID links the line to the specific value set (FND_FLEX_VALUE_SETS) to which the security applies. The FLEX_VALUE_LOW and FLEX_VALUE_HIGH columns define the inclusive range of values covered by this rule line. The INCLUDE_EXCLUDE_INDICATOR is a crucial flag specifying whether the defined range is accessible ('I' for Include) or restricted ('E' for Exclude) for the users assigned to the parent rule.

Common Use Cases and Queries

A primary use case is auditing and troubleshooting flexfield value security setups. Administrators often query this table to understand the complete security landscape for a user or responsibility. For example, to list all rule lines for a specific security rule identified by its FLEX_VALUE_RULE_ID, a common query pattern is:

  • SELECT flex_value_set_id, flex_value_low, flex_value_high, include_exclude_indicator FROM apps.fnd_flex_value_rule_lines WHERE flex_value_rule_id = &rule_id ORDER BY flex_value_set_id, flex_value_low;

Another critical scenario is generating a report of all security rules and their component lines for a given value set, which involves joining to FND_FLEX_VALUE_RULES. Developers may also query this table programmatically within custom reports or extensions to respect and apply the same value security logic.

Related Objects

The FND_FLEX_VALUE_RULE_LINES table has direct dependencies on two key parent tables via foreign key constraints. The FLEX_VALUE_RULE_ID column references FND_FLEX_VALUE_RULES, which stores the rule's header information, such as the rule name and assigned responsibilities. The FLEX_VALUE_SET_ID column references FND_FLEX_VALUE_SETS, the master table for flexfield value set definitions. These relationships are fundamental; a rule line is meaningless without its parent rule and associated value set. The table is also central to the underlying logic of the "Flexfield Value Security" feature, which is typically administered through the standard EBS forms or the "Define Security Rules" function, not via direct DML.