Search Results fnd_profile_option_values




Overview
Explore in AI Chat

Overview

The FND_PROFILE_OPTION_VALUES table is a core repository within the Oracle E-Business Suite Application Object Library (FND). It stores the specific values assigned to user profile options across the application's multi-level hierarchy. Profile options are system-wide settings that control application behavior, security, and functionality. The table's primary role is to persist the effective value for a given profile option at a specific level—such as Site, Application, Responsibility, or User—enabling the flexible and granular configuration that is fundamental to Oracle EBS operations in both 12.1.1 and 12.2.2 versions.

Key Information Stored

The table's structure is designed to uniquely identify a profile value assignment through its primary key and to define its context through foreign key relationships. Key columns include APPLICATION_ID and PROFILE_OPTION_ID, which together identify the specific profile option from the FND_PROFILE_OPTIONS table. The LEVEL_ID column indicates the hierarchical level (e.g., Site, Application, Responsibility, User) at which the value is set. The LEVEL_VALUE column holds the identifier for that specific level, such as a Responsibility ID or User ID. The LEVEL_VALUE_APPLICATION_ID is particularly relevant for the Responsibility level, storing the application ID of the responsibility referenced in LEVEL_VALUE. The actual value assigned to the profile option is stored in the PROFILE_OPTION_VALUE column.

Common Use Cases and Queries

A primary use case is auditing and troubleshooting system behavior by querying the effective settings of critical profile options. Developers and administrators frequently query this table to understand configuration hierarchies or to diagnose issues. A common pattern is to join with FND_PROFILE_OPTIONS and descriptive tables like FND_USER or FND_RESPONSIBILITY_TL for meaningful reports.

  • Sample Query for User-Level Values: SELECT fu.user_name, fpot.profile_option_name, fpov.profile_option_value FROM fnd_profile_option_values fpov, fnd_profile_options_tl fpot, fnd_user fu WHERE fpov.profile_option_id = fpot.profile_option_id AND fpov.level_id = 10004 AND fpov.level_value = fu.user_id AND fpot.language = USERENV('LANG');
  • Identifying a Specific Option's Settings: Queries often filter by PROFILE_OPTION_NAME (via a join) to see all value assignments for a single option across different levels, which is essential for resolving precedence conflicts.

Related Objects

FND_PROFILE_OPTION_VALUES is centrally linked to several key FND tables, as indicated by its foreign keys. The FND_PROFILE_OPTIONS table defines the master list of available options. For level-specific context, it references FND_USER for the User level, FND_RESPONSIBILITY for the Responsibility level, and FND_APPLICATION for the Application and Site levels. The primary API for interacting with these values programmatically is FND_PROFILE, which provides procedures for GET, PUT, and SAVE operations. For reporting, the views FND_PROFILE_OPTION_VALUES_VL and FND_PROFILE_OPTIONS_VL provide translated and more readily readable descriptions.