Search Results cs_kb_set_type_links_pk

Overview

The CS_KB_SET_TYPE_LINKS table is a legacy data object within the Oracle E-Business Suite Service (CS) module. Its primary function was to model a one-to-many relationship between knowledge base set types and external application entities, thereby enabling the categorization and linking of knowledge content to other objects in the system. However, as explicitly noted in the official documentation, this table has been deprecated and is not used. Its functionality was rendered obsolete prior to the release of Oracle EBS version 11.5.8. Consequently, in both the 12.1.1 and 12.2.2 versions referenced, this table exists purely as a historical artifact within the CS schema, with no active role in application logic or data processing for the knowledge base.

Key Information Stored

The table's structure was designed to manage associative links. Its primary columns, as indicated by its foreign key relationships, include a unique LINK_ID serving as the primary key, a SET_TYPE_ID to reference a specific knowledge base set type from the CS_KB_SET_TYPES_B table, and an OBJECT_CODE to reference an external entity definition from the JTF_OBJECTS_B table. This schema allowed a single set type to be associated with multiple external object codes. Given its deprecated status, this table is expected to be empty or contain only vestigial data from very old installations, and no new data is written to it by the application.

Common Use Cases and Queries

There are no active application use cases for this table in the specified EBS releases. Its presence is solely for backward compatibility in the database schema. Technical consultants or DBAs might encounter it during data cleanup audits, schema analysis, or when reviewing legacy customizations. A typical diagnostic query would simply check for any residual data:

• SELECT COUNT(*) FROM cs.cs_kb_set_type_links;
• SELECT * FROM cs.cs_kb_set_type_links WHERE ROWNUM < 10;

Any custom code or reports referencing this table should be considered obsolete and must be reviewed for removal or migration to current, supported APIs and tables within the Knowledge Management framework.

Related Objects

The table's documented foreign key relationships explicitly define its connections to other entities, which are also likely part of the legacy knowledge base structure. These relationships are:

• CS_KB_SET_TYPES_B: Linked via the column CS_KB_SET_TYPE_LINKS.SET_TYPE_ID. This table defines the knowledge base set types.
• JTF_OBJECTS_B: Linked via the column CS_KB_SET_TYPE_LINKS.OBJECT_CODE. This core table defines various objects and entities across the JTF (Java Toolkit Framework) layer.

The primary key constraint CS_KB_SET_TYPE_LINKS_PK on the LINK_ID column enforces uniqueness for these historical link records.