Search Results fa_calendar_periods




Overview
Explore in AI Chat

Overview

FA_CALENDAR_PERIODS is a foundational reference table in the Oracle E-Business Suite Assets (OFA) module, owned by the FA schema. It stores the detailed period definitions that comprise each depreciation calendar used by Oracle Assets. While the parent table FA_CALENDAR_TYPES defines the corporate book calendar itself, FA_CALENDAR_PERIODS expands that calendar into its constituent accounting periods, each carrying explicit start and end dates, a sequential period number, and a period name. This table is central to depreciation processing, since every depreciation run, period close, and asset transaction in Oracle Assets is anchored to a specific fiscal period defined here. It is populated when a calendar is defined through the Asset Calendar setup, and it is referenced continuously throughout the asset lifecycle.

From a Data Vault modeling perspective, the mined relationship heuristic classifies FA_CALENDAR_PERIODS as satellite-leaning. It carries descriptive period attributes (dates, number, name) that qualify the parent calendar, with a foreign key dependency on FA_CALENDAR_TYPES acting as the driving key. Modelers should treat it as a satellite attached to a calendar hub or link rather than as an independent hub.

Key Information Stored

The table contains ten documented columns. The most significant are the period-defining attributes:

  • CALENDAR_TYPE — identifies the calendar to which the period belongs; the foreign key linking to FA_CALENDAR_TYPES.
  • PERIOD_NUM — the sequential period number within the calendar (for example, 1 through 12 for a monthly fiscal year, plus any adjusting periods).
  • PERIOD_NAME — the human-readable label of the period (for example, "JAN-24" or "JAN-YYYY").
  • START_DATE / END_DATE — the inclusive beginning and ending dates that bound the accounting period; these drive depreciation date logic.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns tracking who created and modified the row and when.

The surrogate primary key, FA_CALENDAR_PERIODS_PK, is composed of (CALENDAR_TYPE, PERIOD_NUM, START_DATE). Three unique indexes act as business-key candidates: FA_CALENDAR_PERIODS_U1 (CALENDAR_TYPE, PERIOD_NUM, START_DATE), FA_CALENDAR_PERIODS_U2 (CALENDAR_TYPE, START_DATE), and FA_CALENDAR_PERIODS_U3 (CALENDAR_TYPE, PERIOD_NAME). Together these guarantee that no two periods in the same calendar share a number, start date, or name.

Common Use Cases and Queries

Typical reporting scenarios include resolving a depreciation date to its fiscal period, listing all periods for a book calendar, and validating period boundaries before submitting depreciation or period-close programs. A representative query resolves a transaction date to its period name:

  • SELECT period_name, period_num, start_date, end_date FROM fa_calendar_periods WHERE calendar_type = :p_calendar AND :p_txn_date BETWEEN start_date AND end_date;
  • SELECT period_name FROM fa_calendar_periods WHERE calendar_type = :p_calendar AND period_num = :p_num;
  • SELECT * FROM fa_calendar_periods WHERE start_date BETWEEN :from_date AND :to_date ORDER BY calendar_type, period_num;

These patterns support period-close reconciliations, depreciation forecasting, and cross-checks between the FA period calendar and the General Ledger accounting calendar.

Related Objects

The most significant related tables and views are:

  • FA_CALENDAR_TYPES — parent table; join on FA_CALENDAR_PERIODS.CALENDAR_TYPE = FA_CALENDAR_TYPES.CALENDAR_TYPE.
  • FA_BOOK_CONTROLS — references the depreciation calendar tied to a book, via its calendar type.
  • FA_DEPRN_PERIODS — depreciation period status keyed by calendar and period, sharing the period concept.
  • FA_ADDITIONS_B — asset records whose periods in service reference calendar periods.
  • FA_DEPRN_SUMMARY — depreciation amounts computed per period.
  • FA_PERIOD_MAP and the FA_CALENDAR_PERIODS-based API used by the Asset Calendar form for validation.

Collectively these objects make FA_CALENDAR_PERIODS a critical reference table underpinning the entire Oracle Assets period and depreciation framework.