Search Results cs_kb_set_used_hists_pk

Overview

The CS_KB_SET_USED_HISTS table is a core data object within the Service (CS) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a transactional history log, specifically tracking the usage of knowledge base sets during user sessions. In the context of Oracle Service, a knowledge base set is a defined collection of solution articles, and this table records each instance where a particular set is accessed or utilized. Its primary role is to provide an auditable trail for analyzing knowledge base search patterns, solution effectiveness, and user interaction with the knowledge repository, supporting both operational reporting and strategic knowledge management initiatives.

Key Information Stored

The table's structure centers on linking three primary entities: a knowledge set, a history record, and a user session. Based on the provided metadata, the critical columns and their purposes are:

• SET_ID: A foreign key referencing CS_KB_SETS_B. This column identifies the specific knowledge base set that was used.
• HISTORY_ID: A foreign key referencing CS_KB_HISTORIES_B. This links to a broader history record, which likely contains details like the user, timestamp, and context of the interaction.
• SESSION_ID: A foreign key referencing CS_KB_SESSIONS. This identifies the user session in which the knowledge set was accessed.
• HISTORY_ID and SET_ID together form the table's primary key (CS_KB_SET_USED_HISTS_PK), ensuring a unique record for each set usage instance within a given history entry.

Common Use Cases and Queries

This table is pivotal for generating analytics on knowledge base performance. Common use cases include reporting on the most frequently consulted solution sets, understanding user search behavior, and measuring the adoption of published knowledge. A typical analytical query would join this table to its related master tables to produce a meaningful report.

Sample SQL Pattern:

• Top Used Knowledge Sets: SELECT s.NAME, COUNT(*) AS USAGE_COUNT FROM CS_KB_SET_USED_HISTS u, CS_KB_SETS_B s WHERE u.SET_ID = s.SET_ID GROUP BY s.NAME ORDER BY USAGE_COUNT DESC;
• Session Detail Analysis: SELECT ses.SESSION_NUMBER, h.CREATION_DATE, s.NAME FROM CS_KB_SET_USED_HISTS u, CS_KB_SESSIONS ses, CS_KB_HISTORIES_B h, CS_KB_SETS_B s WHERE u.SESSION_ID = ses.SESSION_ID AND u.HISTORY_ID = h.HISTORY_ID AND u.SET_ID = s.SET_ID;

Related Objects

As defined by its foreign key constraints, CS_KB_SET_USED_HISTS is a central junction table with direct dependencies on several key Service knowledge base tables:

• CS_KB_SETS_B: The master table for knowledge base sets. The SET_ID foreign key establishes the relationship to the specific set used.
• CS_KB_HISTORIES_B: The master table for knowledge base interaction histories. The HISTORY_ID links this usage record to a broader historical event.
• CS_KB_SESSIONS: The table storing knowledge base user session information. The SESSION_ID ties the set usage to a specific user session context.

This network of relationships positions CS_KB_SET_USED_HISTS as an essential component for reconstructing complete knowledge base usage scenarios within the EBS Service application.