Search Results jtf_task_custom_colors




Overview
Explore in AI Chat

Overview

JTF_TASK_CUSTOM_COLORS is a configuration table in the JTF (CRM Foundation) schema of Oracle E-Business Suite, present in releases 12.1.1 and 12.2.2. It stores the custom color setup used by Oracle Task Manager and related CRM task and calendar interfaces. In these modules, tasks and assignments are rendered with color-coded visual indicators that communicate priority, escalation, or assignment status at a glance. Rather than hard-coding these visual rules, the application reads them from this table, allowing administrators and implementers to define deterministic color rules without code changes.

Each row defines a single color determination rule. A rule binds a task type, optionally a priority and an assignment status, plus an escalated-task flag, to a display color expressed in both decimal and RGB formats. The rules are ordered by a priority value that governs which rule wins when more than one rule could apply to a given task. From a Data Vault modeling perspective, the heuristic classification of this table is standalone; it is a reference or configuration table rather than a transactional hub, link, or satellite, and it should be modeled as such in any downstream warehouse design.

Key Information Stored

The table contains 16 documented columns. The most significant are grouped below.

Common Use Cases and Queries

The primary operational use of this table is diagnostic: when task colors do not match expectations, administrators inspect the rule set to confirm that an active rule exists, that its priority is correct, and that it points to the intended color values.

-- All active rules, ordered by determination priority
SELECT rule_id,
       color_determination_priority,
       type_id,
       priority_id,
       assignment_status_id,
       escalated_task,
       background_col_rgb,
       active_flag
  FROM   jtf.jtf_task_custom_colors
 WHERE  active_flag = 'Y'
 ORDER  BY color_determination_priority;

Reporting use cases include extracting the rule set for documentation during an upgrade or implementation audit, comparing rule configurations across environments (development versus production) before a patch is applied, and joining the rule set to the lookup tables to produce human-readable descriptions of each rule's task type and assignment status.

-- Rule set joined to assignment statuses
SELECT c.rule_id,
       c.color_determination_priority,
       s.status_code,
       c.background_col_rgb
  FROM   jtf.jtf_task_custom_colors c,
         irc.irc_assignment_statuses s
 WHERE  c.assignment_status_id = s.assignment_status_id
 ORDER  BY c.color_determination_priority;

Related Objects

The following objects are the most significant for working with this table, based on the documented foreign key relationships and the surrounding CRM Foundation data model:

  • JTF_TASK_CUSTOM_COLORS_PK — the primary key constraint on RULE_ID.
  • JTF_TASK_CUSTOM_COLORS_U1 / JTF_TASK_CUSTOM_COLORS_U2 — unique indexes on (RULE_ID, ZD_EDITION_NAME) and (COLOR_DETERMINATION_PRIORITY, ZD_EDITION_NAME) respectively.
  • IEO_SVR_TYPES_B — referenced through TYPE_ID; provides the task type definition.
  • IRC_ASSIGNMENT_STATUSES — referenced through ASSIGNMENT_STATUS_ID; provides the assignment status definition.
  • JTF_TASKS — the main task table whose records are colored according to these rules.
  • JTF_TASK_PRIORITIES — the priority reference data corresponding to PRIORITY_ID.

Together these objects form the configuration backbone that drives visual task rendering in Oracle CRM Foundation.