Search Results fnd_flex_val_rule_stats_u1

Overview

APPLSYS.FND_FLEX_VALIDATION_RULE_STATS is a VALID dictionary table in Oracle E-Business Suite, shipped as FND design data (FND.FND_FLEX_VALIDATION_RULE_STATS) and stored in the APPS_TS_SEED tablespace. The table stores statistics on the number of key flexfield cross-validation rules and rule lines for a given key flexfield structure. These statistics are used to optimize the queries that the server validation function performs against FND_FLEX_VALIDATION_RULES, FND_FLEX_INCLUDE_RULE_LINES, and FND_FLEX_EXCLUDE_RULE_LINES. Rather than forcing the validation engine to scan the underlying rule and rule-line tables on every invocation, the statistics recorded here allow the validation logic to short-circuit or plan its queries based on counts already known for the structure.

The object is present in both Oracle EBS 12.1.1 and 12.2.2. In 12.2.2 the physical schema exposes twelve columns and a composite business key that includes the edition column. The metadata classifies the object as satellite-leaning under a heuristic Data Vault model, which is a reasonable modeling suggestion: the structure identifiers form the parent reference while the counts, plus the standard Who columns, are the descriptive, change-tracking payload. Storage parameters are PCT Free 10 on the APPS_TS_SEED tablespace.

Key Information Stored

The table is keyed by the structure it describes. The documented primary key FND_FLEX_VAL_RULE_STATS_PK is composed of APPLICATION_ID, ID_FLEX_CODE, and ID_FLEX_NUM. The unique index FND_FLEX_VAL_RULE_STATS_U1 — the index referenced in the search term fnd_flex_val_rule_stats_u1 — spans APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM, and ZD_EDITION_NAME, making it the business-key candidate that also accounts for the edition dimension.

• APPLICATION_ID — application identifier; names the application owning the key flexfield.
• ID_FLEX_CODE — the key flexfield code (for example GL# or similar).
• ID_FLEX_NUM — the key flexfield structure number, identifying the specific structure under the flexfield code.
• ZD_EDITION_NAME — edition column carried in the unique index and used in the 12.2.2 data model.
• RULE_COUNT — number of cross-validation rules defined for the structure.
• INCLUDE_LINE_COUNT — number of include rule lines for the structure.
• EXCLUDE_LINE_COUNT — number of exclude rule lines for the structure.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide the audit trail for each statistics row.

The statistical columns are the operative payload; the Who columns provide change tracking, and the key columns anchor each row to a single flexfield structure.

Common Use Cases and Queries

The primary consumer is the flexfield server validation function, which reads these counts to optimize its access path. From a support and reporting perspective, the table is useful for identifying structures that carry heavy validation workloads and for confirming whether statistics are stale after rule maintenance. A representative query retrieves statistics for a specific structure:

• SELECT APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM, RULE_COUNT, INCLUDE_LINE_COUNT, EXCLUDE_LINE_COUNT FROM APPLSYS.FND_FLEX_VALIDATION_RULE_STATS WHERE ID_FLEX_CODE = :code AND ID_FLEX_NUM = :num;
• Aggregate workload view: SELECT ID_FLEX_CODE, SUM(RULE_COUNT), SUM(INCLUDE_LINE_COUNT), SUM(EXCLUDE_LINE_COUNT) FROM APPLSYS.FND_FLEX_VALIDATION_RULE_STATS GROUP BY ID_FLEX_CODE;
• Freshness check: compare LAST_UPDATE_DATE against rule maintenance activity to decide whether statistics should be regenerated.

Note that the table is a statistics store, so it should be treated as derived data; direct DML is normally inappropriate, and remediation is performed through the application's flexfield maintenance flows.

Related Objects

The table participates in a narrow dependency footprint centered on flexfield validation.

• FND_FLEX_VALIDATION_RULES — the cross-validation rules the RULE_COUNT summarizes.
• FND_FLEX_INCLUDE_RULE_LINES — include rule lines summarized by INCLUDE_LINE_COUNT.
• FND_FLEX_EXCLUDE_RULE_LINES — exclude rule lines summarized by EXCLUDE_LINE_COUNT.
• FND_ID_FLEX_STRUCTURES — referenced through APPLICATION_ID; joins on application and structure identifiers.
• APPLSYS.FND_FLEX_VALIDATION_RULE_STAT# — the 12.2.2 editioning artifact that references the base object.

These relationships confirm that the table is a satellite-style statistics store attached to the key flexfield structure hierarchy and the validation rule tables.