Search Results fa_lease_schedules




Overview
Explore in AI Chat

Overview

FA_LEASE_SCHEDULES is a table in the FA (Assets) schema of Oracle E-Business Suite, belonging to the OFA — Assets product module. It stores payment schedule information associated with lease agreements recorded in Oracle Assets. Each row defines the financial terms and timing characteristics of a lease payment schedule, including present value, interest rate, inception date, currency, and payment frequency, that Oracle Assets uses to generate and track individual lease payments.

The table functions as the parent structure for a lease's payment plan. Leases in FA_LEASES reference a payment schedule via PAYMENT_SCHEDULE_ID, and the individual payment lines are held in FA_LEASE_PAYMENTS, which also reference this table through the same PAYMENT_SCHEDULE_ID column. In Data Vault modeling terms, the mined FK structure classifies this table as hub-leaning: PAYMENT_SCHEDULE_ID behaves as a durable business key that anchors dependent link and satellite structures, while FA_LEASE_PAYMENTS and FA_LEASES act as the transactional and descriptive satellites. Practitioners may find it useful to model FA_LEASE_SCHEDULES as a hub keyed on PAYMENT_SCHEDULE_ID, with the remaining descriptive and financial attributes treated as satellite data.

Key Information Stored

The documented physical schema contains 12 columns. The most significant are:

  • PAYMENT_SCHEDULE_ID — The surrogate primary key (FA_LEASE_SCHEDULES_PK) and also the sole business-key candidate, enforced by unique index FA_LEASE_SCHEDULES_U1. It uniquely identifies each schedule and is the value carried by dependent tables.
  • PAYMENT_SCHEDULE_NAME — The user-facing identifier or description of the schedule, used for lookup and reporting.
  • PRESENT_VALUE — The present value of the lease payment stream, used in capitalized lease accounting and amortization calculations.
  • INTEREST_RATE — The interest or discount rate applied to the schedule, driving interest expense and liability amortization.
  • LEASE_INCEPTION_DATE — The commencement date of the lease, establishing the reference point for the payment timeline.
  • CURRENCY_CODE — The currency of the schedule; a foreign key to FND_CURRENCIES.
  • FREQUENCY — The payment interval (for example, monthly or quarterly) governing when scheduled payments fall due.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, and LAST_UPDATED_BY capture standard Oracle EBS who/when audit information.

Common Use Cases and Queries

Typical usage centers on lease accounting reporting, payment generation, and reconciliation between leases and their scheduled payments. A schedule joined to its lease provides the full picture of a lease obligation:

  • Retrieving schedule details for a given lease by joining FA_LEASES.PAYMENT_SCHEDULE_ID to FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID.
  • Listing all payments for a schedule by joining FA_LEASE_PAYMENTS.PAYMENT_SCHEDULE_ID to the schedule primary key, ordered by payment date.
  • Reporting schedules by CURRENCY_CODE, with a join to FND_CURRENCIES to obtain currency names.
  • Analyzing PRESENT_VALUE and INTEREST_RATE across schedules to support Impaired Asset and capitalized lease analysis, or to reconcile the sum of lease payments against present value.

A representative pattern joins the three lease tables and the currency lookup on their documented keys to produce a schedule-to-payment reconciliation report.

Related Objects

  • FA_LEASES — References this table via FA_LEASES.PAYMENT_SCHEDULE_ID; the lease header that owns the schedule.
  • FA_LEASE_PAYMENTS — References this table via FA_LEASE_PAYMENTS.PAYMENT_SCHEDULE_ID; the individual payment lines generated from the schedule.
  • FND_CURRENCIES — Referenced by this table through FA_LEASE_SCHEDULES.CURRENCY_CODE; supplies currency validation and descriptions.
  • FA_LEASE_SCHEDULES_PK / FA_LEASE_SCHEDULES_U1 — Primary key constraint and unique index on PAYMENT_SCHEDULE_ID that enforce schedule identity.