Search Results fa_convention_types




Overview
Explore in AI Chat

Overview

The FA_CONVENTION_TYPES table is a foundational reference table within the Oracle E-Business Suite Fixed Assets (OFA) module. Its primary function is to store the valid list of prorate convention codes and their corresponding descriptive names. A prorate convention is a critical accounting rule that determines how depreciation expense is allocated in the first and last years of an asset's life, based on the date it is placed in service or retired. This table acts as the system of record for these conventions, ensuring data integrity and consistency across all asset transactions and calculations in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is relatively simple, centering on a key code and its description. The primary column is PRORATE_CONVENTION_CODE, which serves as the unique identifier and primary key for each convention rule. This code is a short, meaningful string (e.g., 'FULLYEAR', 'HALFYEAR', 'MIDMONTH'). The companion column is the DESCRIPTION, which provides the full, user-friendly name for the convention (e.g., 'Full Year', 'Half Year', 'Mid-Month'). This design allows for efficient data validation and clear presentation in application forms and reports.

Common Use Cases and Queries

This table is primarily referenced for validation, reporting, and data setup. During asset addition or mass maintenance, the application validates the entered prorate convention code against this table. A common reporting need is to generate a simple list of all available conventions for documentation or setup verification. For technical troubleshooting, one might query which assets are using a specific convention to analyze depreciation patterns.

  • Listing all valid prorate conventions: SELECT prorate_convention_code, description FROM fa_convention_types ORDER BY 1;
  • Finding assets using the 'HALFYEAR' convention: SELECT asset_number FROM fa_books WHERE prorate_convention_code = 'HALFYEAR';
  • Validating a code during data migration: The table is used in JOIN conditions to ensure only valid codes are populated in transactional tables like FA_BOOKS.

Related Objects

As indicated by the extensive foreign key relationships in the metadata, FA_CONVENTION_TYPES is a central reference point for numerous transactional and setup tables. Key dependencies include: