Results for “jtf_task_temp_groups_b_u1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_TASK_TEMP_GROUPS_B is a CRM Foundation (JTF) base table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores task template group definitions. A task template group is an organizing construct that bundles related task templates into a reusable set, allowing functional flows — sales methodology stages, service request routing, claims handling, and reason-code-driven activities — to instantiate a consistent collection of tasks from a single group reference. The table is owned by the JTF schema and is classified as VALID in the ETRM repository.

The heuristic Data Vault classification for this object is hub-leaning. This is consistent with its role as a master reference for task template group identity: the primary key TASK_TEMPLATE_GROUP_ID anchors group identity, while descriptive and effective-dating attributes behave as satellite-style attributes. Downstream mapping and transactional tables attach to this hub through foreign keys, which is the expected hub-to-link pattern.

Key Information Stored

The table contains 29 documented columns. The most significant are:

• TASK_TEMPLATE_GROUP_ID — surrogate primary key, enforced by JTF_TASK_TEMPLATE_GROUPS_PK and JTF_TASK_TEMP_GROUPS_B_PK. It is also the leading column of unique index JTF_TASK_TEMP_GROUPS_B_U1, making it the documented business-key candidate when combined with ZD_EDITION_NAME.
• SOURCE_OBJECT_TYPE_CODE — identifies the source object type for the group; participates in a foreign key to JTF_OBJECTS_B.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective-dating window controlling when the group is usable.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org and group-based data security.
• APPLICATION_ID — identifies the owning application context.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the ORM framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the DFF/descriptive flexfield segment set for extensibility.
• ZD_EDITION_NAME — editioning column supporting online patching and edition-based redefinition in 12.2.x.

Common Use Cases and Queries

The most frequent reporting pattern is retrieving the set of task templates belonging to a group, or tracing which sales methodology, claims, or service-request artifacts reference a given group. A representative join is:

• SELECT g.task_template_group_id, t.task_id FROM jtf_task_temp_groups_b g JOIN jtf_task_templates_b t ON t.task_group_id = g.task_template_group_id WHERE g.start_date_active <= SYSDATE AND (g.end_date_active IS NULL OR g.end_date_active >= SYSDATE);
• SELECT m.task_template_group_id FROM as_sales_meth_task_map m JOIN jtf_task_temp_groups_b g ON m.task_template_group_id = g.task_template_group_id;
• SELECT c.claim_id, g.task_template_group_id FROM ozf_claims_all c JOIN jtf_task_temp_groups_b g ON c.task_template_group_id = g.task_template_group_id;

Common scenarios include auditing active versus expired template groups, validating that every sales methodology task map resolves to a live group, and reporting task template groups by security group for data-access review.

Related Objects

The following references are documented in the ETRM relationship data:

• JTF_TASK_TEMPLATES_B — child table joining on TASK_GROUP_ID = TASK_TEMPLATE_GROUP_ID; holds the individual templates within a group.
• AS_SALES_METH_TASK_MAP — the object the user searched for; joins on TASK_TEMPLATE_GROUP_ID and maps sales methodology tasks to template groups.
• AS_SALES_METH_STAGE_MAP — joins on TASK_TEMPLATE_GROUP_ID to associate groups with sales methodology stages.
• AHL_ROUTES_B — joins on TASK_TEMPLATE_GROUP_ID for routing definitions.
• OZF_CLAIMS_ALL and OZF_CLAIMS_HISTORY_ALL — join on TASK_TEMPLATE_GROUP_ID for claims processing.
• OZF_REASONS — joins on TASK_TEMPLATE_GROUP_ID to associate reason definitions with groups.
• XNC_CS_SR_TASK_MAP and CS_SR_TSK_TMPL_GP_MAP — join on TASK_TEMPLATE_GROUP_ID for service request task mapping.
• JTF_OBJECTS_B — parent reference for SOURCE_OBJECT_TYPE_CODE.
• FND_SECURITY_GROUPS — parent reference for SECURITY_GROUP_ID.