Search Results jtf_task_references_b




Overview
Explore in AI Chat

Overview

JTF_TASK_REFERENCES_B is a CRM Foundation (JTF) base table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the reference details associated with a given task. A task in the CRM task framework — such as an activity, interaction, or follow-up assigned to a resource — frequently needs to be related to other business entities, documents, or objects. JTF_TASK_REFERENCES_B is the repository for those associations, capturing both the type of object referenced and the specific object identifier. It works in conjunction with its translation table, JTF_TASK_REFERENCES_TL, which holds language-specific reference text (the "_B" suffix denotes the base table in a translated pair).

From a data modeling perspective, the mined foreign key structure suggests a Data Vault classification of link. The table primarily resolves associations between a task (JTF_TASKS_B) and external referenced objects (JTF_OBJECTS_B, CS_INCIDENTS_ALL_B), which is the characteristic role of a link table in a Data Vault model. This classification is a heuristic modeling suggestion rather than an inherent EBS construct.

Key Information Stored

The table is owned by the JTF schema and contains 30 documented columns. The columns of greatest functional importance are:

The surrogate key TASK_REFERENCE_ID is distinct from the business-key candidate represented by the unique index JTF_TASK_REFERENCES_B_U1. The productive identifying relationship for a reference is the combination of TASK_ID plus OBJECT_TYPE_CODE plus OBJECT_ID, which together describe what a task points to.

Common Use Cases and Queries

Typical uses include retrieving all objects referenced by a task, showing all tasks that reference a particular object (such as an incident), and reporting on cross-entity linkages for CRM analytics. A representative query joins the table to its parent task and object type definitions:

  • Select references for a single task: SELECT r.TASK_REFERENCE_ID, r.OBJECT_TYPE_CODE, r.OBJECT_ID, r.OBJECT_NAME FROM JTF.JTF_TASK_REFERENCES_B r WHERE r.TASK_ID = :p_task_id;
  • Find all tasks referencing an incident: SELECT r.TASK_ID, r.OBJECT_TYPE_CODE FROM JTF.JTF_TASK_REFERENCES_B r WHERE r.OBJECT_TYPE_CODE = 'INCIDENT' AND r.OBJECT_ID = :p_object_id;
  • Join to object type metadata: SELECT r.TASK_REFERENCE_ID, o.OBJECT_CODE FROM JTF.JTF_TASK_REFERENCES_B r, JTF.JTF_OBJECTS_B o WHERE r.OBJECT_TYPE_CODE = o.OBJECT_CODE;

Security-group-aware reporting should additionally constrain SECURITY_GROUP_ID. Because the "_B" base table holds codes only, display reporting should join to JTF_TASK_REFERENCES_TL for translated reference text.

Related Objects

The most significant objects relating to this table, based on documented foreign key and primary key data, are:

  • JTF_TASKS_B — Parent task table; joined on JTF_TASK_REFERENCES_B.TASK_ID = JTF_TASKS_B.TASK_ID.
  • JTF_OBJECTS_B — Object type definition table; joined on JTF_TASK_REFERENCES_B.OBJECT_TYPE_CODE = JTF_OBJECTS_B.OBJECT_CODE.
  • CS_INCIDENTS_ALL_B — Service incident base table; joined on JTF_TASK_REFERENCES_B.OBJECT_ID = CS_INCIDENTS_ALL_B.INCIDENT_ID.
  • JTF_TASK_REFERENCES_TL — Translation table providing language-specific reference text for the base records.
  • FND_SECURITY_GROUPS — Security group definitions; joined on SECURITY_GROUP_ID.
  • JTF_TASK_REFERENCES_PK / JTF_TASK_REFERENCES_B_PK / JTF_TASK_REFERENCES_B_U1 — Primary key and unique index constraints controlling record identity.

Together these relationships establish JTF_TASK_REFERENCES_B as the linkage point between CRM tasks and the diverse business objects they reference within the EBS CRM Foundation data model.