Search Results fnd_flex_include_rule_lines




Overview
Explore in AI Chat

Overview

The FND_FLEX_INCLUDE_RULE_LINES table is a core data object within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a repository for the individual elements that constitute a cross-validation rule. Cross-validation rules are critical business logic components that govern which combinations of key flexfield segment values are permitted to coexist within a single flexfield code combination. This table stores the specific segment values or ranges that are explicitly allowed (included) by a rule, working in conjunction with exclusion rules to enforce complex data integrity across applications such as Oracle General Ledger.

Key Information Stored

The table's primary purpose is to define the permissible elements for a cross-validation rule. Its structure is centered around linking these elements to their parent rule and identifying the specific flexfield context. The most critical columns include RULE_LINE_ID, which is the primary key and uniquely identifies each rule element. The columns APPLICATION_ID, ID_FLEX_CODE, and ID_FLEX_NUM together identify the specific flexfield structure to which the rule applies. The FLEX_VALIDATION_RULE_NAME column links the element to its parent cross-validation rule definition stored in FND_FLEX_VALIDATION_RULES. Additional columns, not detailed in the provided metadata but standard for such rules, would typically store the segment number, a low value, and a high value to define the allowed range for that segment within the rule.

Common Use Cases and Queries

This table is primarily accessed for auditing, troubleshooting, and reporting on the configuration of cross-validation rules. A common scenario involves identifying all segment value inclusions for a specific rule to understand its complete logic. A typical query would join to the parent rule table. For example:

  • Listing all inclusion elements for a rule:
    SELECT rule_line_id, segment_num, include_low, include_high
    FROM apps.fnd_flex_include_rule_lines
    WHERE application_id = 101
    AND id_flex_code = 'GL#'
    AND flex_validation_rule_name = 'MY_CV_RULE'
    ORDER BY segment_num;
  • Troubleshooting validation errors: Developers and functional consultants query this table alongside exclusion rules to diagnose why certain code combination attempts are failing during data entry.
  • Impact analysis: Before modifying or deactivating a cross-validation rule, administrators may query this table to inventory all its constituent inclusion elements.

Related Objects

The FND_FLEX_INCLUDE_RULE_LINES table has defined foreign key relationships with other core flexfield validation tables, as documented in the metadata. These relationships are fundamental to maintaining referential integrity within the rule definition subsystem.

  • FND_FLEX_VALIDATION_RULE_LINES: Joined via RULE_LINE_ID. This is the primary parent table for rule line details, indicating that each inclusion line is a subtype of a general validation rule line.
  • FND_FLEX_VALIDATION_RULES: Joined via the composite key of APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM, and FLEX_VALIDATION_RULE_NAME. This links the inclusion elements to the master definition of the cross-validation rule itself.

These relationships ensure that inclusion lines cannot exist without a corresponding parent rule and rule line record, enforcing a coherent rule hierarchy.