Search Results cs_incidents_all_b

The CS_INCIDENTS_ALL_B table is a fundamental entity within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, serving as the primary repository for incident management data in the Oracle Service Contracts and Oracle TeleService modules. This table stores the core transactional records for service requests, incidents, and cases, enabling organizations to track, manage, and resolve customer issues efficiently. Below is a detailed breakdown of its structure, functionality, and integration within Oracle EBS.

Table Structure and Key Columns

The CS_INCIDENTS_ALL_B table is designed with a comprehensive set of columns to capture incident-related attributes. Key columns include:

INCIDENT_ID: The primary key, uniquely identifying each incident record.
INCIDENT_NUMBER: A user-friendly identifier for the incident, often auto-generated.
INCIDENT_TYPE_ID: Classifies the incident (e.g., service request, complaint).
STATUS_ID: Reflects the current lifecycle stage (e.g., Open, In Progress, Closed).
CUSTOMER_ID: Links to the HZ_PARTIES table to associate the incident with a customer.
CREATION_DATE and LAST_UPDATE_DATE: Track audit timestamps.
SEVERITY_ID and URGENCY_ID: Define the priority of the incident.
CONTRACT_ID: References the OKC_K_HEADERS_B table for service contract associations.

Functionality and Business Process Integration

The table plays a pivotal role in Oracle EBS's service management workflows. When a customer raises a service request, the system creates a record in CS_INCIDENTS_ALL_B, which triggers downstream processes such as assignment, resolution, and contract validation. Integration with modules like Oracle Inventory (MTL_SYSTEM_ITEMS_B) and Oracle Order Management (OE_ORDER_HEADERS_ALL) ensures seamless tracking of products and orders tied to incidents. Additionally, the table supports SLA (Service Level Agreement) management by storing metrics like response and resolution times.

Technical Considerations

As a multi-org enabled table, CS_INCIDENTS_ALL_B includes the ORG_ID column to partition data by operating unit, ensuring data security and compliance. Indexes on columns like INCIDENT_ID, CUSTOMER_ID, and CONTRACT_ID optimize query performance for high-volume transactional environments. The table also integrates with Oracle Workflow for automated routing and approvals, leveraging the WF_ITEM_TYPE and WF_ITEM_KEY columns.

Customization and Extensibility

Oracle EBS allows extensions to CS_INCIDENTS_ALL_B through descriptive flexfields (DFFs) and custom columns, enabling organizations to tailor the table to industry-specific requirements. For example, healthcare providers might add fields for patient IDs, while manufacturing firms could include equipment serial numbers. However, direct modifications to the table schema are discouraged; instead, Oracle recommends using APIs or the Oracle Application Framework for custom logic.

Conclusion

In summary, CS_INCIDENTS_ALL_B is a critical component of Oracle EBS's service management architecture, providing a robust foundation for incident tracking, customer support, and contract enforcement. Its design ensures scalability, flexibility, and integration with other EBS modules, making it indispensable for organizations leveraging Oracle's service-oriented applications.

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_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_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_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_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 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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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 ,
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 ,