Search Results fnd_profile_cat_options




Overview
Explore in AI Chat

Overview

The FND_PROFILE_CAT_OPTIONS table is a core intersection table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the critical junction that defines the relationship between user profile options and the categories used to organize them within the application's user interface. This table is owned by the APPLSYS schema and is essential for the proper administration and hierarchical grouping of system and user-level profile settings. By linking profile options to categories, it enables the logical presentation of thousands of profile options in the "System Profile Values" form, allowing administrators to navigate and manage settings efficiently.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies each relationship. The key columns are CATEGORY_NAME, PROFILE_OPTION_APPLICATION_ID, PROFILE_OPTION_ID, and APPLICATION_ID. The CATEGORY_NAME, along with its corresponding APPLICATION_ID, references a specific profile category in the FND_PROFILE_CATS table. The PROFILE_OPTION_APPLICATION_ID and PROFILE_OPTION_ID together form a foreign key that references a specific profile option defined in the FND_PROFILE_OPTIONS table. This intersection model allows a single profile option to be associated with multiple categories and vice versa, providing flexibility in the administrative UI.

Common Use Cases and Queries

The primary use case is reporting and auditing which profile options are grouped under specific administrative categories. For instance, a developer or administrator may need to identify all profile options linked to a particular category for documentation or cleanup purposes. A common query involves joining to the related tables to get descriptive names:

  • Sample Query: To list all profile options within the 'GL' category, one would execute a SQL statement joining FND_PROFILE_CAT_OPTIONS to FND_PROFILE_OPTIONS and FND_PROFILE_CATS on their respective key columns. This reveals the underlying data structure that populates the profile hierarchy seen in the EBS front-end.
  • Administrative Insight: Understanding these relationships is crucial when customizing the profile UI or when troubleshooting why a specific profile option appears (or does not appear) in an expected category within the "System Profile Values" form.

Related Objects

FND_PROFILE_CAT_OPTIONS sits at the intersection of two fundamental profile metadata tables, as defined by its documented foreign key relationships:

  • FND_PROFILE_CATS: This table defines the profile categories themselves. FND_PROFILE_CAT_OPTIONS references it via the columns CATEGORY_NAME and APPLICATION_ID.
  • FND_PROFILE_OPTIONS: This table holds the definition of all profile options in the system. FND_PROFILE_CAT_OPTIONS references it via the composite foreign key of PROFILE_OPTION_APPLICATION_ID and PROFILE_OPTION_ID.

These relationships enforce referential integrity, ensuring that every entry in the intersection table corresponds to a valid category and a valid profile option. The primary key constraint FND_PROFILE_CAT_OPTIONS_PK prevents duplicate associations from being created.