Search Results cs_incident_statuses_tl




Overview
Explore in AI Chat

Overview

The CS_INCIDENT_STATUSES_TL table is a core translation table within the Oracle E-Business Suite Service (CS) module. It stores the language-specific, user-facing descriptions for Service Request (also referred to as Incident) status codes. This table enables the multi-language support (MLS) capability of Oracle EBS, allowing status names to be displayed in a user's preferred language. It operates in conjunction with its base table, CS_INCIDENT_STATUSES_B, which holds the language-independent seed data. The TL table is essential for any interface or report that presents Service Request status information to end-users in a global deployment.

Key Information Stored

The table's structure is designed to manage translated text. The primary key is a composite of INCIDENT_STATUS_ID and LANGUAGE, ensuring a unique translation entry for each status in each language. The NAME column holds the actual translated status description (e.g., "Open," "Closed," "Pending Customer Input") for the specified LANGUAGE. The SOURCE_LANG column identifies the original language in which the data was seeded, which is typically 'US' for American English. Other standard translation table columns, such as CREATION_DATE and LAST_UPDATE_DATE, are also present to track row history. The critical columns for functional use are INCIDENT_STATUS_ID, LANGUAGE, and NAME.

Common Use Cases and Queries

The primary use case is retrieving a status name in a user's session language for display in forms, reports, and self-service portals. A standard query involves joining the base and translation tables while filtering for the current language. For example, to list all active statuses in the current session language, a developer might use:

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

Reporting on Service Request volumes by status across different language installations also requires this table to ensure accurate labeling. Data migration or integration scripts that populate status descriptions for non-English users must insert corresponding rows into this TL table.

Related Objects

CS_INCIDENT_STATUSES_TL has defined foreign key relationships with several key objects, as documented in the ETRM metadata:

  • CS_INCIDENT_STATUSES_B: The primary base table. The foreign key on CS_INCIDENT_STATUSES_TL.INCIDENT_STATUS_ID references CS_INCIDENT_STATUSES_B.INCIDENT_STATUS_ID. All translations are child records of a seed status defined in the base table.
  • FND_LANGUAGES: The table is referenced twice for language validation. The foreign key on CS_INCIDENT_STATUSES_TL.LANGUAGE ensures the translation row uses a valid language code. A separate foreign key on CS_INCIDENT_STATUSES_TL.SOURCE_LANG validates the original source language of the data.

Applications will typically access this data via views or public APIs provided by the Service module rather than querying the table directly.

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

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

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

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

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