Search Results jtf_task_recur_rules

Overview

The JTF_TASK_RECUR_RULES table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module. It serves as the central repository for defining and storing recurrence rule definitions. These rules govern the repeating patterns for tasks, enabling the automation of recurring activities such as maintenance schedules, regular follow-ups, or periodic reviews. The table's primary role is to decouple the complex recurrence logic from the task definition itself, allowing a single rule to be referenced by multiple tasks or templates, thereby promoting data consistency and reusability within the application's task management framework.

Key Information Stored

The central piece of information stored is the RECURRENCE_RULE_ID, which serves as the unique primary key for each rule. While the provided ETRM excerpt does not list the full column structure, based on its function and standard Oracle CRM practice, this table typically contains columns that define the recurrence pattern. This includes the recurrence type (e.g., daily, weekly, monthly), the interval (e.g., every 2 weeks), specific days of the week or month, a start date, an end date or number of occurrences, and exception dates. The RECURRENCE_RULE_ID is the critical foreign key column referenced by other task-related entities to associate a task with a specific recurrence pattern.

Common Use Cases and Queries

The primary use case is the creation and management of recurring tasks. When a user defines a task to repeat, the application creates or references a record in this table. Common reporting and administrative queries involve identifying tasks using a specific rule or analyzing recurrence patterns. A fundamental query retrieves all tasks associated with a particular rule:

• SELECT task_number, task_name FROM jtf_tasks_b WHERE recurrence_rule_id = <RULE_ID>;

Another typical query audits rule usage to ensure rules are not orphaned or to clean up unused definitions:

• SELECT r.recurrence_rule_id FROM jtf_task_recur_rules r WHERE NOT EXISTS (SELECT 1 FROM jtf_tasks_b t WHERE t.recurrence_rule_id = r.recurrence_rule_id);

Integration or data migration scripts often query this table to extract and replicate recurrence logic alongside task data.

Related Objects

As documented in the foreign key relationships, JTF_TASK_RECUR_RULES is integral to the task management data model. The key related objects are:

• JTF_TASKS_B: The main tasks table references RECURRENCE_RULE_ID to apply a recurrence pattern to a task instance.
• JTF_TASK_TEMPLATES_B: Task templates can also store a reference to a recurrence rule, allowing templates to define repeating tasks.
• JTF_TASK_AUDITS_B: The audit table tracks changes to tasks by storing both the OLD_RECURRENCE_RULE_ID and NEW_RECURRENCE_RULE_ID, providing a history of when a task's recurrence pattern was modified.

These relationships underscore the table's critical function in separating recurrence definition from execution, supporting both live tasks and template-based task creation.