Search Results jtf_cal_items_b




Overview
Explore in AI Chat

Overview

JTF_CAL_ITEMS_B is the base table for Calendar Items within the CRM Foundation (JTF) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the transactional and appointment-oriented records that populate the Calendar functionality used across CRM applications such as Oracle Sales, Oracle TeleSales, Oracle Field Service, and Oracle Marketing. Each row represents a single calendar entry — an appointment, task, call, or event — associated with a resource and governed by a start and end time within a specific time zone.

The table resides in the JTF schema and carries a VALID status in the ETRM repository, with 19 documented columns in the 12.2.2 physical schema. In Data Vault modeling terms, the mined foreign-key structure classifies this object as hub-leaning: CAL_ITEM_ID serves as a stable, unique business key around which descriptive and contextual attributes cluster. Modelers may therefore treat JTF_CAL_ITEMS_B as the hub entity for calendar items, with translation and reference data modeled as satellites.

Key Information Stored

The primary key is CAL_ITEM_ID, enforced by the JTF_CAL_ITEMS_B_PK constraint. This surrogate identifier is the definitive business key and the join column used throughout the CRM Foundation calendar schema. Other significant columns include:

Common Use Cases and Queries

The table supports calendar queries that filter by resource, time window, or item type. A typical pattern retrieves upcoming items for a resource within a date range:

  • SELECT CAL_ITEM_ID, RESOURCE_ID, ITEM_TYPE_CODE, START_DATE, END_DATE FROM JTF.JTF_CAL_ITEMS_B WHERE RESOURCE_ID = :resource_id AND START_DATE >= :start AND END_DATE <= :end ORDER BY START_DATE;
  • Joining to HZ_TIMEZONES on TIMEZONE_ID converts stored boundaries to local time for display and reporting.
  • Joining to JTF_CAL_ITEMS_TL on CAL_ITEM_ID retrieves translated title and description content for multilingual deployments.
  • Aggregate reporting frequently groups by ITEM_TYPE_CODE or SOURCE_CODE to measure appointment volume by category or originating module.

Related Objects

  • JTF_CAL_ITEMS_TL — the translation table, joined on CAL_ITEM_ID, supplying language-specific text attributes.
  • HZ_TIMEZONES — referenced via TIMEZONE_ID to supply time zone definitions.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for multi-tenant security.
  • JTF_CAL_ITEMS_B_PK — the primary key constraint that other objects use as their FK target.
  • CRM Foundation calendar APIs — the Calendar Items public APIs, which read and write this table rather than allowing direct DML.