Search Results fnd_flex_value_rules_s

Overview

FND_FLEX_VALUE_RULES_PKG is the Application Programming Interface (API) package that manages the definition, maintenance, and multilingual storage of key flexfield value rules within Oracle E-Business Suite. Value rules — also referred to as security rules — determine which individual values in a key flexfield value set a given responsibility may access. In Oracle EBS 12.1.1 and 12.2.2, the package resides in the APPS schema, holds a status of VALID, and is registered under the API classification OTHER in the ETRM repository. The package provides the programmatic backbone through which value rule hierarchies are inserted, updated, locked, deleted, loaded, and translated, ensuring that the underlying base table, translation table, and security table remain synchronized. Because value rules underpin flexfield security, this package operates in the critical path of Flexfield Value Security, a responsibility-level mechanism requiring profile option enablement as well as a defined security rule, value set, and included values. The object name FND_FLEX_VALUE_RULES_S, frequently returned by metadata lookups, corresponds to a table referenced by this package rather than the package itself.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions, each serving a discrete maintenance role:

• INSERT_ROW — Creates a new value rule definition and its associated translation records in the base and translation tables.
• LOCK_ROW — Acquires a row-level lock, typically invoked prior to updates to preserve concurrency integrity in multilingual environments.
• UPDATE_ROW — Modifies an existing value rule definition, propagating changes to dependent records.
• DELETE_ROW — Removes a value rule and its dependent translation and security entries.
• ADD_LANGUAGE — Inserts translation rows for a language newly installed or enabled in the environment.
• LOAD_ROW — Bulk-loads value rule definitions, typically used during data migration, patch application, or setup copy.
• TRANSLATE_ROW — Maintains translated (TL) content for value rule names and descriptions without altering base definitions.

These procedures follow the standard Oracle FND API conventions, including the use of the p_commit, p_validation_start_date, and p_validation_end_date parameters, though the exact signature should be verified against the deployment.

Tables Accessed

The package reads and writes several documented tables, all exposed via APPS synonyms:

• FND_FLEX_VALUE_RULES — The base table storing rule names, descriptions, and flexfield context.
• FND_FLEX_VALUE_RULES_S — The security table holding the value rules definition used by flexfield security enforcement.
• FND_FLEX_VALUE_RULES_TL — The translation table for language-specific name and description text, critical for multinational deployments.
• FND_FLEX_VALUE_SETS — The value set table, referenced to associate rules with their parent value sets.
• FND_LANGUAGES — Used by ADD_LANGUAGE to validate installed and enabled languages.
• DUAL — Used for single-row lookups and PL/SQL initialization.

Usage Notes

FND_FLEX_VALUE_RULES_PKG is typically invoked indirectly. It is called by the Flexfields Value Rules form (FNDFFMRU), by concurrent programs performing setup load or copy, and by custom migration scripts. Because the package references FND_FLEX_LOADER_APIS, it may participate in loader-driven bulk operations. Direct invocation is uncommon and should be reserved for controlled migrations, with standard validations (p_validation_start_date, p_validation_end_date) set to enforce row-level audit trails. The package is referenced by other APPS objects and, in turn, depends on FND_MESSAGE, APP_EXCEPTION, and STANDARD, confirming it emits user-facing messages and raises standard exceptions during error handling.