Search Results cug_tsk_typ_attr_deps_b




Overview
Explore in AI Chat

Overview

The CUG_TSK_TYP_ATTR_DEPS_B table is a core data structure within the Oracle E-Business Suite Citizen Interaction Center (CUG) module. It functions as a master repository for defining and storing dependency rules that govern the relationship between task types and service request attributes for a given service request type. This table is essential for enforcing business logic where specific attributes of a service request (incident) dictate or are linked to the creation and properties of associated tasks. Its role is to maintain referential integrity and configuration data that drives the automated linkage between service requests and their corresponding workflow tasks in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to store dependency definitions. The central column is the surrogate primary key, TSK_TYP_ATTR_DEP_ID, which uniquely identifies each dependency rule. Two critical foreign key columns establish the core relationship: TASK_TYPE_ID references a specific task type from JTF_TASK_TYPES_B, and INCIDENT_TYPE_ID references a specific service request type from CS_INCIDENT_TYPES_B. Together, these columns define which task type is applicable for a given type of service request. While the provided metadata does not list all columns, the table's description implies it likely contains additional columns to specify the particular service request attribute(s) involved and the nature of the dependency condition.

Common Use Cases and Queries

This table is primarily accessed during the service request creation and task generation processes. A common operational query would retrieve all task type dependencies configured for a specific service request type to validate or display available task actions. For reporting and administration, queries often join this table to its related entities to audit configuration. A typical pattern is:

  • Identifying configured dependencies: SELECT dep.TSK_TYP_ATTR_DEP_ID, tt.NAME TASK_TYPE, it.NAME INCIDENT_TYPE FROM CUG.CUG_TSK_TYP_ATTR_DEPS_B dep, JTF_TASK_TYPES_B tt, CS_INCIDENT_TYPES_B it WHERE dep.TASK_TYPE_ID = tt.TASK_TYPE_ID AND dep.INCIDENT_TYPE_ID = it.INCIDENT_TYPE_ID;
  • Troubleshooting task generation failures by verifying dependencies exist for a given incident and task type combination.
  • Supporting data migration or upgrade scripts where custom dependency rules must be preserved or analyzed.

Related Objects

The CUG_TSK_TYP_ATTR_DEPS_B table sits at the center of a defined relational model. It references two foundational EBS tables and is referenced by three CUG-specific transactional and descriptive tables.

  • Referenced Tables (Foreign Keys from CUG_TSK_TYP_ATTR_DEPS_B):
    • JTF_TASK_TYPES_B: Via TASK_TYPE_ID. Links the dependency to the standard Oracle task type.
    • CS_INCIDENT_TYPES_B: Via INCIDENT_TYPE_ID. Links the dependency to the standard Oracle service request type.
  • Referencing Tables (Foreign Keys to CUG_TSK_TYP_ATTR_DEPS_B):