Search Results flex_value_rule_name




Overview
Explore in AI Chat

Overview

The FND_FLEX_VALUE_RULES table is a core data security object within the Oracle E-Business Suite Application Object Library (FND). It serves as the master repository for defining value security rules, a critical feature for controlling user access to specific values within key flexfields and descriptive flexfields. In the context of Oracle EBS 12.1.1 and 12.2.2, these rules enable administrators to restrict which segment values (e.g., specific cost centers, product codes, or account numbers) a user can view or select during data entry and querying, thereby enforcing data-level security policies directly within the application's flexfield structures.

Key Information Stored

The table stores the definitional header for each security rule. Its primary columns, as indicated by the metadata, include the unique identifier FLEX_VALUE_RULE_ID and the composite unique key formed by FLEX_VALUE_RULE_NAME and FLEX_VALUE_SET_ID. The FLEX_VALUE_SET_ID is a foreign key to FND_FLEX_VALUE_SETS, linking the rule to the specific set of valid values it governs. The PARENT_FLEX_VALUE_LOW column is significant for hierarchical value sets, as it can be used to define a rule based on a parent value, automatically including all its child values in the security constraint. The rule name provides a unique identifier for administrative assignment of the rule to responsibilities or users.

Common Use Cases and Queries

A primary use case is auditing and reporting on the security rules defined in the system. Administrators often need to generate a list of all rules for a particular value set, such as the Accounting Flexfield. A common query pattern joins FND_FLEX_VALUE_RULES to FND_FLEX_VALUE_SETS to provide a readable report.

  • Sample Query: SELECT ffvs.flex_value_set_name, ffvr.flex_value_rule_name, ffvr.parent_flex_value_low FROM apps.fnd_flex_value_rules ffvr, apps.fnd_flex_value_sets ffvs WHERE ffvr.flex_value_set_id = ffvs.flex_value_set_id AND ffvs.flex_value_set_name = '&VALUE_SET_NAME';
  • Implementation Scenario: A rule named "US_OPERATIONS_ONLY" is created for the "Cost Center" value set. This rule is then assigned via the "Define Security Rules" form to a responsibility, preventing users with that responsibility from seeing or entering cost center values outside the permitted range defined in the related FND_FLEX_VALUE_RULE_LINES table.

Related Objects

As per the provided foreign key relationships, FND_FLEX_VALUE_RULES is central to the value security architecture. The FND_FLEX_VALUE_RULE_LINES table stores the specific included and excluded value ranges for each rule. The FND_FLEX_VALUE_RULE_USAGES table records the assignment of these rules to specific responsibilities. The FND_FLEX_VALUE_RULES_TL table holds translated names for the rules in multiple languages. All these objects depend on the header definition in FND_FLEX_VALUE_RULES. Furthermore, the table has a mandatory relationship with FND_FLEX_VALUE_SETS, as a rule cannot exist without being associated with a value set.