Search Results cs_kb_wf_flows_s

Overview

APPS.CS_KB_WF_PKG is the workflow integration package body for the Oracle E-Business Suite Knowledge Management (Knowledge Base) module. It provides the server-side PL/SQL logic that binds Knowledge Base solution content to Oracle Workflow, allowing organizations to route knowledge articles, solutions, and related flows through configurable approval and publication processes. The package carries a classification of OTHER in the ETRM repository and is documented with 33 procedures and functions in Oracle EBS 12.1.1 and 12.2.2.

Functionally, CS_KB_WF_PKG mediates between the Knowledge Base data model (solution sets, categories, products, and flows) and the Workflow engine. It resolves flow definitions, validates user permissions against workflow steps and groups, determines the current status and step of a running flow, and supports lifecycle operations such as enabling, expiring, and ending workflows. The package is also the driver behind the CS_KB_WF_FLOWS_S table, which is the subject of frequent user searches such as "cs_kb_wf_flows_s" — this table stores workflow flow sequencing and versioning data consumed by the package.

Key Procedures and Functions

• GETACTIONNAME, GETSTATUS, GETSTEPGROUP — Return descriptive attributes of a workflow instance, including the current action name, overall status, and the step group associated with the flow.
• GETFLOWID — Resolves the identifier of a flow definition for a given knowledge object or context.
• HASPERMISSION, ISMEMBER — Evaluate whether the current user holds the privileges required to act on a flow step, including membership checks against resource groups.
• INCATEGORY, INPRODUCT — Determine whether a solution or flow belongs to a specified category or product, supporting scoping and security filtering.
• END_WF, EXPIRE_DETAIL, EXPIRE_FLOW, ENABLE_FLOW — Lifecycle maintenance routines that terminate a running workflow, expire individual flow details or an entire flow, and activate a flow for use.
• GET_ACTIONS, GET_ALL_GROUPS, GET_ALL_STEPS, GET_FLOW_DETAILS, GET_FLOWS, GET_PERMISSIONS, GET_PERMISSIONS_FOR_PUB_SOLN, GET_STEP_LIST — Query routines that return collections of actions, groups, steps, flow details, flow headers, and permission sets, including a dedicated variant for published solutions. These are the primary entry points used by Knowledge Base UI components.

Tables Accessed

The package reads and writes through APPS synonyms. Flow metadata is drawn from CS_KB_WF_FLOWS_B, CS_KB_WF_FLOWS_TL, and CS_KB_WF_FLOWS_S (base, translation, and sequence tables), with detail-level data in CS_KB_WF_FLOW_DETAILS and CS_KB_WF_FLOW_DETAILS_S. Knowledge content scoping uses CS_KB_SETS_B, CS_KB_SETS_TL, CS_KB_SET_CATEGORIES, and CS_KB_SET_PRODUCTS. Security and routing leverage JTF_RS_GROUPS_TL, JTF_RS_GROUP_MEMBERS, and JTF_RS_GROUPS_VL. User and profile context is obtained from FND_USER, FND_LANGUAGES, FND_PROFILE_OPTIONS, and FND_PROFILE_OPTION_VALUES.

Usage Notes

CS_KB_WF_PKG is invoked indirectly by Knowledge Base forms, JTF region logic (JTF_REGION_PUB), and any custom code that drives solution approval workflows. It is referenced by two other packages and depends on CS_KB_SECURITY_PVT, CS_KB_SOLUTION_PVT, CS_KB_PROFILES_PKG, and WF_ENGINE. Customizations should treat the package as a supported integration surface rather than modify its body, since its scope tables underpin workflow status reporting across the Knowledge Base application.