Search Results cs_kb_set_attr_vals_pk

Overview

The CS_KB_SET_ATTR_VALS table is a foundational data structure within the Oracle E-Business Suite (EBS) Service (CS) module, specifically designed for the Knowledge Base (KB) functionality. Its primary role is to establish and manage a many-to-many relationship between knowledge base sets (CS_KB_SETS_B) and attribute values (CS_KB_ATTR_VALS_B). This relationship was essential for categorizing and associating solution content with specific attributes. However, a critical piece of documented information is that this table has been deprecated for a significant period. The official ETRM documentation explicitly states it has not been used since before release 11.5.8. Consequently, in EBS 12.1.1 and 12.2.2, this table is a legacy artifact and is not part of the active data model for the Knowledge Base.

Key Information Stored

The table's structure is minimal, consisting solely of the two foreign key columns that define the relationship. The SET_ID column references a unique knowledge base set identifier from the CS_KB_SETS_B table. The ATTRIBUTE_VAL_ID column references a unique attribute value identifier from the CS_KB_ATTR_VALS_B table. Together, these two columns form the table's primary key (CS_KB_SET_ATTR_VALS_PK), ensuring that any specific set and attribute value combination is recorded only once. Given its deprecated status, this table is expected to be empty or contain only historical data that is no longer processed by the application's business logic.

Common Use Cases and Queries

As a deprecated object, there are no active application use cases for the CS_KB_SET_ATTR_VALS table in EBS 12.1.1 or 12.2.2. Customizations or integrations should not rely on or write data to this table. Its primary relevance is for technical consultants and DBAs performing data cleanup, historical analysis, or understanding the evolution of the application's schema. A typical diagnostic query would involve a join to its parent tables to inspect any residual data:

• SELECT s.name set_name, av.attribute_val, sav.*
FROM cs.cs_kb_set_attr_vals sav,
cs.cs_kb_sets_b s,
cs.cs_kb_attr_vals_b av
WHERE sav.set_id = s.set_id
AND sav.attribute_val_id = av.attribute_val_id(+);

Any reporting or new development must utilize the current, active data model for Knowledge Base attributes and sets, which does not involve this junction table.

Related Objects

The relationships for CS_KB_SET_ATTR_VALS are strictly defined by its foreign key constraints, linking it to two core Knowledge Base tables. These relationships are documented as follows:

• CS_KB_SETS_B: This table is referenced via the foreign key from CS_KB_SET_ATTR_VALS.SET_ID. It stores the master definition of knowledge base sets.
• CS_KB_ATTR_VALS_B: This table is referenced via the foreign key from CS_KB_SET_ATTR_VALS.ATTRIBUTE_VAL_ID. It stores the valid values for knowledge base attributes.

No other tables, views, or public APIs in a standard EBS 12.1.1 or 12.2.2 instance should have active dependencies on this deprecated table.