Search Results csc_prof_groups_b




Overview
Explore in AI Chat

Overview

The CSC_PROF_GROUPS_B table is a core data object within the Oracle E-Business Suite Customer Care (CSC) module. Functioning as a base table, its primary role is to serve as the central repository for storing the master definitions of profile groups. In the context of Oracle EBS, a profile group is a logical container used to organize and manage a collection of related profile options or checks, which are essential for configuring application behavior and enforcing business rules within the Customer Care domain. This table is fundamental to the profile management infrastructure, providing the unique identifier and base attributes for each group, which are then referenced by numerous related entities across the module.

Key Information Stored

The table's structure is designed to hold the essential, non-translatable attributes of a profile group. While the provided ETRM metadata does not list individual columns, the documented primary key is the GROUP_ID column. This column is the unique numeric identifier (typically a sequence-generated value) for each profile group record and is the anchor for all related data. As a base table, it is standard practice for it to also contain standard Oracle EBS columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for auditing purposes. The translatable attributes of a profile group, such as its name and description, are stored in the associated translation table, CSC_PROF_GROUPS_TL.

Common Use Cases and Queries

This table is primarily accessed for administrative configuration and diagnostic reporting within the Customer Care module. Common use cases include auditing the list of configured profile groups, troubleshooting profile-related application behavior, and generating data for migration or upgrade scripts. A fundamental query involves joining the base table with its translation table to retrieve a complete, language-specific view of all profile groups:

  • SELECT b.GROUP_ID, tl.NAME, tl.DESCRIPTION FROM CSC_PROF_GROUPS_B b, CSC_PROF_GROUPS_TL tl WHERE b.GROUP_ID = tl.GROUP_ID AND tl.LANGUAGE = USERENV('LANG');

Another critical pattern is investigating the relationships a specific profile group has with other configuration entities, such as the categories or checks assigned to it, by joining with the documented foreign key tables.

Related Objects

The CSC_PROF_GROUPS_B table is a central hub in the profile management data model, with several key dependencies as documented by its foreign key relationships. The primary key (GROUP_ID) is referenced by the following tables:

  • CSC_PROF_GROUPS_TL: Stores the translated names and descriptions for each profile group. Joined on GROUP_ID.
  • CSC_PROF_GROUP_CATEGORIES: Links profile groups to categories, defining the organizational hierarchy of profile options. Joined on GROUP_ID.
  • CSC_PROF_GROUP_CHECKS: Associates specific validation or business rule checks with a profile group. Joined on GROUP_ID.
  • CSC_PROF_MODULE_GROUPS: Maps profile groups to specific application modules within Customer Care. Joined on GROUP_ID.

These relationships illustrate that the GROUP_ID from CSC_PROF_GROUPS_B is essential for navigating the complete configuration of any profile group within the system.

  • Table: CSC_PROF_GROUPS_B 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_GROUPS_B,  object_name:CSC_PROF_GROUPS_B,  status:VALID,  product: CSC - Customer Care ,  description: Base Table to Store profile Group information ,  implementation_dba_data: CSC.CSC_PROF_GROUPS_B , 

  • Table: CSC_PROF_GROUPS_B 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_GROUPS_B,  object_name:CSC_PROF_GROUPS_B,  status:VALID,  product: CSC - Customer Care ,  description: Base Table to Store profile Group information ,  implementation_dba_data: CSC.CSC_PROF_GROUPS_B , 

  • View: CSC_PROF_GROUPS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CSC.CSC_PROF_GROUPS_VL,  object_name:CSC_PROF_GROUPS_VL,  status:VALID,  product: CSC - Customer Care ,  description: This view is the MLSed view based on CSC_PROF_GROUPS_B and CSC_PROF_GROUPS_TL. This view is used in Customer Profile Setup form- Profile Groups tab and Dashboard Groups tabs. ,  implementation_dba_data: APPS.CSC_PROF_GROUPS_VL , 

  • View: CSC_PROF_GROUPS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CSC.CSC_PROF_GROUPS_VL,  object_name:CSC_PROF_GROUPS_VL,  status:VALID,  product: CSC - Customer Care ,  description: This view is the MLSed view based on CSC_PROF_GROUPS_B and CSC_PROF_GROUPS_TL. This view is used in Customer Profile Setup form- Profile Groups tab and Dashboard Groups tabs. ,  implementation_dba_data: APPS.CSC_PROF_GROUPS_VL , 

  • Table: CSC_PROF_GROUP_CATEGORIES 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_GROUP_CATEGORIES,  object_name:CSC_PROF_GROUP_CATEGORIES,  status:VALID,  product: CSC - Customer Care ,  description: Store the categories that are present in a profile group . Categories are needed only for Dashboard Groups ,  implementation_dba_data: CSC.CSC_PROF_GROUP_CATEGORIES , 

  • Table: CSC_PROF_GROUP_CHECKS 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_GROUP_CHECKS,  object_name:CSC_PROF_GROUP_CHECKS,  status:VALID,  product: CSC - Customer Care ,  description: Store the relation between profile groups and profile checks. This table stores the Profile checks that are present in a profile group ,  implementation_dba_data: CSC.CSC_PROF_GROUP_CHECKS , 

  • Table: CSC_PROF_MODULE_GROUPS 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_MODULE_GROUPS,  object_name:CSC_PROF_MODULE_GROUPS,  status:VALID,  product: CSC - Customer Care ,  description: Relation between a form function and Profile groups. This specifies the profile group , to be displayed in the profile window when it is displayed in a form . ,  implementation_dba_data: CSC.CSC_PROF_MODULE_GROUPS , 

  • Table: CSC_PROF_GROUPS_TL 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_GROUPS_TL,  object_name:CSC_PROF_GROUPS_TL,  status:VALID,  product: CSC - Customer Care ,  description: Translation Table to Store profile Group information ,  implementation_dba_data: CSC.CSC_PROF_GROUPS_TL , 

  • Table: CSC_PROF_GROUPS_TL 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_GROUPS_TL,  object_name:CSC_PROF_GROUPS_TL,  status:VALID,  product: CSC - Customer Care ,  description: Translation Table to Store profile Group information ,  implementation_dba_data: CSC.CSC_PROF_GROUPS_TL , 

  • Table: CSC_PROF_GROUP_CATEGORIES 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_GROUP_CATEGORIES,  object_name:CSC_PROF_GROUP_CATEGORIES,  status:VALID,  product: CSC - Customer Care ,  description: Store the categories that are present in a profile group . Categories are needed only for Dashboard Groups ,  implementation_dba_data: CSC.CSC_PROF_GROUP_CATEGORIES , 

  • Table: CSC_PROF_GROUP_CHECKS 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_GROUP_CHECKS,  object_name:CSC_PROF_GROUP_CHECKS,  status:VALID,  product: CSC - Customer Care ,  description: Store the relation between profile groups and profile checks. This table stores the Profile checks that are present in a profile group ,  implementation_dba_data: CSC.CSC_PROF_GROUP_CHECKS , 

  • Table: CSC_PROF_MODULE_GROUPS 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_MODULE_GROUPS,  object_name:CSC_PROF_MODULE_GROUPS,  status:VALID,  product: CSC - Customer Care ,  description: Relation between a form function and Profile groups. This specifies the profile group , to be displayed in the profile window when it is displayed in a form . ,  implementation_dba_data: CSC.CSC_PROF_MODULE_GROUPS ,