Results for “fnd_flex_value_rule_usages_u1”

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

Overview

FND_FLEX_VALUE_RULE_USAGES is a reference table in the Oracle E-Business Suite Application Object Library (FND) product, owned by the APPLSYS schema. It records the assignment of flexfield security rules to responsibilities, forming the bridge between a defined security rule and the responsibility under which that rule becomes active. When a key flexfield or descriptive flexfield segment is protected using a security rule, the rule must be associated with one or more responsibilities for it to take effect; this table stores those associations.

Under the heuristic Data Vault classification mined from its foreign key structure, FND_FLEX_VALUE_RULE_USAGES is best modeled as a link table. It resolves a many-to-many relationship between responsibilities and flexfield security rules, carrying the foreign keys that connect those entities rather than serving as a standalone hub of business concepts or a descriptive satellite.

Key Information Stored

The table holds twelve documented columns in release 12.2.2. The most important are:

• APPLICATION_ID — Identifies the application that owns the responsibility. Part of the composite primary key and a foreign key to FND_RESPONSIBILITY.
• RESPONSIBILITY_ID — Identifies the responsibility to which the security rule is assigned. Also part of the primary key and the FND_RESPONSIBILITY foreign key.
• FLEX_VALUE_RULE_ID — Identifies the flexfield security rule being assigned. Part of the primary key and a foreign key to FND_FLEX_VALUE_RULES.
• FLEX_VALUE_SET_ID — Identifies the flexfield value set against which the rule applies; foreign key to FND_FLEX_VALUE_SETS.
• PARENT_FLEX_VALUE_LOW and PARENT_FLEX_VALUE_HIGH — Define the low and high bounds of the parent flex value range governed by the usage.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard FND audit columns.
• ZD_EDITION_NAME — Editioning column supporting online patching in 12.2.x.

The surrogate primary key is FND_FLEX_VALUE_RULE_USAGES_PK over (APPLICATION_ID, RESPONSIBILITY_ID, FLEX_VALUE_RULE_ID). The unique index FND_FLEX_VALUE_RULE_USAGES_U1 extends this business key with ZD_EDITION_NAME, reflecting the edition-aware uniqueness requirement in 12.2.2.

Common Use Cases and Queries

Administrators and developers query this table to determine which responsibilities are bound to a given flexfield security rule, or which rules apply to a given responsibility.

• List all rule usages for a specific responsibility:

  SELECT flex_value_rule_id, flex_value_set_id, parent_flex_value_low, parent_flex_value_high FROM fnd_flex_value_rule_usages WHERE application_id = :app_id AND responsibility_id = :resp_id;

• Identify responsibilities sharing a rule, to assess security impact before modifying it:

  SELECT responsibility_id FROM fnd_flex_value_rule_usages WHERE flex_value_rule_id = :rule_id;

• Join to FND_FLEX_VALUE_RULES and FND_FLEX_VALUE_SETS to report rule names and value set names alongside assigned responsibilities.

Related Objects

• FND_FLEX_VALUE_RULES — joined on FLEX_VALUE_RULE_ID; holds the security rule definition.
• FND_FLEX_VALUE_SETS — joined on FLEX_VALUE_SET_ID; defines the value set the rule protects.
• FND_RESPONSIBILITY — joined on APPLICATION_ID and RESPONSIBILITY_ID; defines the responsibility receiving the rule.
• FND_FLEX_VALUE_RULE_LINES — defines the individual value ranges that make up a rule referenced here.