Search Results fa_calendar_types

Overview

The FA_CALENDAR_TYPES table is a core reference table within the Oracle E-Business Suite (EBS) Fixed Assets (OFA) module. It serves as the master repository for defining and storing different fiscal calendars used for asset accounting. Its primary role is to establish the foundational calendar structures upon which all asset depreciation, proration, and financial reporting are built. Each calendar type defined in this table, such as a corporate fiscal calendar or a statutory calendar for tax reporting, is then detailed with its specific periods in the related FA_CALENDAR_PERIODS table. The integrity of asset transactions is dependent on the correct setup and reference of these calendar types.

Key Information Stored

The table's structure is designed to catalog unique calendar definitions. While the full column list is not detailed in the provided metadata, the primary key is explicitly documented as CALENDAR_TYPE. This column uniquely identifies each calendar, for example, 'CORPORATE' or 'TAX'. Based on its role as a reference table, it likely contains descriptive columns such as a name or description for the calendar, creation date, and the user who created it. The table's purpose is not to store the period dates themselves, but to define the distinct types of calendars available for assignment to asset books.

Common Use Cases and Queries

The primary use case is the setup and maintenance of depreciation and prorate calendars during the configuration of an asset book in the FA_BOOK_CONTROLS table. It is also critical for reporting and troubleshooting calendar-related issues. Common SQL queries involve listing all available calendar types or identifying which books use a specific calendar. For example, to find all asset books using a particular depreciation calendar, one would join FA_CALENDAR_TYPES to FA_BOOK_CONTROLS.

• Listing all defined calendar types: SELECT calendar_type FROM fa_calendar_types;
• Finding books linked to a calendar: SELECT bc.book_type_code FROM fa_book_controls bc WHERE bc.deprn_calendar = '&CALENDAR_NAME';
• Validating calendar setup for reporting: Queries often join FA_CALENDAR_TYPES to FA_CALENDAR_PERIODS to report on period ranges for each calendar type.

Related Objects

As indicated by the foreign key metadata, FA_CALENDAR_TYPES is centrally linked to several key Fixed Assets tables. The FA_BOOK_CONTROLS table references it twice: once for the DEPRN_CALENDAR (which governs the timing of depreciation expense postings) and once for the PRORATE_CONVENTION (which determines the prorate calendar for calculating partial period depreciation in the first and last year of an asset's life). Furthermore, the FA_CALENDAR_PERIODS table has a foreign key to FA_CALENDAR_TYPES.CALENDAR_TYPE, creating a master-detail relationship where the type defines the header and the periods table stores the detailed date ranges for each period within that calendar.