Search Results cs_kb_wf_flows_b




Overview
Explore in AI Chat

Overview

The CS_KB_WF_FLOWS_B table is a core data object within the Oracle E-Business Suite (EBS) Service (CS) module, specifically supporting the Knowledge Base (KB) functionality. It serves as the base or master table for storing the definition of solution workflows, also referred to as flows. These workflows are structured, step-by-step processes designed to guide users—typically service agents or customers—through the resolution of a service request or incident. The table holds the fundamental, non-translatable attributes of each workflow definition. Its primary role is to act as the central reference point for workflow metadata, enabling the systematic delivery of guided troubleshooting and resolution procedures within the service knowledge management framework of Oracle EBS.

Key Information Stored

The table's structure is centered on a unique identifier for each workflow. The primary column is FLOW_ID, which is the surrogate primary key for every defined solution flow. While the provided ETRM metadata does not list all columns, typical attributes stored in a base table of this nature would include creation date (CREATION_DATE), created by (CREATED_BY), last update date (LAST_UPDATE_DATE), last updated by (LAST_UPDATED_BY), and other system-level audit columns. It likely also contains status flags (e.g., ACTIVE_FLAG), version information, and references to the workflow's owner or associated product category. The FLOW_ID is the critical column used to join this table to its related transactional and descriptive tables.

Common Use Cases and Queries

This table is primarily accessed for administrative configuration and reporting on solution workflows. Common operational scenarios include querying all active workflows for a specific product category, auditing workflow creation and modification history, and generating master lists of available resolution procedures. A typical reporting query would join this base table to its translation table (CS_KB_WF_FLOWS_TL) to retrieve the workflow name in a desired language. For example:

  • Retrieving a list of active workflows with their English names: SELECT b.FLOW_ID, tl.NAME FROM CS_KB_WF_FLOWS_B b, CS_KB_WF_FLOWS_TL tl WHERE b.FLOW_ID = tl.FLOW_ID AND tl.LANGUAGE = 'US' AND b.ACTIVE_FLAG = 'Y';
  • Identifying workflows associated with a specific category group via the foreign key relationship to CS_KB_CAT_GROUP_FLOWS.
  • Technical support for data fixes or migrations where the core workflow identifier (FLOW_ID) needs to be traced or updated.

Related Objects

The CS_KB_WF_FLOWS_B table is central to the knowledge base workflow schema, with several key objects dependent on its primary key. As documented in the ETRM metadata, the following foreign key relationships exist:

  • CS_KB_CAT_GROUP_FLOWS: Links workflows to specific category groups, enabling the assignment of solution flows to product or service categories. Join column: CS_KB_CAT_GROUP_FLOWS.FLOW_ID
  • CS_KB_WF_FLOWS_TL: The translation table that stores the language-specific names and descriptions for each workflow. Join column: CS_KB_WF_FLOWS_TL.FLOW_ID
  • CS_KB_WF_FLOW_DETAILS: Contains the detailed steps, conditions, and actions that constitute the procedural logic of the workflow. Join column: CS_KB_WF_FLOW_DETAILS.FLOW_ID

These relationships illustrate that CS_KB_WF_FLOWS_B is the parent table for workflow definition, with child tables managing its categorization, multilingual descriptions, and operational step-by-step details.