Search Results cs_incident_severities_tl




Overview
Explore in AI Chat

Overview

The CS_INCIDENT_SEVERITIES_TL table is a core translation table within the Oracle E-Business Suite Service (CS) module for versions 12.1.1 and 12.2.2. It stores the language-specific, user-facing descriptions for Service Request (incident) severity codes. This table enables the multilingual display of severity values, such as "Critical," "High," "Medium," and "Low," within the application's user interface based on the session language. Its primary role is to support the global deployment of Oracle Service by separating translatable text from the base severity definitions, allowing a single severity code to be presented appropriately across different linguistic territories.

Key Information Stored

The table's structure is designed for the standard Oracle E-Business Suite multilingual model. The primary key is a composite of INCIDENT_SEVERITY_ID and LANGUAGE, ensuring a unique entry for each severity in each language. Key columns include:

  • INCIDENT_SEVERITY_ID: Foreign key linking to the base severity definition (e.g., in CS_INCIDENT_SEVERITIES_B).
  • LANGUAGE: The ISO language code (e.g., 'US', 'FR', 'DE') for the translation.
  • SOURCE_LANG: Indicates the original language in which the data was entered.
  • NAME: The translated name of the severity (e.g., "Critique" in French).
  • DESCRIPTION: A translated description providing further detail about the severity level.

Standard audit columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY are also present to track data changes.

Common Use Cases and Queries

This table is primarily accessed by the application runtime to display severity names. Common technical and reporting use cases include generating translated lists for reports or data extracts, and validating setup data. A typical query to retrieve all severity translations would join to the base table:

  • Sample SQL: SELECT b.SEVERITY_CODE, tl.NAME, tl.LANGUAGE FROM CS_INCIDENT_SEVERITIES_B b, CS_INCIDENT_SEVERITIES_TL tl WHERE b.INCIDENT_SEVERITY_ID = tl.INCIDENT_SEVERITY_ID AND tl.LANGUAGE = userenv('LANG');

For data migration or setup scripts, it is critical to populate this table for each installed language to ensure proper UI functionality. Administrators may query it to audit which severities have been translated into which languages.

Related Objects

CS_INCIDENT_SEVERITIES_TL has direct relationships with several key Service module objects. The most critical is the base table CS_INCIDENT_SEVERITIES_B, which holds the non-translatable attributes (like SEVERITY_CODE, ACTIVE_FLAG). The primary key INCIDENT_SEVERITY_ID is a foreign key to this base table. The table is also referenced by the Service Request entity tables, such as CS_INCIDENTS_ALL_B, where the INCIDENT_SEVERITY_ID column stores the severity assigned to a specific service request. Furthermore, standard Oracle APIs and views that handle translated data, such as FND_LOOKUP_VALUES for flexfield value sets, may follow a similar architectural pattern but are not direct dependencies.

  • Table: CS_INCIDENT_SEVERITIES_TL 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_INCIDENT_SEVERITIES_TL,  object_name:CS_INCIDENT_SEVERITIES_TL,  status:VALID,  product: CS - Service ,  description: This table contains translated information about Service Request severities. ,  implementation_dba_data: CS.CS_INCIDENT_SEVERITIES_TL , 

  • Table: CS_INCIDENT_SEVERITIES_TL 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_INCIDENT_SEVERITIES_TL,  object_name:CS_INCIDENT_SEVERITIES_TL,  status:VALID,  product: CS - Service ,  description: This table contains translated information about Service Request severities. ,  implementation_dba_data: CS.CS_INCIDENT_SEVERITIES_TL , 

  • View: CS_INCIDENT_SEVERITIES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENT_SEVERITIES_VL,  object_name:CS_INCIDENT_SEVERITIES_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_INCIDENT_SEVERITIES_B and CS_INCIDENT_SEVERITIES_TL tables. ,  implementation_dba_data: APPS.CS_INCIDENT_SEVERITIES_VL , 

  • View: CS_INCIDENT_SEVERITIES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENT_SEVERITIES_VL,  object_name:CS_INCIDENT_SEVERITIES_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_INCIDENT_SEVERITIES_B and CS_INCIDENT_SEVERITIES_TL tables. ,  implementation_dba_data: APPS.CS_INCIDENT_SEVERITIES_VL , 

  • View: CS_BRM_3D_SERVICE_REQUEST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_BRM_3D_SERVICE_REQUEST_V,  object_name:CS_BRM_3D_SERVICE_REQUEST_V,  status:VALID,  product: CS - Service ,  description: 3D Service Request View used by the Business Rule Monitor. ,  implementation_dba_data: APPS.CS_BRM_3D_SERVICE_REQUEST_V , 

  • View: CS_BRM_3D_SERVICE_REQUEST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_BRM_3D_SERVICE_REQUEST_V,  object_name:CS_BRM_3D_SERVICE_REQUEST_V,  status:VALID,  product: CS - Service ,  description: 3D Service Request View used by the Business Rule Monitor. ,  implementation_dba_data: APPS.CS_BRM_3D_SERVICE_REQUEST_V , 

  • View: CS_INCIDENT_LINKS_FROM_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENT_LINKS_FROM_V,  object_name:CS_INCIDENT_LINKS_FROM_V,  status:VALID,  product: CS - Service ,  description: Show all Service Requests that are linked from another service request to this Service request. ,  implementation_dba_data: APPS.CS_INCIDENT_LINKS_FROM_V , 

  • View: CS_SR_REPORT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_REPORT_V,  object_name:CS_SR_REPORT_V,  status:VALID,  product: CS - Service ,  description: This view is used in Service Request Summary/Detail report. ,  implementation_dba_data: APPS.CS_SR_REPORT_V , 

  • View: CS_INCIDENT_LINKS_FROM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENT_LINKS_FROM_V,  object_name:CS_INCIDENT_LINKS_FROM_V,  status:VALID,  product: CS - Service ,  description: Show all Service Requests that are linked from another service request to this Service request. ,  implementation_dba_data: APPS.CS_INCIDENT_LINKS_FROM_V , 

  • View: CS_SR_REPORT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_REPORT_V,  object_name:CS_SR_REPORT_V,  status:VALID,  product: CS - Service ,  description: This view is used in Service Request Summary/Detail report. ,  implementation_dba_data: APPS.CS_SR_REPORT_V , 

  • View: CS_SERVICE_REQUEST_PUB_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SERVICE_REQUEST_PUB_V,  object_name:CS_SERVICE_REQUEST_PUB_V,  status:VALID,  product: CS - Service ,  description: Service Request ,  implementation_dba_data: APPS.CS_SERVICE_REQUEST_PUB_V , 

  • View: CS_INCIDENT_LINKS_TO_V_SEC 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENT_LINKS_TO_V_SEC,  object_name:CS_INCIDENT_LINKS_TO_V_SEC,  status:VALID,  product: CS - Service ,  description: This is a secured view on cs_incidents_links_to_v ,  implementation_dba_data: APPS.CS_INCIDENT_LINKS_TO_V_SEC , 

  • View: CS_INCIDENT_LINKS_TO_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENT_LINKS_TO_V,  object_name:CS_INCIDENT_LINKS_TO_V,  status:VALID,  product: CS - Service ,  description: Show a Service Request that have linked to other documents such as Service Requests or Defect. ,  implementation_dba_data: APPS.CS_INCIDENT_LINKS_TO_V , 

  • View: CS_INCIDENT_LINKS_TO_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENT_LINKS_TO_V,  object_name:CS_INCIDENT_LINKS_TO_V,  status:VALID,  product: CS - Service ,  description: Show a Service Request that have linked to other documents such as Service Requests or Defect. ,  implementation_dba_data: APPS.CS_INCIDENT_LINKS_TO_V , 

  • View: CS_INCIDENT_LINKS_TO_V_SEC 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENT_LINKS_TO_V_SEC,  object_name:CS_INCIDENT_LINKS_TO_V_SEC,  status:VALID,  product: CS - Service ,  description: This is a secured view on cs_incidents_links_to_v ,  implementation_dba_data: APPS.CS_INCIDENT_LINKS_TO_V_SEC , 

  • View: CS_SERVICE_REQUEST_PUB_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SERVICE_REQUEST_PUB_V,  object_name:CS_SERVICE_REQUEST_PUB_V,  status:VALID,  product: CS - Service ,  description: Service Request ,  implementation_dba_data: APPS.CS_SERVICE_REQUEST_PUB_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_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_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_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_SEARCH_NO_CONT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_SEARCH_NO_CONT_V,  object_name:CS_SR_SEARCH_NO_CONT_V,  status:VALID,  product: CS - Service ,  description: This view is used in the SR find window on Bali spread table and in the Service History Bali Spreadtable of SR Tab ,  implementation_dba_data: APPS.CS_SR_SEARCH_NO_CONT_V , 

  • View: CS_SR_SEARCH_NO_CONT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_SEARCH_NO_CONT_V,  object_name:CS_SR_SEARCH_NO_CONT_V,  status:VALID,  product: CS - Service ,  description: This view is used in the SR find window on Bali spread table and in the Service History Bali Spreadtable of SR Tab ,  implementation_dba_data: APPS.CS_SR_SEARCH_NO_CONT_V , 

  • View: CS_SR_SEARCH_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_SEARCH_V,  object_name:CS_SR_SEARCH_V,  status:VALID,  product: CS - Service ,  description: This view is used in the SR find window on Bali spread table ,  implementation_dba_data: APPS.CS_SR_SEARCH_V , 

  • View: CS_SR_SEARCH_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_SEARCH_V,  object_name:CS_SR_SEARCH_V,  status:VALID,  product: CS - Service ,  description: This view is used in the SR find window on Bali spread table ,  implementation_dba_data: APPS.CS_SR_SEARCH_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_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_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 , 

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