Search Results fa_lease_payments_pk

Overview

FA_LEASE_PAYMENTS is a transaction-level table in the Oracle Assets (OFA) module that stores payment schedule detail information for leased assets. Each row represents one individual payment line within a lease payment schedule, capturing the timing, amount, and present-value characteristics of a scheduled lease payment. The table resides in the FA schema and is documented in ETRM 12.2.2 with thirteen physical columns. It sits beneath FA_LEASE_SCHEDULES in the object hierarchy, functioning as the detail tier of the lease accounting model: schedules define the overall obligation, while FA_LEASE_PAYMENTS decomposes that obligation into discrete, dated installments used by the lease amortization and present-value calculation programs. Under the heuristic Data Vault classification mined from the foreign-key structure, this table is satellite-leaning. In modeling terms, it is best treated as a satellite attached to the lease schedule hub/link, since it carries descriptive and measurable attributes keyed to a parent business entity rather than acting as an independent hub or an associative link.

Key Information Stored

The primary key, FA_LEASE_PAYMENTS_PK, is a composite surrogate formed from PAYMENT_SCHEDULE_ID and PAYMENT_LINE_NUMBER. A unique index, FA_LEASE_PAYMENTS_U1, exists on the identical column pair, which makes that pair the effective business-key candidate as well as the physical key. PAYMENT_LINE_NUMBER is the sequence identifier for a payment within its schedule; this is the column most frequently referenced in the "payment_line_number" search context, and it is what allows consumers to address, order, and compare individual installments deterministically. PAYMENT_SCHEDULE_ID is the foreign key to FA_LEASE_SCHEDULES and ties each line to its parent schedule. START_DATE and END_DATE bound the payment period being recognized or amortized, while PERIOD records the payment frequency or interval descriptor. PAYMENT_AMOUNT holds the monetary value of the line, and NUMBER_OF_PAYMENTS expresses how many payments the line encompasses where payment patterns aggregate installments. ROW_PRESENT_VALUE stores the discounted present value of the payment stream for the lease, supporting the interest-and-amortization calculations central to capital lease accounting. The remaining columns — CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, and LAST_UPDATED_BY — are standard Oracle EBS audit columns that record row provenance and change history.

Common Use Cases and Queries

Typical usage centers on reconciliation, amortization, and payment schedule reporting. The most common access pattern filters by payment line number within a schedule, for example:

• Retrieving a specific installment: SELECT * FROM fa.fa_lease_payments WHERE payment_schedule_id = :p_schedule_id AND payment_line_number = :p_line_number;
• Listing all installments for a schedule in sequence: SELECT payment_line_number, start_date, end_date, payment_amount, row_present_value FROM fa.fa_lease_payments WHERE payment_schedule_id = :p_schedule_id ORDER BY payment_line_number;
• Aggregating total scheduled obligation per schedule: SELECT payment_schedule_id, SUM(payment_amount) FROM fa.fa_lease_payments GROUP BY payment_schedule_id;
• Audit/traceability reporting on recently changed schedule lines using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Reporters join this table to FA_LEASE_SCHEDULES to present lease-level context alongside installment detail, and present-value columns support period-by-period interest expense computations in lease accounting reports.

Related Objects

• FA_LEASE_SCHEDULES — the parent table; joined on FA_LEASE_PAYMENTS.PAYMENT_SCHEDULE_ID = FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID. This is the only documented foreign key relationship.
• FA_LEASE_PAYMENTS_PK / FA_LEASE_PAYMENTS_U1 — the composite primary key and unique index on (PAYMENT_SCHEDULE_ID, PAYMENT_LINE_NUMBER), which constrain and index access.
• FA_ASSET_LEASES / lease master objects — reachable transitively through the schedule header for asset-level lease reporting.
• Lease amortization and present-value calculation programs within the Oracle Assets lease functionality, which read PAYMENT_AMOUNT and ROW_PRESENT_VALUE to generate amortization schedules.
• Lease payment and invoice interfaces that consume schedule lines to generate payable transactions for the period.

Because only the FA_LEASE_SCHEDULES foreign key is documented, broader lineage should be verified against the deployed 12.1.1 / 12.2.2 instance before being relied upon in custom integrations.