Search Results fa_leases




Overview
Explore in AI Chat

Overview

The FA_LEASES table is a core data repository within the Oracle E-Business Suite Fixed Assets module (OFA). It serves as the master table for storing fundamental lease information pertaining to leased assets. Its primary role is to define and manage the contractual and financial parameters of a lease agreement, enabling the system to track lessor details, payment schedules, and associated accounting distributions. This table is essential for the proper accounting, amortization, and reporting of capital and operating leases as defined by accounting standards, forming a critical link between asset records, vendor information, and the general ledger.

Key Information Stored

The table's structure captures the comprehensive details of a lease contract. Its primary key, LEASE_ID, uniquely identifies each lease record. Critical columns, as indicated by the foreign key relationships, include LESSOR_ID (linking to PO_VENDORS to identify the leasing company), PAYMENT_SCHEDULE_ID (linking to FA_LEASE_SCHEDULES for payment terms), and CURRENCY_CODE (linking to FND_CURRENCIES). The LESSOR_SITE_ID links to the specific vendor site in PO_VENDOR_SITES_ALL. For accounting integration, the DIST_CODE_COMBINATION_ID column holds the default general ledger code combination for lease-related transactions, linked to GL_CODE_COMBINATIONS. Other typical columns, inferred from standard functionality, would store data such as lease start and end dates, lease type (capital/operating), interest rate, and lease description.

Common Use Cases and Queries

This table is central to lease management and reporting processes. Common operational use cases include creating or modifying a lease record for a newly acquired leased asset, generating lease payment schedules, and running standard reports for lease obligations. For technical analysis and custom reporting, common SQL query patterns involve joining FA_LEASES with related tables. For instance, to list all capital leases with their lessor and associated asset, a query would join FA_LEASES to PO_VENDORS and FA_ADDITIONS_B. Another typical query retrieves lease details along with the default accounting distribution code for audit purposes by joining with GL_CODE_COMBINATIONS. Troubleshooting often involves queries to find assets (FA_ADDITIONS_B) linked to a specific lease or to validate lessor information against the vendor tables.

Related Objects

As documented in the foreign key metadata, FA_LEASES has integral relationships with several key EBS objects. It is a parent table to FA_ADDITIONS_B (which references LEASE_ID to associate an asset with a lease) and FA_LEASE_PAYMENT_ITEMS (which references LEASE_ID for detailed payment line items). It is a child table referencing master data: PO_VENDORS and PO_VENDOR_SITES_ALL (for lessor data), FND_CURRENCIES, GL_CODE_COMBINATIONS (for accounting), and FA_LEASE_SCHEDULES (for payment terms). This network of relationships positions FA_LEASES as a central hub connecting procurement (vendors), asset tracking, and financial accounting within the Fixed Assets application.