Search Results jtf_cal_items_b_pk

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:

• RESOURCE_ID and RESOURCE_TYPE — identify the owning resource (such as a salesperson, group, or asset) and the category of that resource, linking the calendar item to the appropriate calendar owner.
• ITEM_TYPE and ITEM_TYPE_CODE — classify the nature of the calendar entry (for example, appointment versus task) and provide a coded lookup value for reporting.
• SOURCE_CODE and SOURCE_ID — record the originating application or subsystem and the identifier of the source record, enabling cross-module traceability.
• START_DATE and END_DATE — define the active time window of the calendar item, which is the primary basis for calendar rendering and conflict detection.
• TIMEZONE_ID — a foreign key to HZ_TIMEZONES that anchors the start and end timestamps to a specific time zone.
• URL — stores an optional link back to the source record or a related application page.
• SECURITY_GROUP_ID — a foreign key to FND_SECURITY_GROUPS controlling multi-tenant data visibility.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER support concurrency control and audit reporting.
• APPLICATION_ID — identifies the owning application context for the row.

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.