Search Results jtf_task_references_pk

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:

• TASK_REFERENCE_ID — The surrogate primary key, enforced by JTF_TASK_REFERENCES_B_PK and also carried on the unique index JTF_TASK_REFERENCES_B_U1. It uniquely identifies each reference record.
• TASK_ID — Foreign key to JTF_TASKS_B, identifying the task to which the reference belongs.
• OBJECT_TYPE_CODE — Foreign key to JTF_OBJECTS_B, defining the type of object being referenced.
• OBJECT_ID — Foreign key to CS_INCIDENTS_ALL_B, identifying the specific referenced object (for example, a service incident).
• OBJECT_NAME — Describes the referenced object.
• OBJECT_DETAILS — Holds supplementary details about the referenced object.
• REFERENCE_CODE — A code classifying the nature of the reference.
• OBJECT_VERSION_NUMBER — Supports optimistic locking / concurrency control.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-org / security group data partitioning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns maintained by the EBS framework.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — A standard DFF (Descriptive Flexfield) set of columns available for customer-specific extensions.

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.