Search Results jtf_calendars_b




Overview
Explore in AI Chat

Overview

The JTF_CALENDARS_B table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module. It serves as the master definition table for calendars, which are fundamental to scheduling, resource management, and time-based operations across the application. The table stores the base, non-translatable attributes of a calendar, including its name, type, description, and effectivity dates. Calendars defined in this table are referenced by numerous other components, such as project management (PA), service, and resource scheduling applications, to govern working days, shifts, and exceptions for tasks and assignments.

Key Information Stored

The table's primary key is the CALENDAR_ID, a unique system-generated identifier for each calendar record. While the provided ETRM excerpt does not list all columns, the description indicates the table holds essential metadata. Key columns typically include CALENDAR_NAME, CALENDAR_TYPE (e.g., Working, Non-Working, Gregorian), a DESCRIPTION, and EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to manage the calendar's validity period. The structure is designed as a base table, with language-specific translations for fields like the name and description stored in the related JTF_CALENDARS_TL table.

Common Use Cases and Queries

This table is central to queries that determine resource availability, project scheduling, and service appointment windows. A common use case is identifying the working calendar assigned to a specific project or resource to validate if a proposed task date is valid. Sample SQL patterns often involve joining JTF_CALENDARS_B to its child assignment tables. For instance, to list all active calendars of a specific type, a query might be: SELECT calendar_id, calendar_name FROM jtf.jtf_calendars_b WHERE calendar_type = 'WORKING' AND SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, SYSDATE). Reporting use cases include auditing calendar utilization across projects or analyzing calendar definitions for compliance with organizational working hour policies.

Related Objects

As indicated by the foreign key relationships, JTF_CALENDARS_B is a heavily referenced parent table. Key dependent objects include:

These relationships underscore the table's critical role in propagating calendar rules to operational data throughout EBS.