Search Results csc_prof_module_groups




Overview
Explore in AI Chat

Overview

The CSC_PROF_MODULE_GROUPS table is a core configuration table within the Oracle E-Business Suite Customer Care (CSC) module. Its primary function is to establish a relationship between application form functions and profile groups. This mapping is critical for the user interface, as it determines which specific profile groups are displayed within the profile window when a user navigates to a particular form. By controlling this association, the table enables role-based or context-sensitive presentation of profile options, ensuring users see only the relevant configuration groups for their current task in the application.

Key Information Stored

The table's structure is designed to link two key entities: a form function and a profile group. The primary column is MODULE_GROUP_ID, which serves as the unique identifier for each mapping record. The FORM_FUNCTION_ID column holds a foreign key reference to FND_FORM_FUNCTIONS, identifying the specific application function or form. The GROUP_ID column holds a foreign key reference to CSC_PROF_GROUPS_B, identifying the profile group to be displayed. Together, these columns define which profile group is activated for a given form context.

Common Use Cases and Queries

A primary use case is troubleshooting or auditing the profile groups associated with specific forms. For instance, if a profile window is missing expected options on a particular form, an administrator would query this table to verify the mapping. A common diagnostic query would join to FND_FORM_FUNCTIONS and CSC_PROF_GROUPS_B to get descriptive names:

  • SELECT ff.USER_FUNCTION_NAME, pgb.GROUP_NAME FROM csc_prof_module_groups pmg, fnd_form_functions ff, csc_prof_groups_b pgb WHERE pmg.form_function_id = ff.function_id AND pmg.group_id = pgb.group_id;

Another scenario involves implementation, where customizations may require adding new profile group associations to forms. Data fixes or scripts would insert records into this table to establish the necessary links.

Related Objects

The CSC_PROF_MODULE_GROUPS table is centrally connected to two other key EBS objects via foreign key constraints, forming a critical part of the profile management data model.

  • CSC_PROF_GROUPS_B: This is the master table for profile groups. The foreign key from CSC_PROF_MODULE_GROUPS.GROUP_ID to CSC_PROF_GROUPS_B.GROUP_ID ensures that any group referenced in a module mapping is a valid, defined profile group.
  • FND_FORM_FUNCTIONS: This foundational Application Object Library table defines all form functions in EBS. The foreign key from CSC_PROF_MODULE_GROUPS.FORM_FUNCTION_ID to FND_FORM_FUNCTIONS.FUNCTION_ID ensures that mappings are only created for valid, registered application functions.