Search Results fa_amort_schedules




Overview
Explore in AI Chat

Overview

The FA_AMORT_SCHEDULES table is a core Assets (OFA) module object in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the amortization schedules associated with lease payment obligations. It belongs to the FA schema and carries a status of VALID in the ETRM repository. Its documented purpose is the storage of amortization schedules, which decompose each scheduled lease payment into its component interest and principal portions, along with the remaining lease obligation at each payment point.

In the context of Oracle Assets, this table supports the calculations required for capital and operating lease accounting, where periodic payments must be split between interest expense and reduction of the lease liability. The table is keyed on a payment schedule and a line number, allowing many amortization lines per schedule.

From a data modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is standalone. This suggests that, absent additional FK relationships, the object is best modeled as an independent satellite-like structure rather than a true link table. Where the classification is applied heuristically, it should be treated as a modeling suggestion rather than a binding design decision.

Key Information Stored

The table contains 12 documented columns. The most important include:

  • PAYMENT_SCHEDULE_ID — identifies the parent payment schedule to which the amortization line belongs; part of the composite primary key.
  • AMORTIZATION_LINE_NUM — the sequence number of the amortization line within the schedule; the second component of the composite primary key.
  • PAYMENT_DATE — the scheduled date of the payment for which the amortization is calculated.
  • PAYMENT_AMOUNT — the total scheduled payment amount for that line.
  • INTEREST — the interest portion of the scheduled payment.
  • PRINCIPAL — the principal portion of the scheduled payment, representing the reduction of the lease obligation.
  • LEASE_OBLIGATION — the outstanding lease obligation remaining after the payment is applied.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns capturing the most recent modification.
  • CREATED_BY, CREATION_DATE — standard WHO audit columns capturing row creation.

The surrogate primary key is FA_AMORT_SCHEDULES_PK, defined on the composite of PAYMENT_SCHEDULE_ID and AMORTIZATION_LINE_NUM. A unique index, FA_AMORT_SCHEDULES_U1, exists on the same column pair, making that combination the documented business-key candidate. There is no separate single-column surrogate; the composite pair serves both roles.

Common Use Cases and Queries

Typical reporting and reconciliation scenarios include lease amortization schedules, interest-versus-principal breakdowns, and outstanding obligation tracking. A common query pattern retrieves the full amortization schedule for a given payment schedule:

  • SELECT payment_schedule_id, amortization_line_num, payment_date, payment_amount, interest, principal, lease_obligation FROM fa_amort_schedules WHERE payment_schedule_id = :id ORDER BY amortization_line_num;
  • Aggregate totals of interest and principal per schedule for period-end accrual reporting.
  • Identify the closing lease obligation as of a given date by selecting the line with the greatest payment_date less than or equal to the reporting date.
  • Audit queries filtering on last_update_date or last_updated_by to detect recently modified amortization lines.

Related Objects

Because the documented relationship data classifies this object as standalone, no foreign keys are recorded in the metadata. In practice the most significant related objects are:

  • FA_PAYMENT_SCHEDULES — the parent schedule table, joined on PAYMENT_SCHEDULE_ID.
  • FA_LEASE_PAYMENTS — the underlying lease payment transactions feeding the schedule.
  • FA_LEASE_DETAILS / lease asset tables — joined through the schedule to the leased asset.
  • FA_BOOKS — for ledger-context reporting of amortization results.
  • FA_DEPRN_SUMMARY — for combined depreciation and amortization reporting.
  • Standard WHO audit views and FA_AMORT_SCHEDULES public APIs used by the Lease Management and Assets accounting processes.

Because the documented FK structure is limited, join paths to these objects should be confirmed against the actual data model before relying on them in production queries.