Search Results cs_incident_statuses_b

Overview

The CS_INCIDENT_STATUSES_B table is a core reference table within the Oracle E-Business Suite Service (CS) module, specifically for releases 12.1.1 and 12.2.2. It serves as the master repository for all defined Service Request (SR) or Incident status codes. This table stores the non-translated, seed data for statuses, such as 'Open', 'Closed', 'Pending Customer Input', or custom statuses defined during implementation. Its primary role is to provide a controlled list of valid statuses that can be assigned to a service request throughout its lifecycle, ensuring data integrity and enabling workflow and reporting logic based on status changes.

Key Information Stored

The table's structure centers on a unique status identifier and its classification. The primary key is the INCIDENT_STATUS_ID, a numeric sequence that uniquely identifies each status record. A significant column is INCIDENT_SUBTYPE, which is part of a unique key constraint (CS_INCIDENT_STATUSES_B_UK). This column typically categorizes the status, often distinguishing between standard statuses and those used for specific business processes or service request types. While the provided ETRM excerpt does not list all columns, standard practice indicates the table would also contain columns for controlling status behavior, such as flags indicating if a status is a closing status, an active status, or a system status, along with standard WHO columns (CREATION_DATE, CREATED_BY, etc.) for auditing.

Common Use Cases and Queries

This table is fundamental for reporting, data validation, and configuring service request workflows. Common use cases include generating reports on SR volumes by status, defining allowed status transitions in the CS_SR_STATUS_TRANSITIONS table, and validating status changes via application logic or custom code. A typical query to retrieve all active statuses for reporting might be:

SELECT status.INCIDENT_STATUS_ID, tl.NAME FROM CS_INCIDENT_STATUSES_B status, CS_INCIDENT_STATUSES_TL tl WHERE status.INCIDENT_STATUS_ID = tl.INCIDENT_STATUS_ID AND tl.LANGUAGE = USERENV('LANG');

Another common pattern is joining to the CS_INCIDENTS_ALL_B table to analyze the distribution of service requests:

SELECT status.INCIDENT_STATUS_ID, COUNT(inc.INCIDENT_ID) FROM CS_INCIDENT_STATUSES_B status, CS_INCIDENTS_ALL_B inc WHERE status.INCIDENT_STATUS_ID = inc.INCIDENT_STATUS_ID GROUP BY status.INCIDENT_STATUS_ID;

Related Objects

As evidenced by its extensive foreign key relationships, CS_INCIDENT_STATUSES_B is a central hub for status-related data. Key related objects include:

CS_INCIDENT_STATUSES_TL: The corresponding translated table that provides the language-specific name (NAME) for each INCIDENT_STATUS_ID.
CS_INCIDENTS_ALL_B: The main service request table, which references the current status of each incident.
CS_SR_STATUS_TRANSITIONS: Defines valid workflow paths by referencing statuses in both FROM_INCIDENT_STATUS_ID and TO_INCIDENT_STATUS_ID columns.
CS_SR_ALLOWED_STATUSES and CS_SR_STATUS_GROUPS_B: Control which statuses are available for specific SR types or groups.
CS_INCIDENT_CYCLE_STEPS, CS_SR_ACTION_DETAILS, CS_SR_ACTION_TRIGGERS: Utilize status IDs to configure automated actions and process steps within the service request lifecycle.

Table: CS_INCIDENT_STATUSES_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_STATUSES_B, object_name:CS_INCIDENT_STATUSES_B, status:VALID, product: CS - Service , description: This table contains non-translated information about Service Request statuses. , implementation_dba_data: CS.CS_INCIDENT_STATUSES_B ,
Table: CS_INCIDENT_STATUSES_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_STATUSES_B, object_name:CS_INCIDENT_STATUSES_B, status:VALID, product: CS - Service , description: This table contains non-translated information about Service Request statuses. , implementation_dba_data: CS.CS_INCIDENT_STATUSES_B ,
Table: CS_SR_STATUS_TRANSITIONS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_STATUS_TRANSITIONS, object_name:CS_SR_STATUS_TRANSITIONS, status:VALID, product: CS - Service , description: Stores information about the status transitions within allowable statuses associated with a status rule. , implementation_dba_data: CS.CS_SR_STATUS_TRANSITIONS ,
Table: CS_SR_STATUS_TRANSITIONS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_STATUS_TRANSITIONS, object_name:CS_SR_STATUS_TRANSITIONS, status:VALID, product: CS - Service , description: Stores information about the status transitions within allowable statuses associated with a status rule. , implementation_dba_data: CS.CS_SR_STATUS_TRANSITIONS ,
View: CS_INCIDENT_STATUSES_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_INCIDENT_STATUSES_VL, object_name:CS_INCIDENT_STATUSES_VL, status:VALID, product: CS - Service , description: Multi-lingual view for CS_INCIDENT_STATUSES_B and CS_INCIDENT_STATUSES_TL tables. , implementation_dba_data: APPS.CS_INCIDENT_STATUSES_VL ,
View: CS_INCIDENT_STATUSES_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_INCIDENT_STATUSES_VL, object_name:CS_INCIDENT_STATUSES_VL, status:VALID, product: CS - Service , description: Multi-lingual view for CS_INCIDENT_STATUSES_B and CS_INCIDENT_STATUSES_TL tables. , implementation_dba_data: APPS.CS_INCIDENT_STATUSES_VL ,
Table: CS_INCIDENT_CYCLE_STEPS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_CYCLE_STEPS, object_name:CS_INCIDENT_CYCLE_STEPS, status:VALID, product: CS - Service , description: This table stores information about related statuses. , implementation_dba_data: CS.CS_INCIDENT_CYCLE_STEPS ,
Table: CS_SR_ACTION_TRIGGERS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_ACTION_TRIGGERS, object_name:CS_SR_ACTION_TRIGGERS, status:VALID, product: CS - Service , description: This table contains event-condition details for all event rules. , implementation_dba_data: CS.CS_SR_ACTION_TRIGGERS ,
Table: CS_SR_STATUS_GROUPS_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_STATUS_GROUPS_B, object_name:CS_SR_STATUS_GROUPS_B, status:VALID, product: CS - Service , description: Stores non-translated Information about the status rules. , implementation_dba_data: CS.CS_SR_STATUS_GROUPS_B ,
Table: CS_INCIDENT_CYCLE_STEPS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_CYCLE_STEPS, object_name:CS_INCIDENT_CYCLE_STEPS, status:VALID, product: CS - Service , description: This table stores information about related statuses. , implementation_dba_data: CS.CS_INCIDENT_CYCLE_STEPS ,
Table: CS_SR_ALLOWED_STATUSES 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_ALLOWED_STATUSES, object_name:CS_SR_ALLOWED_STATUSES, status:VALID, product: CS - Service , description: Stores information about the allowable statutes for a status rule. , implementation_dba_data: CS.CS_SR_ALLOWED_STATUSES ,
Table: CS_SR_ACTION_DETAILS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_ACTION_DETAILS, object_name:CS_SR_ACTION_DETAILS, status:VALID, product: CS - Service , description: Table contains action details associated to all event rules. , implementation_dba_data: CS.CS_SR_ACTION_DETAILS ,
Table: CS_SR_ACTION_DETAILS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_ACTION_DETAILS, object_name:CS_SR_ACTION_DETAILS, status:VALID, product: CS - Service , description: Table contains action details associated to all event rules. , implementation_dba_data: CS.CS_SR_ACTION_DETAILS ,
Table: CS_SR_ACTION_TRIGGERS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_ACTION_TRIGGERS, object_name:CS_SR_ACTION_TRIGGERS, status:VALID, product: CS - Service , description: This table contains event-condition details for all event rules. , implementation_dba_data: CS.CS_SR_ACTION_TRIGGERS ,
Table: CS_INCIDENT_STATUSES_TL 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_STATUSES_TL, object_name:CS_INCIDENT_STATUSES_TL, status:VALID, product: CS - Service , description: This table contains translated information about Service Request statuses. , implementation_dba_data: CS.CS_INCIDENT_STATUSES_TL ,
Table: CS_SR_ALLOWED_STATUSES 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_ALLOWED_STATUSES, object_name:CS_SR_ALLOWED_STATUSES, status:VALID, product: CS - Service , description: Stores information about the allowable statutes for a status rule. , implementation_dba_data: CS.CS_SR_ALLOWED_STATUSES ,
Table: CS_INCIDENT_STATUSES_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_STATUSES_TL, object_name:CS_INCIDENT_STATUSES_TL, status:VALID, product: CS - Service , description: This table contains translated information about Service Request statuses. , implementation_dba_data: CS.CS_INCIDENT_STATUSES_TL ,
Table: CS_SR_STATUS_GROUPS_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_STATUS_GROUPS_B, object_name:CS_SR_STATUS_GROUPS_B, status:VALID, product: CS - Service , description: Stores non-translated Information about the status rules. , implementation_dba_data: CS.CS_SR_STATUS_GROUPS_B ,
Table: CS_INCIDENTS_ALL_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_ALL_B, object_name:CS_INCIDENTS_ALL_B, status:VALID, product: CS - Service , description: This table stores non-translated information about service requests. , implementation_dba_data: CS.CS_INCIDENTS_ALL_B ,
Table: CS_INCIDENTS_ALL_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_ALL_B, object_name:CS_INCIDENTS_ALL_B, status:VALID, product: CS - Service , description: This table stores non-translated information about service requests. , implementation_dba_data: CS.CS_INCIDENTS_ALL_B ,
View: CS_SR_UWQ_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_V, object_name:CS_SR_UWQ_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_V ,
View: CS_SR_UWQ_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_V, object_name:CS_SR_UWQ_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_V ,
View: CS_SR_UWQ_UNOWNED_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_UNOWNED_V, object_name:CS_SR_UWQ_UNOWNED_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests that are not owned. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_UNOWNED_V ,
View: CS_SR_UWQ_UNOWNED_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_UNOWNED_V, object_name:CS_SR_UWQ_UNOWNED_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests that are not owned. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_UNOWNED_V ,
View: CS_SR_UWQ_TEAM_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_TEAM_V, object_name:CS_SR_UWQ_TEAM_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_TEAM_V ,
View: CS_SR_UWQ_TEAM_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_TEAM_V, object_name:CS_SR_UWQ_TEAM_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_TEAM_V ,
View: CS_SR_UWQ_EMPLOYEE_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_EMPLOYEE_V, object_name:CS_SR_UWQ_EMPLOYEE_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_EMPLOYEE_V ,
View: CS_SR_UWQ_EMPLOYEE_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_EMPLOYEE_V, object_name:CS_SR_UWQ_EMPLOYEE_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_EMPLOYEE_V ,
View: CS_SR_UWQ_GROUP_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_GROUP_V, object_name:CS_SR_UWQ_GROUP_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_GROUP_V ,
View: CS_SR_UWQ_GROUP_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_GROUP_V, object_name:CS_SR_UWQ_GROUP_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_GROUP_V ,