Results for “include_exclude_indicator”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_FLEX_VALUE_RULE_LINES is a core Application Object Library (FND) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the individual rule elements comprising flexfield value security rules. Each row represents a discrete range definition — a low value, a high value, and an include/exclude indicator — that together form the logic of a named security rule. Security rules are assigned to responsibility and user combinations, and they govern which key flexfield or descriptive flexfield values a user is permitted to enter, query, or report against. Because value security is enforced at the segment-value level, this table sits directly beneath the operational security model of the General Ledger chart of accounts and other flexfield-enabled applications.

The ETRM metadata classifies this object heuristically as a link, indicating that the table primarily models a relationship between two other entities — the parent rule (FND_FLEX_VALUE_RULES) and the value set (FND_FLEX_VALUE_SETS) — rather than acting as a standalone descriptive hub or a slowly changing satellite.

Key Information Stored

The table contains 13 documented columns. The most significant are:

• FLEX_VALUE_RULE_ID — Foreign key to FND_FLEX_VALUE_RULES; identifies the parent security rule to which the line belongs.
• FLEX_VALUE_SET_ID — Foreign key to FND_FLEX_VALUE_SETS; identifies the value set whose values the rule restricts.
• FLEX_VALUE_LOW — The lower boundary of the value range for this rule line. This column is the target of the commonly searched term "flex_value_low" and is used in most range-filter queries.
• FLEX_VALUE_HIGH — The upper boundary of the range. When equal to FLEX_VALUE_LOW, the line restricts a single value.
• PARENT_FLEX_VALUE_LOW and PARENT_FLEX_VALUE_HIGH — Optional parent-segment range constraints used for dependent or hierarchical value sets.
• INCLUDE_EXCLUDE_INDICATOR — Determines whether the defined range is included in or excluded from the accessible value set.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard audit columns maintained by the EBS framework.
• ZD_EDITION_NAME — Editioning column supporting online patching in 12.2.x; always set to "SET1" in 12.2.2 until an edition is applied.

The surrogate primary key is FND_FLEX_VALUE_RULE_LINES_PK (FLEX_VALUE_RULE_ID, FLEX_VALUE_HIGH, FLEX_VALUE_LOW, INCLUDE_EXCLUDE_INDICATOR). A business-key candidate is provided by the unique index FND_FLEX_VALUE_RULE_LINES_U1 (FLEX_VALUE_RULE_ID, INCLUDE_EXCLUDE_INDICATOR, FLEX_VALUE_LOW, FLEX_VALUE_HIGH, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical scenarios include auditing which value ranges are permitted for a given responsibility, diagnosing "value not permitted" errors during data entry, and migrating or comparing security rules between environments.

• Listing all rule lines for a named rule:

SELECT l.flex_value_low, l.flex_value_high, l.include_exclude_indicator
FROM   fnd_flex_value_rule_lines l,
       fnd_flex_value_rules r
WHERE  l.flex_value_rule_id = r.flex_value_rule_id
AND    r.flex_value_rule_name = :rule_name;

• Finding which rules cover a specific value using a range predicate on FLEX_VALUE_LOW and FLEX_VALUE_HIGH.
• Identifying rules that already exist for a value set before creating a new rule.
• Reporting on the total count of include versus exclude lines per rule for governance review.

Related Objects

The most significant related objects, driven by the documented foreign keys and primary key, are:

• FND_FLEX_VALUE_RULES — Parent table; joined on FLEX_VALUE_RULE_ID.
• FND_FLEX_VALUE_SETS — Referenced by FLEX_VALUE_SET_ID.
• FND_FLEX_VALUE_RULE_LINES_PK and FND_FLEX_VALUE_RULE_LINES_U1 — Primary and unique indexes enforcing integrity.
• FND_FLEX_VALIDATION and compiled value security views generated from rule assignments.
• FND_FLEX_VALUES / FND_FLEX_VALUES_TL — The values the rule lines restrict.
• FND_RESPONSIBILITY / FND_USER — Consumers through rule assignment tables such as FND_FLEX_VALUE_RULES.