Search Results cs_cf_flows_b




Overview
Explore in AI Chat

Overview

The CS_CF_FLOWS_B 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 the base table for storing flow instances, which are concrete executions or instantiations of a defined flow type. A flow type typically models a business process, such as a service request resolution path or a field service activity sequence. This table is central to the configuration and runtime tracking of these automated or guided processes, enabling structured service delivery and task management. Its role is to maintain the master record for each active or historical flow instance within the system.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the primary key and foreign key relationships define the essential structure. The FLOW_ID column is the unique identifier (primary key) for each flow instance record. Based on standard EBS table design patterns, the table likely contains columns to define the flow's context, such as FLOW_TYPE_ID linking to the flow definition, STATUS to track the instance's progress (e.g., 'ACTIVE', 'COMPLETE', 'CANCELLED'), and reference columns like OBJECT_ID and OBJECT_TYPE to associate the flow with a specific service request, task, or transaction. It would also include standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing.

Common Use Cases and Queries

This table is primarily accessed for operational reporting and process monitoring. Common use cases include generating reports on active flow instances to assess workload, analyzing the completion time of flow types to identify bottlenecks, and troubleshooting specific process instances. A typical query would join CS_CF_FLOWS_B with its descriptive TL (translation) table to retrieve user-friendly flow names and filter by status or creation date. For example, to find all active flows for a specific flow type, a query might be: SELECT f.FLOW_ID, tl.NAME, f.STATUS, f.CREATION_DATE FROM CS_CF_FLOWS_B f, CS_CF_FLOWS_TL tl WHERE f.FLOW_ID = tl.FLOW_ID AND f.FLOW_TYPE_ID = :p_flow_type AND f.STATUS = 'ACTIVE' AND tl.LANGUAGE = USERENV('LANG');. Integration points, such as triggering actions when a flow reaches a certain stage, would also rely on this table.

Related Objects

The CS_CF_FLOWS_B table has defined foreign key relationships with several other service module tables, forming a key part of the data model for configured flows.

  • CS_CF_FLOWS_TL: The translation table that stores language-specific names and descriptions for the flow instances, joined on the FLOW_ID column.
  • CS_CF_FLOW_PAGES_B: Stores the individual pages or steps associated with a flow instance. This table references CS_CF_FLOWS_B.FLOW_ID via its FLOW_ID column, defining the sequence of steps for each instance.
  • CS_CF_FLOW_PAGES_TL: The translation table for the flow page steps, also joined to CS_CF_FLOWS_B via the FLOW_ID column.

These relationships indicate that CS_CF_FLOWS_B serves as the parent record for both the descriptive translations and the detailed step-by-step structure of a configured flow instance.