Search Results cs_incidents_all_b

Overview

The CS_INCIDENTS_ALL_B table is a core transactional entity within the Oracle E-Business Suite (EBS) Service (CS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the primary repository for non-translated, master information related to service requests (also referred to as incidents). As a multi-organization enabled table, denoted by the "_ALL_" suffix, it stores data across operating units, making it the central table for all service request creation, tracking, and management. Its role is fundamental to the Service module's functionality, linking service requests to customers, inventory items, systems, and the broader trading community architecture.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which reveal the critical data points it holds. The primary identifier is the system-generated INCIDENT_ID, while the user-facing, unique key is the INCIDENT_NUMBER. Essential stored information includes customer and site details via foreign keys to the HZ (Trading Community) schema, such as BILL_TO_PARTY_ID, SHIP_TO_SITE_ID, and INSTALL_SITE_ID. It links to the item categorization structure (CATEGORY_ID, CATEGORY_SET_ID) and tracks the service request's current state via INCIDENT_STATUS_ID. Other pivotal columns include OWNING_DEPARTMENT_ID for assignment, SYSTEM_ID for linked configurations, and contact point IDs (CUSTOMER_EMAIL_ID, PRIMARY_CONTACT_ID) for communication.

Common Use Cases and Queries

This table is central to operational reporting, data extracts, and custom integrations. Common use cases include generating open service request lists, analyzing incident volume by customer or product category, and building data feeds for external CRM systems. A typical query to retrieve basic incident details with customer information would join to Trading Community tables.

Sample Query Pattern:
SELECT inc.incident_number,
inc.creation_date,
sts.name status,
party.party_name
FROM cs_incidents_all_b inc,
cs_incident_statuses_b sts,
hz_parties party
WHERE inc.incident_status_id = sts.incident_status_id
AND inc.bill_to_party_id = party.party_id
AND inc.owning_department_id = :dept_id
AND TRUNC(inc.creation_date) >= :start_date;
Data fixes or updates often target the INCIDENT_STATUS_ID or OWNING_DEPARTMENT_ID columns, but must be performed with caution and typically through official APIs.

Related Objects

CS_INCIDENTS_ALL_B is the hub of a complex data model. Its primary transactional counterpart is CS_INCIDENTS_ALL_TL, which stores the translated descriptions and summaries. Key foreign key dependencies, as documented, include:

HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_PARTY_SITES: For customer and site information.
CS_INCIDENT_STATUSES_B: For valid status values.
CSI_SYSTEMS_B: For linked installed base items.
MTL_CATEGORIES_B: For item categorization.
BOM_DEPARTMENTS: For the owning service department.

For programmatic access and data integrity, the standard Oracle Service Request APIs (e.g., CS_ServiceRequest_PUB) should be used instead of direct DML on this table.

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 ,
Table: CS_CP_REVISIONS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_CP_REVISIONS, object_name:CS_CP_REVISIONS, status:VALID, product: CS - Service , description: Revision information about products in the installed base , implementation_dba_data: CS.CS_CP_REVISIONS ,
Table: CS_CP_REVISIONS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_CP_REVISIONS, object_name:CS_CP_REVISIONS, status:VALID, product: CS - Service , description: Revision information about products in the installed base , implementation_dba_data: CS.CS_CP_REVISIONS ,
Table: CS_HZ_SR_CONTACT_POINTS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_HZ_SR_CONTACT_POINTS, object_name:CS_HZ_SR_CONTACT_POINTS, status:VALID, product: CS - Service , description: This table stores contact points for a service requests. , implementation_dba_data: CS.CS_HZ_SR_CONTACT_POINTS ,
Table: CS_INCIDENT_LINKS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_LINKS, object_name:CS_INCIDENT_LINKS, status:VALID, product: CS - Service , description: Service Request can be linked to another Service Request or to any other object defined in JTF Objects. This link information is stored in this table. , implementation_dba_data: CS.CS_INCIDENT_LINKS ,
Table: CS_HZ_SR_CONTACT_POINTS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_HZ_SR_CONTACT_POINTS, object_name:CS_HZ_SR_CONTACT_POINTS, status:VALID, product: CS - Service , description: This table stores contact points for a service requests. , implementation_dba_data: CS.CS_HZ_SR_CONTACT_POINTS ,
Table: CS_INCIDENT_LINKS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_LINKS, object_name:CS_INCIDENT_LINKS, status:VALID, product: CS - Service , description: Service Request can be linked to another Service Request or to any other object defined in JTF Objects. This link information is stored in this table. , implementation_dba_data: CS.CS_INCIDENT_LINKS ,
Table: CS_CUSTOMER_PRODUCTS_ALL 12.1.1
product: CS - Service , description: The Customer installed base Products information. , implementation_dba_data: Not implemented in this database ,
View: CS_SR_ALL_NOTES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_ALL_NOTES_V, object_name:CS_SR_ALL_NOTES_V, status:VALID, product: CS - Service , description: This is the base view in the notes section of the workbench tab for Contract notes. , implementation_dba_data: APPS.CS_SR_ALL_NOTES_V ,
View: CS_SR_ALL_NOTES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_ALL_NOTES_V, object_name:CS_SR_ALL_NOTES_V, status:VALID, product: CS - Service , description: This is the base view in the notes section of the workbench tab for Contract notes. , implementation_dba_data: APPS.CS_SR_ALL_NOTES_V ,
Table: CS_CUSTOMER_PRODUCTS_ALL 12.2.2
product: CS - Service , description: The Customer installed base Products information. , implementation_dba_data: Not implemented in this database ,
Table: CS_SYSTEM_SR_LINKS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SYSTEM_SR_LINKS, object_name:CS_SYSTEM_SR_LINKS, status:VALID, product: CS - Service , implementation_dba_data: CS.CS_SYSTEM_SR_LINKS ,
Table: CS_SYSTEM_SR_LINKS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SYSTEM_SR_LINKS, object_name:CS_SYSTEM_SR_LINKS, status:VALID, product: CS - Service , implementation_dba_data: CS.CS_SYSTEM_SR_LINKS ,
Table: CS_INCIDENT_URGENCIES_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_URGENCIES_B, object_name:CS_INCIDENT_URGENCIES_B, status:VALID, product: CS - Service , description: This table contains non-translated information about Service Request urgencies. , implementation_dba_data: CS.CS_INCIDENT_URGENCIES_B ,
Table: CS_SR_PREFERRED_LANG 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_PREFERRED_LANG, object_name:CS_SR_PREFERRED_LANG, status:VALID, product: CS - Service , description: This table holds all the preferred languages. , implementation_dba_data: CS.CS_SR_PREFERRED_LANG ,
Table: CS_INCIDENTS_EXT 12.1.1
product: CS - Service , description: Table to store Service Request Extensible Attribute records. , implementation_dba_data: Not implemented in this database ,
Table: CS_INCIDENT_SEVERITIES_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_SEVERITIES_B, object_name:CS_INCIDENT_SEVERITIES_B, status:VALID, product: CS - Service , description: This table contains non-translated information about Service Request severities. , implementation_dba_data: CS.CS_INCIDENT_SEVERITIES_B ,
Table: CS_INCIDENTS_EXT_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_EXT_B, object_name:CS_INCIDENTS_EXT_B, status:VALID, product: CS - Service , description: Table to store Service Request Extensible Attribute records. , implementation_dba_data: CS.CS_INCIDENTS_EXT_B ,
Table: CS_SR_CONTACTS_EXT_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_CONTACTS_EXT_B, object_name:CS_SR_CONTACTS_EXT_B, status:VALID, product: CS - Service , description: Table to store Party Role Extensible Attribute records. , implementation_dba_data: CS.CS_SR_CONTACTS_EXT_B ,
Table: CS_INCIDENTS_AUDIT_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_AUDIT_B, object_name:CS_INCIDENTS_AUDIT_B, status:VALID, product: CS - Service , description: This table stores non-translated audit information for service requests. , implementation_dba_data: CS.CS_INCIDENTS_AUDIT_B ,
Table: CS_INCIDENTS_AUDIT_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_AUDIT_B, object_name:CS_INCIDENTS_AUDIT_B, status:VALID, product: CS - Service , description: This table stores non-translated audit information for service requests. , implementation_dba_data: CS.CS_INCIDENTS_AUDIT_B ,
Table: CS_SR_PREFERRED_LANG 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_PREFERRED_LANG, object_name:CS_SR_PREFERRED_LANG, status:VALID, product: CS - Service , description: This table holds all the preferred languages. , implementation_dba_data: CS.CS_SR_PREFERRED_LANG ,
Table: CS_MESSAGES 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_MESSAGES, object_name:CS_MESSAGES, status:VALID, product: CS - Service , description: This table stores information about the messages sent from service requests and other documents. , implementation_dba_data: CS.CS_MESSAGES ,
Table: CS_WEB_CONFERENCES 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_WEB_CONFERENCES, object_name:CS_WEB_CONFERENCES, status:VALID, product: CS - Service , description: Table to store web conference details for an SR. , implementation_dba_data: CS.CS_WEB_CONFERENCES ,
Table: CS_WEB_CONFERENCES 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_WEB_CONFERENCES, object_name:CS_WEB_CONFERENCES, status:VALID, product: CS - Service , description: Table to store web conference details for an SR. , implementation_dba_data: CS.CS_WEB_CONFERENCES ,
Table: CS_INCIDENTS_EXT_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_EXT_B, object_name:CS_INCIDENTS_EXT_B, status:VALID, product: CS - Service , description: Table to store Service Request Extensible Attribute records. , implementation_dba_data: CS.CS_INCIDENTS_EXT_B ,
Table: CS_INCIDENT_SEVERITIES_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_SEVERITIES_B, object_name:CS_INCIDENT_SEVERITIES_B, status:VALID, product: CS - Service , description: This table contains non-translated information about Service Request severities. , implementation_dba_data: CS.CS_INCIDENT_SEVERITIES_B ,
Table: CS_SR_CONTACTS_EXT 12.1.1
product: CS - Service , description: Table to store Party Role Extensible Attribute records. , implementation_dba_data: Not implemented in this database ,
Table: CS_SR_CONTACTS_EXT_AUDIT 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_CONTACTS_EXT_AUDIT, object_name:CS_SR_CONTACTS_EXT_AUDIT, status:VALID, product: CS - Service , description: This is an audit table and will track all changes made to the party role contacts extensible attributes. , implementation_dba_data: CS.CS_SR_CONTACTS_EXT_AUDIT ,
Table: CS_INCIDENTS_EXT_AUDIT 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_EXT_AUDIT, object_name:CS_INCIDENTS_EXT_AUDIT, status:VALID, product: CS - Service , description: This is an audit table and will track all changes made to the service request extensible attributes. , implementation_dba_data: CS.CS_INCIDENTS_EXT_AUDIT ,
Table: CS_INCIDENTS_EXT_AUDIT 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_EXT_AUDIT, object_name:CS_INCIDENTS_EXT_AUDIT, status:VALID, product: CS - Service , description: This is an audit table and will track all changes made to the service request extensible attributes. , implementation_dba_data: CS.CS_INCIDENTS_EXT_AUDIT ,
Table: CS_INCIDENTS_PURGE_AUDIT_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_PURGE_AUDIT_TL, object_name:CS_INCIDENTS_PURGE_AUDIT_TL, status:VALID, product: CS - Service , description: This table contains the translatable attributes of a service request that was purged. , implementation_dba_data: CS.CS_INCIDENTS_PURGE_AUDIT_TL ,
Table: CS_INCIDENTS_PURGE_AUDIT_TL 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_PURGE_AUDIT_TL, object_name:CS_INCIDENTS_PURGE_AUDIT_TL, status:VALID, product: CS - Service , description: This table contains the translatable attributes of a service request that was purged. , implementation_dba_data: CS.CS_INCIDENTS_PURGE_AUDIT_TL ,
Table: CS_INCIDENTS_PURGE_AUDIT_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_PURGE_AUDIT_B, object_name:CS_INCIDENTS_PURGE_AUDIT_B, status:VALID, product: CS - Service , description: This table contains audit information generated by the Service Request Data Purge concurrent program. , implementation_dba_data: CS.CS_INCIDENTS_PURGE_AUDIT_B ,
Table: CS_SR_CONTACTS_EXT_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_CONTACTS_EXT_B, object_name:CS_SR_CONTACTS_EXT_B, status:VALID, product: CS - Service , description: Table to store Party Role Extensible Attribute records. , implementation_dba_data: CS.CS_SR_CONTACTS_EXT_B ,
Table: CS_INCIDENT_URGENCIES_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_URGENCIES_B, object_name:CS_INCIDENT_URGENCIES_B, status:VALID, product: CS - Service , description: This table contains non-translated information about Service Request urgencies. , implementation_dba_data: CS.CS_INCIDENT_URGENCIES_B ,
Table: CS_MESSAGES 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_MESSAGES, object_name:CS_MESSAGES, status:VALID, product: CS - Service , description: This table stores information about the messages sent from service requests and other documents. , implementation_dba_data: CS.CS_MESSAGES ,
Table: CS_INCIDENTS_EXT 12.2.2
product: CS - Service , description: Table to store Service Request Extensible Attribute records. , implementation_dba_data: Not implemented in this database ,
Table: CS_SR_CONTACTS_EXT 12.2.2
product: CS - Service , description: Table to store Party Role Extensible Attribute records. , implementation_dba_data: Not implemented in this database ,
Table: CS_INCIDENTS_PURGE_STAGING 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_PURGE_STAGING, object_name:CS_INCIDENTS_PURGE_STAGING, status:VALID, product: CS - Service , description: This table is used as a staging table that would store all the SRs that need to be purged for a set of parameters. , implementation_dba_data: CS.CS_INCIDENTS_PURGE_STAGING ,
Table: CS_SR_CONTACTS_EXT_AUDIT 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_CONTACTS_EXT_AUDIT, object_name:CS_SR_CONTACTS_EXT_AUDIT, status:VALID, product: CS - Service , description: This is an audit table and will track all changes made to the party role contacts extensible attributes. , implementation_dba_data: CS.CS_SR_CONTACTS_EXT_AUDIT ,
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_INCIDENT_LINKS_EXT 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_LINKS_EXT, object_name:CS_INCIDENT_LINKS_EXT, status:VALID, product: CS - Service , description: From Release 11.5.9, this table WILL NOT BE USED. All links, irrespective of whether they are SR to SR links or SR to an external object links, will be stored in CS_INCIDENT_LINKS table. , implementation_dba_data: CS.CS_INCIDENT_LINKS_EXT ,
Table: CS_INCIDENTS_PURGE_STAGING 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_PURGE_STAGING, object_name:CS_INCIDENTS_PURGE_STAGING, status:VALID, product: CS - Service , description: This table is used as a staging table that would store all the SRs that need to be purged for a set of parameters. , implementation_dba_data: CS.CS_INCIDENTS_PURGE_STAGING ,
Table: CS_INCIDENTS_PURGE_AUDIT_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_PURGE_AUDIT_B, object_name:CS_INCIDENTS_PURGE_AUDIT_B, status:VALID, product: CS - Service , description: This table contains audit information generated by the Service Request Data Purge concurrent program. , implementation_dba_data: CS.CS_INCIDENTS_PURGE_AUDIT_B ,
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_LINKS_EXT 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_LINKS_EXT, object_name:CS_INCIDENT_LINKS_EXT, status:VALID, product: CS - Service , description: From Release 11.5.9, this table WILL NOT BE USED. All links, irrespective of whether they are SR to SR links or SR to an external object links, will be stored in CS_INCIDENT_LINKS table. , implementation_dba_data: CS.CS_INCIDENT_LINKS_EXT ,
Table: CS_ESTIMATE_DETAILS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_ESTIMATE_DETAILS, object_name:CS_ESTIMATE_DETAILS, status:VALID, product: CS - Service , description: Transaction table that stores details of Charge lines in Service , implementation_dba_data: CS.CS_ESTIMATE_DETAILS ,
Table: CS_INCIDENT_TYPES_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENT_TYPES_B, object_name:CS_INCIDENT_TYPES_B, status:VALID, product: CS - Service , description: This table contains non-translated information about Service Request type codes. , implementation_dba_data: CS.CS_INCIDENT_TYPES_B ,