Search Results cs_sr_status_groups_b




Overview
Explore in AI Chat

Overview

The CS_SR_STATUS_GROUPS_B table is a core configuration object within the Oracle E-Business Suite (EBS) Service (CS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for defining status rule groups, which are foundational to the incident management lifecycle. These groups govern the set of valid statuses and the permissible transitions between them for service requests (incidents). By centralizing this non-translated, or base, information, the table enables the enforcement of structured, controlled workflows for service request status updates, ensuring data integrity and consistent process adherence across the application.

Key Information Stored

As a base table, CS_SR_STATUS_GROUPS_B stores the fundamental, language-independent attributes for each status group. The primary column is the system-generated STATUS_GROUP_ID, which serves as the unique identifier. A critical functional column is DEFAULT_INCIDENT_STATUS_ID, which references a specific status in the CS_INCIDENT_STATUSES_B table. This defines the default starting status for any service request assigned to this status group. While the provided metadata does not list all columns, typical attributes would also include a NAME or GROUP_CODE for internal identification, creation dates, and who created the record (CREATED_BY, CREATION_DATE).

Common Use Cases and Queries

This table is primarily accessed for configuration, reporting, and integration. Administrators query it to review or audit the defined status groups and their default settings. A common reporting need is to list all configured status groups alongside their default status. The following sample query illustrates this join:

Another critical use case is determining the valid statuses for a given service request type, which requires joining through the CS_INCIDENT_TYPES_B table. This table is also central to any data migration or custom interface that needs to populate or reference status group identifiers.

Related Objects

CS_SR_STATUS_GROUPS_B is a pivotal entity with several documented foreign key relationships, as per the provided metadata. It is the parent table for the translated descriptions in CS_SR_STATUS_GROUPS_TL, joined on STATUS_GROUP_ID. It defines the group for allowed statuses (CS_SR_ALLOWED_STATUSES.STATUS_GROUP_ID) and status transition rules (CS_SR_STATUS_TRANSITIONS.STATUS_GROUP_ID). Crucially, it is referenced by the CS_INCIDENT_TYPES_B.STATUS_GROUP_ID column, linking each incident type to a specific status workflow. Finally, it holds a foreign key reference to CS_INCIDENT_STATUSES_B via its DEFAULT_INCIDENT_STATUS_ID column to establish the initial status.