Search Results fnd_profile_option_values_pk

Overview

FND_PROFILE_OPTION_VALUES is the transactional store for Oracle E-Business Suite profile option settings. Owned by the APPLSYS schema and belonging to the FND - Application Object Library product, it holds the values of user profile options defined at different profile levels. In Oracle EBS 12.1.1 and 12.2.2, profile options govern runtime behavior across all applications; this table records the actual assigned value for each profile option at a specific hierarchy level, such as Site, Application, Responsibility, or User.

The object is a core configuration table rather than a transactional ledger. Each row binds a profile option to a level and level value, with the value itself stored in PROFILE_OPTION_VALUE. Because profile values are resolved by layering Site, Application, Responsibility, and User settings, this table is central to how EBS determines effective behavior at sign-on and runtime.

From a Data Vault modeling perspective, the mined classification is link. This suggests the table is best understood as an associative structure connecting profile options, hierarchy levels, and the entities (users, responsibilities, applications) at which values are defined, rather than as a standalone hub or descriptive satellite.

Key Information Stored

The table is documented with 13 columns in the ETRM 12.2.2 physical schema. The most significant columns are:

• APPLICATION_ID — identifies the application context of the profile option; part of the primary key and a foreign key to FND_PROFILE_OPTIONS.
• PROFILE_OPTION_ID — the profile option being set; part of the primary key and a foreign key to FND_PROFILE_OPTIONS.
• LEVEL_ID — the profile hierarchy level at which the value applies (for example Site, Application, Responsibility, or User).
• LEVEL_VALUE — the identifier of the specific entity at that level, such as a user ID, responsibility ID, or application ID. It participates in foreign key relationships to FND_USER, FND_RESPONSIBILITY, and FND_APPLICATION.
• LEVEL_VALUE_APPLICATION_ID — the owning application of the level value; part of the primary key and a foreign key to FND_RESPONSIBILITY.
• PROFILE_OPTION_VALUE — the actual value assigned to the profile option at the given level.
• LEVEL_VALUE2 — a secondary level value column included in the unique index.
• ZD_EDITION_NAME — the edition name used for edition-based redefinition in 12.2.x.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN capture who created and last changed each row.

The primary key is FND_PROFILE_OPTION_VALUES_PK, defined on APPLICATION_ID, PROFILE_OPTION_ID, LEVEL_ID, LEVEL_VALUE, and LEVEL_VALUE_APPLICATION_ID. The unique index FND_PROFILE_OPTION_VALUES_U1 extends this business-key candidate with LEVEL_VALUE2 and ZD_EDITION_NAME. The surrogate PK and business-key candidate therefore overlap substantially, with the unique index adding the secondary level value and edition dimension to guarantee uniqueness across editions.

Common Use Cases and Queries

Typical scenarios include auditing profile option assignments, diagnosing why a user or responsibility receives a particular value, and reconciling configuration across environments.

• Audit assignments at user level: join LEVEL_VALUE to FND_USER where LEVEL_ID denotes the user level to list every profile option set for a specific user.
• Responsibility-level configuration: join LEVEL_VALUE to FND_RESPONSIBILITY and LEVEL_VALUE_APPLICATION_ID to FND_APPLICATION to report settings scoped to a responsibility.
• Profile option detail: join APPLICATION_ID and PROFILE_OPTION_ID to FND_PROFILE_OPTIONS to obtain the profile option name and description alongside assigned values.
• Site-level defaults: filter on the Site LEVEL_ID to review global defaults before responsibility or user overrides.

A representative query pattern selects APPLICATION_ID, PROFILE_OPTION_ID, LEVEL_ID, LEVEL_VALUE, LEVEL_VALUE_APPLICATION_ID, and PROFILE_OPTION_VALUE from FND_PROFILE_OPTION_VALUES, joined to FND_PROFILE_OPTIONS on the application and profile option identifiers to resolve the human-readable profile option name. Reporting solutions frequently extract the full table for configuration comparison between the 12.1.1 and 12.2.2 instances, since the ZD_EDITION_NAME column is meaningful only in 12.2.x editions.

Related Objects

The following objects are most significant in relation to FND_PROFILE_OPTION_VALUES:

• FND_PROFILE_OPTIONS — referenced through APPLICATION_ID and PROFILE_OPTION_ID; supplies the definition of each profile option.
• FND_USER — referenced through LEVEL_VALUE when the level is User, providing the user identity for user-level values.
• FND_RESPONSIBILITY — referenced through LEVEL_VALUE and LEVEL_VALUE_APPLICATION_ID for responsibility-level settings.
• FND_APPLICATION — referenced through LEVEL_VALUE, identifying the application associated with a level value.
• FND_PROFILE_OPTION_VALUES_U1 — the unique business-key index enforcing uniqueness across application, profile option, level, level values, and edition.

Together these relationships define how profile option values are scoped and resolved within the Oracle EBS Application Object Library.