Search Results fnd_profile_options

Overview

The FND_PROFILE_OPTIONS table is a core Application Object Library (FND) table that serves as the master definition repository for all user profile options within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. A profile option is a configurable system setting that controls application behavior, security, and user personalization across the entire suite. This table defines the metadata for each option, such as its name, associated application, and internal identifiers, establishing the framework that allows administrators to set values at the site, application, responsibility, and user levels. It is a foundational component of the EBS personalization and configuration architecture.

Key Information Stored

The table's structure centers on uniquely identifying and categorizing each profile option. Key columns include PROFILE_OPTION_ID, a numeric primary key for internal relationships; PROFILE_OPTION_NAME, the unique internal name used by the system and APIs (e.g., 'MFG_ORGANIZATION_ID'); and APPLICATION_ID, which links the option to its owning product module via the FND_APPLICATION table. The table's dual primary keys (FND_PROFILE_OPTIONS_PK on APPLICATION_ID and PROFILE_OPTION_ID, and FND_PROFILE_OPTIONS_UK2 on PROFILE_OPTION_NAME) enforce critical data integrity, ensuring options are uniquely identifiable both within an application and across the entire system.

Common Use Cases and Queries

This table is primarily queried for system analysis, troubleshooting, and development. Common scenarios include identifying available profile options for a specific module, tracing the definition of an option causing unexpected behavior, or generating a master list of options for documentation. A typical query retrieves the internal name and ID for options related to a specific application:

• SELECT PROFILE_OPTION_NAME, PROFILE_OPTION_ID FROM APPLSYS.FND_PROFILE_OPTIONS WHERE APPLICATION_ID = 401 ORDER BY 1;

Another frequent pattern joins with the FND_PROFILE_OPTION_VALUES table to audit current settings against their definitions:

• SELECT def.PROFILE_OPTION_NAME, val.LEVEL_ID, val.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTIONS def, FND_PROFILE_OPTION_VALUES val WHERE def.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID AND def.APPLICATION_ID = val.APPLICATION_ID AND def.PROFILE_OPTION_NAME = 'CONC_REQUEST_GROUP_NAME';

Related Objects

As indicated by the foreign key metadata, FND_PROFILE_OPTIONS is central to the profile option ecosystem. The FND_PROFILE_OPTION_VALUES table stores the actual configured values for each defined option. The FND_PROFILE_OPTIONS_TL table holds translated user-facing names and descriptions for multilingual deployments. The FND_PROFILE_CAT_OPTIONS table manages the categorization of options for display in the profile hierarchy within the EBS front-end. Crucially, the table is linked to FND_APPLICATION, which provides the product context. Administrators typically interact with these definitions via the "System Profile Options" form or the FND_PROFILE public APIs, rather than through direct SQL manipulation.