Search Results set_last_update_date




Overview
Explore in AI Chat

Overview

APPS.CS_KB_LINKED_SOLUTIONS_VIEW is an internal Oracle E-Business Suite database view owned by the APPS schema, registered within FND Design Data as CS.CS_KB_LINKED_SOLUTIONS_VIEW. It presents a denormalized projection of knowledge base "sets" and their associated solution links, exposing both the set identifiers and the descriptive attributes of the link type that binds a knowledge set to a target object. The view is marked VALID in ETRM 12.2.2 and carries the standard Oracle warning that it is for Oracle Internal Use Only and is not supported for direct customer access except from standard Oracle Applications programs.

Functionally, the view consolidates metadata used by Service (CS) knowledge management features—particularly the linkage of solutions to service requests and related service codes. Because it surfaces SET_LINK_TYPE and its decoded meaning, it is frequently of interest to administrators searching for how link types are represented in the Service knowledge base. In EBS 12.1.1 and 12.2.2 the view is read-only, sourced entirely from CS knowledge tables and views rather than being updatable.

Underlying Base Objects

The documented base objects referenced by the view are:

  • CS_KB_SETS_VL — the knowledge set definition view supplying set identity and descriptive fields.
  • CS_KB_SET_LINKS — the linkage table that binds knowledge sets to other objects; this is the primary source of link type and target object information.
  • CS_KB_SET_TYPES_VL — value-list view of set type names.
  • CS_KB_VISIBILITIES_VL — value-list view of visibility definitions.
  • CS_KB_SET_CATEGORIES — set-to-category association.
  • CS_KB_CAT_GROUP_DENORM — denormalized category/group structure supporting knowledge organization.
  • CS_KB_SECURITY_PVT — the security package applied to enforce knowledge base access rules at query time.
  • CS_LOOKUPS and FND_GLOBAL — used respectively for lookup decoding (link type and published status meanings) and for session/environment context such as ORG_ID and user context.

Because CS_KB_SECURITY_PVT and FND_GLOBAL are packages invoked by the view definition, effective results depend on the runtime security context of the querying session.

Key Columns

Common Use Cases and Queries

The view is used to report which sets are linked to which objects and under what link type—useful for knowledge content audits, migration validation, and diagnosing why a solution does not appear against a service request. Note that the view is also referenced by CSD_RO_SERVICE_CODES_V, CSD_RO_SOLNS_V, and CS_SR_KB_SOLUTION_LINKS_V, which are the supported entry points for most functional reporting.

Representative query:

  • SELECT set_number, set_name, set_link_type, set_link_type_meaning
  • FROM apps.cs_kb_linked_solutions_view
  • WHERE set_link_type = :link_type;

Because access is unsupported for direct querying, reverse-engineering the database is necessary to understand the underlying base tables, and any production use should be validated against the supported Service views instead.