Search Results cs_sr_link_valid_obj




Overview
Explore in AI Chat

Overview

The CS_SR_LINK_VALID_OBJ table is a core configuration table within the Oracle E-Business Suite Service (CS) module, present in both releases 12.1.1 and 12.2.2. It functions as a control mechanism that governs the permissible relationships between different business objects when creating links in the Service Request (SR) system. Specifically, it stores the valid combinations of link types and the object types that can participate in those links. This enforces business rules by restricting links—such as "Duplicate Of" or "Related To"—to only a selected set of objects, ensuring data integrity and logical consistency. For instance, it prevents a Service Request from being erroneously linked as a duplicate of an incompatible object type like a Defect.

Key Information Stored

The table's primary purpose is to map link types to valid subject and object types. Its key columns include LINK_VALID_OBJ_ID, which serves as the primary key. The LINK_TYPE_ID column references a specific link type defined in CS_SR_LINK_TYPES_B. The SUBJECT_TYPE and OBJECT_TYPE columns both reference the JTF_OBJECTS_B table, which is the central repository for all business object definitions in Oracle Applications (e.g., SR, Incident, Defect, Task). These two columns define the pair of object types that are allowed for the given link type, where the subject is the source object and the object is the target of the link.

Common Use Cases and Queries

A primary use case is validating a link before it is created in the SR user interface or via an API. Administrators may query this table to audit or configure the available linking rules. Common reporting needs include listing all valid object pairings for a specific link type or identifying all link types applicable to a particular object. A sample query to retrieve all valid link configurations with descriptive names is:

  • SELECT lt.LINK_TYPE_NAME, subj.OBJECT_NAME AS SUBJECT_OBJECT, obj.OBJECT_NAME AS OBJECT_OBJECT
  • FROM CS_SR_LINK_VALID_OBJ val,
  • CS_SR_LINK_TYPES_B lt,
  • JTF_OBJECTS_B subj,
  • JTF_OBJECTS_B obj
  • WHERE val.LINK_TYPE_ID = lt.LINK_TYPE_ID
  • AND val.SUBJECT_TYPE = subj.OBJECT_CODE
  • AND val.OBJECT_TYPE = obj.OBJECT_CODE
  • ORDER BY 1,2,3;

Related Objects

The CS_SR_LINK_VALID_OBJ table maintains defined foreign key relationships with other critical EBS objects, as documented in the metadata:

  • CS_SR_LINK_TYPES_B: Linked via CS_SR_LINK_VALID_OBJ.LINK_TYPE_ID. This table defines the master list of available link types (e.g., "Related To", "Duplicate Of").
  • JTF_OBJECTS_B: Linked twice. First, via CS_SR_LINK_VALID_OBJ.SUBJECT_TYPE to JTF_OBJECTS_B.OBJECT_CODE, identifying the source object type. Second, via CS_SR_LINK_VALID_OBJ.OBJECT_TYPE to JTF_OBJECTS_B.OBJECT_CODE, identifying the target object type. This table provides the descriptive names for the object codes.

These relationships are fundamental for any join query that requires descriptive information beyond the internal codes stored in CS_SR_LINK_VALID_OBJ.