Search Results cs_cf_flows_tl




Overview
Explore in AI Chat

Overview

The CS_CF_FLOWS_TL table is a translation table within the Oracle E-Business Suite (EBS) Service (CS) module, specifically for releases 12.1.1 and 12.2.2. As a translation (TL) table, its primary role is to store multilingual data, enabling the application to present user-facing text in different languages. This table directly supports its base table, CS_CF_FLOWS_B, by holding the translated descriptions, names, or other displayable attributes for the entities defined therein, which are related to service flows. The existence of this table is a standard Oracle EBS architectural pattern for supporting global deployments.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which dictate the core data it holds. The primary key is a composite of FLOW_ID and LANGUAGE, ensuring a unique translation entry for each flow in each language. The FLOW_ID column is a foreign key that links each row back to a specific record in the base table CS_CF_FLOWS_B. The LANGUAGE column is a foreign key referencing the FND_LANGUAGES table, storing the language code (e.g., 'US' for American English). A critical column for translation synchronization is SOURCE_LANG, which also references FND_LANGUAGES and identifies the original language in which the data was entered. The table's user-defined columns, typically named like FLOW_NAME or DESCRIPTION, would store the actual translated text, though their specific names are not detailed in the provided metadata.

Common Use Cases and Queries

The primary use case is retrieving flow information in a user's session language for UI display, reports, and data extracts. A standard query joins the base and translation tables, filtering by the session language and source language to ensure data integrity. For example, to fetch all flow names in the current session language, a developer might use:
SELECT b.FLOW_ID, tl.FLOW_NAME FROM CS_CF_FLOWS_B b, CS_CF_FLOWS_TL tl WHERE b.FLOW_ID = tl.FLOW_ID AND tl.LANGUAGE = userenv('LANG') AND tl.SOURCE_LANG = [original_language];
Another common scenario involves data migration or setup, where seeded flow data requires translation entries to be populated for additional installed languages. Administrators may query this table to audit translation coverage or identify missing entries for critical flows.

Related Objects

This table has direct, integral relationships with several core EBS objects as indicated by its foreign keys:

  • CS_CF_FLOWS_B: The base table for service flows. Every FLOW_ID in the translation table must exist here.
  • FND_LANGUAGES: The application's language master table, referenced twice: once for the LANGUAGE column (the translation's language) and once for the SOURCE_LANG column (the language of the original text).

In practice, this table will also be referenced by any views, forms, or reports in the Service module that display translatable flow information. Standard Oracle APIs for multilingual tables, such as FND_STANDARD_FLEX and the AD_ZD tables for zoning in 12.2, may also interact with this structure.

  • Table: CS_CF_FLOWS_TL 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_CF_FLOWS_TL,  object_name:CS_CF_FLOWS_TL,  status:VALID,  product: CS - Service ,  description: This table is the translation table for CS_CF_FLOWS_B. ,  implementation_dba_data: CS.CS_CF_FLOWS_TL , 

  • Table: CS_CF_FLOWS_TL 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_CF_FLOWS_TL,  object_name:CS_CF_FLOWS_TL,  status:VALID,  product: CS - Service ,  description: This table is the translation table for CS_CF_FLOWS_B. ,  implementation_dba_data: CS.CS_CF_FLOWS_TL , 

  • View: CS_CF_FLOWS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_CF_FLOWS_VL,  object_name:CS_CF_FLOWS_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_CF_FLOWS_B and CS_CF_FLOWS_TL tables. ,  implementation_dba_data: APPS.CS_CF_FLOWS_VL , 

  • View: CS_CF_FLOWS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_CF_FLOWS_VL,  object_name:CS_CF_FLOWS_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_CF_FLOWS_B and CS_CF_FLOWS_TL tables. ,  implementation_dba_data: APPS.CS_CF_FLOWS_VL , 

  • Table: CS_CF_FLOWS_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_CF_FLOWS_B,  object_name:CS_CF_FLOWS_B,  status:VALID,  product: CS - Service ,  description: This table stores the flow instances of a particular flow type. ,  implementation_dba_data: CS.CS_CF_FLOWS_B , 

  • Table: CS_CF_FLOWS_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_CF_FLOWS_B,  object_name:CS_CF_FLOWS_B,  status:VALID,  product: CS - Service ,  description: This table stores the flow instances of a particular flow type. ,  implementation_dba_data: CS.CS_CF_FLOWS_B ,