Search Results fa_lease_schedules




Overview
Explore in AI Chat

Overview

The FA_LEASE_SCHEDULES table is a core data object within the Oracle E-Business Suite Fixed Assets (OFA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for payment schedule information associated with leased assets. This table is fundamental to the lease accounting lifecycle, storing the contractual terms that define the timing and amounts of lease payments. Its role is to provide the detailed payment blueprint that drives the calculation of lease liabilities, right-of-use assets, and the generation of periodic payment transactions within the system.

Key Information Stored

The table's primary key is PAYMENT_SCHEDULE_ID, which uniquely identifies each payment schedule. As indicated by the foreign key relationships, the table links to the FA_LEASES table, which holds the master lease agreement details. Critical columns typically found in this table, inferred from its purpose and common lease accounting requirements, include the LEASE_ID (linking to FA_LEASES), PAYMENT_NUMBER, PAYMENT_AMOUNT, PAYMENT_DATE, and CURRENCY_CODE. The CURRENCY_CODE column has a defined foreign key constraint to the FND_CURRENCIES table, ensuring referential integrity for the transaction currency. The table structures the sequence of all cash flows stipulated in the lease contract.

Common Use Cases and Queries

This table is primarily accessed for lease accounting calculations, payment processing, and financial reporting. A common operational use case is generating a schedule of upcoming lease payments for cash flow forecasting. A typical query would retrieve payment details for a specific lease, often joined with the FA_LEASES table for header information.

  • Retrieve Payment Schedule for a Lease: SELECT payment_number, payment_date, payment_amount FROM fa_lease_schedules WHERE lease_id = :p_lease_id ORDER BY payment_date;
  • Calculate Total Lease Liability Present Value: Application logic frequently queries this table to obtain the stream of future payments for discounting calculations, a key step in initial lease recognition and subsequent measurement under accounting standards like ASC 842 and IFRS 16.
  • Payment Processing Interface: Scheduled payments from this table feed into the payables interface or general ledger for the actual recording of lease expenses and liability reductions.

Related Objects

FA_LEASE_SCHEDULES is a central hub within the lease accounting data model. Its most critical relationships, as documented, are:

  • FA_LEASES: The parent table. The foreign key from FA_LEASES.PAYMENT_SCHEDULE_ID to this table establishes the master-detail relationship for a lease agreement.
  • FA_LEASE_PAYMENTS: This table is referenced by FA_LEASE_PAYMENTS via PAYMENT_SCHEDULE_ID. This relationship likely tracks the actual execution or posting status against the scheduled payment plan.
  • FND_CURRENCIES: Provides the valid list of currencies for the CURRENCY_CODE column, ensuring data integrity for multi-currency lease contracts.

Development and reporting efforts involving lease payments must consistently join through this table to ensure accurate and complete financial data.

  • Table: FA_LEASE_SCHEDULES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LEASE_SCHEDULES,  object_name:FA_LEASE_SCHEDULES,  status:VALID,  product: OFA - Assets ,  description: Payment schedule information ,  implementation_dba_data: FA.FA_LEASE_SCHEDULES , 

  • Table: FA_LEASE_SCHEDULES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LEASE_SCHEDULES,  object_name:FA_LEASE_SCHEDULES,  status:VALID,  product: OFA - Assets ,  description: Payment schedule information ,  implementation_dba_data: FA.FA_LEASE_SCHEDULES , 

  • Table: FA_LEASE_PAYMENTS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LEASE_PAYMENTS,  object_name:FA_LEASE_PAYMENTS,  status:VALID,  product: OFA - Assets ,  description: Payment schedule detail information ,  implementation_dba_data: FA.FA_LEASE_PAYMENTS , 

  • Table: FA_LEASE_PAYMENTS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LEASE_PAYMENTS,  object_name:FA_LEASE_PAYMENTS,  status:VALID,  product: OFA - Assets ,  description: Payment schedule detail information ,  implementation_dba_data: FA.FA_LEASE_PAYMENTS , 

  • Table: FA_LEASES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LEASES,  object_name:FA_LEASES,  status:VALID,  product: OFA - Assets ,  description: Lease information for leased assets ,  implementation_dba_data: FA.FA_LEASES , 

  • Table: FA_LEASES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LEASES,  object_name:FA_LEASES,  status:VALID,  product: OFA - Assets ,  description: Lease information for leased assets ,  implementation_dba_data: FA.FA_LEASES ,