Results for “cs_kb_cat_group_flows”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_KB_CAT_GROUP_FLOWS is a Service (CS) module table in the Oracle E-Business Suite, owned by the CS schema and valid in both release 12.1.1 and 12.2.2. It is documented as the Knowledge Base Category Group Flows linking table. Its purpose is to associate a Knowledge Base category group with a workflow flow, allowing a single flow to be attached to one or more category groups and a single category group to reference multiple flows. Because the table carries no descriptive business attributes beyond the key pair, it functions purely as an intersection structure between the two parent entities.

Under the heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as a link entity. That classification is a modeling suggestion rather than a stored attribute: the table resolves a many-to-many relationship between CS_KB_CATEGORY_GROUPS_B and CS_KB_WF_FLOWS_B, which is the canonical role of a link table in a Data Vault representation. No hub or satellite characteristics (single natural key with descriptive history) are present in the documented structure.

Key Information Stored

The table has 23 documented columns, most of which are standard EBS who-columns and descriptive flexfield segments. The structurally significant elements are:

• CATEGORY_GROUP_ID — foreign key to CS_KB_CATEGORY_GROUPS_B. Identifies the Knowledge Base category group participating in the association. This is one half of the composite primary key.
• FLOW_ID — foreign key to CS_KB_WF_FLOWS_B. Identifies the workflow flow linked to the category group. This is the second half of the composite primary key.
• CREATION_DATE, CREATED_BY — audit columns recording when and by whom the association row was created.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns recording the most recent modification to the association.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) context and segment columns, reserved for customer-specific extension of the link record.

The primary key is CS_KB_CAT_GROUP_FLOWS_PK, defined on the composite of CATEGORY_GROUP_ID and FLOW_ID. A unique index, CS_KB_CAT_GROUP_FLOWS_U1, exists on the identical column pair (CATEGORY_GROUP_ID, FLOW_ID), confirming that each category group / flow combination may appear exactly once. There is therefore no separate surrogate primary key column distinct from the business key; the business key pair is the primary key.

Common Use Cases and Queries

The principal use case is determining which workflows are available for, or assigned to, a given Knowledge Base category group, and conversely which category groups a flow serves. Typical reporting includes coverage analysis of flows across category groups and detection of category groups with no associated flow.

A simple join to list flows for a category group:

• SELECT cg.name, wf.name FROM cs.cs_kb_cat_group_flows f, cs.cs_kb_category_groups_b cg, cs.cs_kb_wf_flows_b wf WHERE f.category_group_id = cg.category_group_id AND f.flow_id = wf.flow_id;

For diagnostics, querying the link table directly by CATEGORY_GROUP_ID or FLOW_ID supports impact assessment before deactivating a category group or a flow definition. Audit-oriented queries filter on CREATION_DATE or LAST_UPDATE_DATE to review recently established or changed associations, and the DFF columns may be exposed in custom reports where extensibility attributes have been populated.

Related Objects

The table participates in two documented foreign key relationships, which form the core reference set:

• CS_KB_CATEGORY_GROUPS_B — joined on CS_KB_CAT_GROUP_FLOWS.CATEGORY_GROUP_ID = CS_KB_CATEGORY_GROUPS_B.CATEGORY_GROUP_ID. Supplies the category group name and definition for each link row.
• CS_KB_WF_FLOWS_B — joined on CS_KB_CAT_GROUP_FLOWS.FLOW_ID = CS_KB_WF_FLOWS_B.FLOW_ID. Supplies the workflow flow definition associated with the category group.

Because both foreign keys point to the _B (base) tables, the corresponding _TL translation tables for CS_KB_CATEGORY_GROUPS and CS_KB_WF_FLOWS are commonly joined in multilingual reporting to obtain translated names. Together these objects constitute the Knowledge Base category group and workflow configuration model within the Service module.