Search Results set_published_status




Overview
Explore in AI Chat

Overview

CS_KB_LINKED_SOLUTIONS_VIEW is an Oracle E-Business Suite (EBS) reporting view owned by the APPS schema and defined within the Service (CS) product family, specifically the Knowledge Base (KB) module. It exposes the relationships between Knowledge Base solution "sets" and the objects to which they are linked, filtered by the current user's security context. In EBS 12.1.1 and 12.2.2, this view serves as the principal read-only interface for retrieving linked-solution data without requiring direct navigation of the underlying intersection tables.

The view is not a base table; it is a join-based projection that consolidates metadata from solution set definitions, link definitions, lookup codes, set types, and visibility records. Its primary functional purpose is to return only those linked solutions that the querying user is permitted to see, based on visibility position thresholds and category-group assignments resolved at runtime through the CS_KB_SECURITY_PVT package.

Underlying Base Objects

The view is defined over the following documented objects:

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing which solutions are linked to specific objects, reporting published versus non-published linked solutions, and building security-aware dashboards that respect category-group visibility.

SELECT set_number, set_name, set_link_type_meaning,
       object_code, other_id, set_published_status
  FROM apps.cs_kb_linked_solutions_view
 WHERE set_published_status = 'PUB'
   AND set_link_type = 'SOLN'
 ORDER BY set_last_update_date DESC;

For object-centric lookups, filter on OBJECT_CODE and OTHER_ID. Because visibility and category filtering are applied internally, callers should not attempt to replicate security logic in outer queries; results returned by the view are already scoped to the current FND_GLOBAL session. Note that the view is a read-only reporting construct and should not be used as the basis for DML operations.