Search Results fnd_flex_validation_rules




Overview
Explore in AI Chat

Overview

The FND_FLEX_VALIDATION_RULES table is a core repository for key flexfield cross-validation rules within the Oracle E-Business Suite (EBS) Application Object Library. It stores the master definition for rules that enforce complex business logic by validating combinations of segment values entered into a key flexfield, such as the Accounting Flexfield or Item Categories. These rules prevent the creation of invalid or nonsensical code combinations, ensuring data integrity. The table is fundamental to the flexfield architecture in both EBS 12.1.1 and 12.2.2, serving as the parent entity for the specific conditions (include and exclude lines) that constitute a complete validation rule.

Key Information Stored

The table's primary key uniquely identifies each rule and consists of four columns: APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM, and FLEX_VALIDATION_RULE_NAME. APPLICATION_ID and ID_FLEX_CODE identify the specific flexfield (e.g., "SQLGL" and "GL#" for the Accounting Flexfield). ID_FLEX_NUM specifies the particular structure version to which the rule applies. FLEX_VALIDATION_RULE_NAME is the unique identifier for the rule within that flexfield context. Other critical columns include ENABLED_FLAG, which controls whether the rule is active, and ERROR_SEGMENT_COLUMN_NAME, which can specify a particular segment to highlight when the rule triggers a validation error.

Common Use Cases and Queries

Primary use cases involve auditing, troubleshooting, and generating documentation for flexfield setups. Administrators often query this table to list all validation rules for a given flexfield or to identify disabled rules. A common reporting query joins with the FND_ID_FLEX_STRUCTURES table to get the structure name. For example, to list all rules for the Accounting Flexfield in a specific ledger structure:

  • SELECT rule.flex_validation_rule_name, rule.enabled_flag, struct.id_flex_structure_name
  • FROM fnd_flex_validation_rules rule, fnd_id_flex_structures struct
  • WHERE rule.application_id = struct.application_id
  • AND rule.id_flex_code = struct.id_flex_code
  • AND rule.id_flex_num = struct.id_flex_num
  • AND rule.id_flex_code = 'GL#'
  • AND rule.application_id = 101;

Another critical scenario is tracing a validation error encountered during data entry back to its master rule definition in this table.

Related Objects

The table has defined foreign key relationships with several core flexfield tables, as documented in the ETRM metadata. The FND_ID_FLEX_STRUCTURES table is referenced to validate the flexfield structure. The FND_ID_FLEX_SEGMENTS table is referenced via the ERROR_SEGMENT_COLUMN_NAME. The rule's detailed logic is stored in child tables: FND_FLEX_VALIDATION_RULE_LINES for the rule's conditions, and FND_FLEX_INCLUDE_RULE_LINES and FND_FLEX_EXCLUDE_RULE_LINES for specific include/exclude criteria. The FND_FLEX_VDATION_RULES_TL table stores translated rule names for multilingual installations. These relationships are foundational for querying a complete rule definition.