Search Results payment_line_number

Overview

The FA_LEASE_PAYMENTS table is a core data structure within the Oracle E-Business Suite Fixed Assets (OFA) module. It serves as the detailed repository for the payment schedule associated with a leased asset. When a capital or finance lease is established in the system, the payment terms—including amounts, due dates, and types—are broken down and stored as individual line items in this table. Its primary role is to provide the granular payment schedule data necessary for accurate lease accounting, including the calculation of interest expense, principal reduction, and liability tracking over the lease term. The integrity of this data is critical for generating accurate financial reports and ensuring compliance with accounting standards such as ASC 842 and IFRS 16.

Key Information Stored

The table stores each discrete payment obligation for a lease schedule. As defined by its primary key, each record is uniquely identified by a combination of PAYMENT_SCHEDULE_ID and PAYMENT_LINE_NUMBER. Key columns typically include PAYMENT_AMOUNT, PAYMENT_DATE, and PAYMENT_TYPE to define the cash flow. For accounting purposes, columns such as INTEREST_AMOUNT, PRINCIPAL_AMOUNT, and CUMULATIVE_PRINCIPAL are essential for tracking the lease liability and right-of-use asset amortization. The PAYMENT_SCHEDULE_ID column is a foreign key that links each payment line back to its parent lease header information in the FA_LEASE_SCHEDULES table, ensuring a clear hierarchical relationship.

Common Use Cases and Queries

This table is central to lease payment processing and reporting. A common operational use case is generating a payment schedule report for a specific lease, which aids in cash flow forecasting and payment processing. For financial reporting, accountants query this table to calculate period-end lease liabilities and interest expenses. A typical query pattern involves joining FA_LEASE_PAYMENTS to FA_LEASE_SCHEDULES and FA_ADDITIONS to retrieve a comprehensive lease report.

• Sample Query: Retrieving the payment schedule for a specific lease.

SELECT flp.payment_line_number,
       flp.payment_date,
       flp.payment_amount,
       flp.principal_amount,
       flp.interest_amount
FROM   fa_lease_payments flp,
       fa_lease_schedules fls
WHERE  flp.payment_schedule_id = fls.payment_schedule_id
AND    fls.lease_id = <lease_id>
ORDER BY flp.payment_line_number;

Related Objects

The FA_LEASE_PAYMENTS table has a direct and fundamental relationship with the FA_LEASE_SCHEDULES table, as enforced by the foreign key FA_LEASE_PAYMENTS.PAYMENT_SCHEDULE_ID. FA_LEASE_SCHEDULES acts as the header, containing lease-level information like lessor, lease term, and interest rate, while FA_LEASE_PAYMENTS holds the corresponding detail lines. This table is also integral to the lease accounting engine within the Fixed Assets module and is referenced by various standard reports, interfaces, and the underlying APIs and PL/SQL packages that manage lease transactions, amortization calculations, and journal entry generation.