Search Results cs_incidents_all_tl




Overview
Explore in AI Chat

Overview

The CS_INCIDENTS_ALL_TL table is a core data object within the Oracle E-Business Suite (EBS) Service (CS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual text for service request records. Its primary role is to support global deployments by enabling the storage of user-entered, language-specific information for service incidents, such as summaries and problem descriptions. This table works in conjunction with its base table, CS_INCIDENTS_ALL_B, which holds the non-translatable, transactional data. The existence of this TL (Translation) table is a standard Oracle EBS architectural pattern for achieving localization, ensuring that service representatives and customers can view and interact with incident details in their preferred language.

Key Information Stored

The table stores the language-specific textual attributes for a service incident. Its structure is defined by a composite primary key consisting of INCIDENT_ID and LANGUAGE. The INCIDENT_ID column is a foreign key that links each translated row to a unique record in the CS_INCIDENTS_ALL_B base table. The LANGUAGE column holds the language code (e.g., 'US' for American English) for the translation. The most critical data columns typically include SUMMARY and PROBLEM_DESCRIPTION, which contain the translated text for the incident's title and detailed issue narrative. Other common translatable attributes may include resolution notes or internal comments. The table employs Oracle's Multi-Lingual Table (MLS) architecture, where each translated version of an incident's text occupies a separate row.

Common Use Cases and Queries

The primary use case is retrieving service request information in a user's session language for display in forms, reports, and service portals. A standard query involves joining this table with the base incident table and filtering by the user's language preference. For example, to fetch the translated summary and description for a specific incident, a common SQL pattern is:

  • SELECT tl.summary, tl.problem_description
  • FROM cs_incidents_all_b b, cs_incidents_all_tl tl
  • WHERE b.incident_id = tl.incident_id
  • AND tl.language = USERENV('LANG')
  • AND b.incident_number = 'SR-12345';

Reporting use cases include generating service request history or customer communication logs in multiple languages. Data migration and integration scenarios also frequently interact with this table to populate or extract localized content.

Related Objects

CS_INCIDENTS_ALL_TL has a direct and essential relationship with several key Service module objects. Its primary foreign key relationship is with the base table CS_INCIDENTS_ALL_B via the INCIDENT_ID column. This is the most critical join for any transactional query. The table is also the source for corresponding translatable views, such as CS_INCIDENTS_ALL_VL. For data manipulation, standard Oracle APIs like the CS_ServiceRequest_PUB package are the recommended interface, which handle the complexity of maintaining both the base and translation tables. Other related tables may include CS_INCIDENT_INTERACTIONS for logged communications and CS_INCIDENT_SEVERITIES for priority data, though these typically join through the INCIDENT_ID in the base table.

  • Table: CS_INCIDENTS_ALL_TL 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_INCIDENTS_ALL_TL,  object_name:CS_INCIDENTS_ALL_TL,  status:VALID,  product: CS - Service ,  description: This table stores translated information about service requests. ,  implementation_dba_data: CS.CS_INCIDENTS_ALL_TL , 

  • Table: CS_INCIDENTS_ALL_TL 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_INCIDENTS_ALL_TL,  object_name:CS_INCIDENTS_ALL_TL,  status:VALID,  product: CS - Service ,  description: This table stores translated information about service requests. ,  implementation_dba_data: CS.CS_INCIDENTS_ALL_TL , 

  • View: CS_INCIDENTS_ALL_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENTS_ALL_VL,  object_name:CS_INCIDENTS_ALL_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_INCIDENTS_ALL_B and CS_INCIDENTS_ALL_TL tables. ,  implementation_dba_data: APPS.CS_INCIDENTS_ALL_VL , 

  • View: CS_INCIDENTS_ALL_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENTS_ALL_VL,  object_name:CS_INCIDENTS_ALL_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_INCIDENTS_ALL_B and CS_INCIDENTS_ALL_TL tables. ,  implementation_dba_data: APPS.CS_INCIDENTS_ALL_VL , 

  • View: CS_INCIDENTS_VL_SEC 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENTS_VL_SEC FND.CS_INCIDENTS_VL_SEC,  object_name:CS_INCIDENTS_VL_SEC,  status:VALID,  product: CS - Service ,  description: Multi-lingual Secured view based on CS_INCIDENTS_ALL_B_SEC_V view and CS_INCIDENTS_ALL_TL table. ,  implementation_dba_data: APPS.CS_INCIDENTS_VL_SEC , 

  • View: CS_NEW_INCIDENTS_V_SEC 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_NEW_INCIDENTS_V_SEC,  object_name:CS_NEW_INCIDENTS_V_SEC,  status:VALID,  product: CS - Service ,  description: This is a secured view created on top of the view CS_NEW_INCIDENTS_V ,  implementation_dba_data: APPS.CS_NEW_INCIDENTS_V_SEC , 

  • 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_TERRITORY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_TERRITORY_V,  object_name:CS_SR_TERRITORY_V,  status:VALID,  product: CS - Service ,  description: This view shows information about Service Request, and this is being used by Territory Management. ,  implementation_dba_data: APPS.CS_SR_TERRITORY_V , 

  • View: CS_SR_SERVICE_HISTORY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_SERVICE_HISTORY_V,  object_name:CS_SR_SERVICE_HISTORY_V,  status:VALID,  product: CS - Service ,  description: This view is being used by Service History Tab ,  implementation_dba_data: APPS.CS_SR_SERVICE_HISTORY_V , 

  • View: CS_NEW_INCIDENTS_V_SEC 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_NEW_INCIDENTS_V_SEC,  object_name:CS_NEW_INCIDENTS_V_SEC,  status:VALID,  product: CS - Service ,  description: This is a secured view created on top of the view CS_NEW_INCIDENTS_V ,  implementation_dba_data: APPS.CS_NEW_INCIDENTS_V_SEC , 

  • View: CS_NEW_INCIDENTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_NEW_INCIDENTS_V,  object_name:CS_NEW_INCIDENTS_V,  status:VALID,  product: CS - Service ,  description: This is a simplified version of view CS_INCIDENTS_V ,  implementation_dba_data: APPS.CS_NEW_INCIDENTS_V , 

  • View: CS_SR_TERRITORY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_TERRITORY_V,  object_name:CS_SR_TERRITORY_V,  status:VALID,  product: CS - Service ,  description: This view shows information about Service Request, and this is being used by Territory Management. ,  implementation_dba_data: APPS.CS_SR_TERRITORY_V , 

  • View: CS_SR_SERVICE_HISTORY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_SERVICE_HISTORY_V,  object_name:CS_SR_SERVICE_HISTORY_V,  status:VALID,  product: CS - Service ,  description: This view is being used by Service History Tab ,  implementation_dba_data: APPS.CS_SR_SERVICE_HISTORY_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_NEW_INCIDENTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_NEW_INCIDENTS_V,  object_name:CS_NEW_INCIDENTS_V,  status:VALID,  product: CS - Service ,  description: This is a simplified version of view CS_INCIDENTS_V ,  implementation_dba_data: APPS.CS_NEW_INCIDENTS_V , 

  • View: CS_SR_TASK_TERRITORY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_TASK_TERRITORY_V,  object_name:CS_SR_TASK_TERRITORY_V,  status:VALID,  product: CS - Service ,  description: This view shows combined information of Service Request and task , and this is being used by Territory Management. ,  implementation_dba_data: APPS.CS_SR_TASK_TERRITORY_V , 

  • View: CS_SR_TASK_TERRITORY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_TASK_TERRITORY_V,  object_name:CS_SR_TASK_TERRITORY_V,  status:VALID,  product: CS - Service ,  description: This view shows combined information of Service Request and task , and this is being used by Territory Management. ,  implementation_dba_data: APPS.CS_SR_TASK_TERRITORY_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_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_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_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.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_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_INCIDENTS_VL_SEC 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENTS_VL_SEC FND.CS_INCIDENTS_VL_SEC,  object_name:CS_INCIDENTS_VL_SEC,  status:VALID,  product: CS - Service ,  implementation_dba_data: APPS.CS_INCIDENTS_VL_SEC , 

  • 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.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_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_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_INCIDENTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENTS_V,  object_name:CS_INCIDENTS_V,  status:VALID,  product: CS - Service ,  description: Service requests and their attributes. This view is used by the main service request form. ,  implementation_dba_data: APPS.CS_INCIDENTS_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_INCIDENTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_INCIDENTS_V,  object_name:CS_INCIDENTS_V,  status:VALID,  product: CS - Service ,  description: Service requests and their attributes. This view is used by the main service request form. ,  implementation_dba_data: APPS.CS_INCIDENTS_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_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 ,