Search Results fa_leases_u1

Overview

FA.FA_LEASES is the lease master table in the Oracle E-Business Suite Fixed Assets (FA) module. It stores lease information for leased assets, and the data held in this table is optional — an asset can be defined in Oracle Assets without any associated lease record. When a lease is associated with an asset through the Additions form, Oracle Assets copies the LEASE_ID of the appropriate lease into the corresponding FA_ADDITIONS row (via FA_ADDITIONS_B.LEASE_ID), establishing the linkage between the asset and its lease.

The table is owned by the FA schema and is registered in FND Design Data as OFA.FA_LEASES. It resides in the APPS_TS_TX_DATA tablespace with PCT Free 10. Its status is VALID in the documented ETRM 12.2.2 schema, which carries 39 columns. From a heuristic Data Vault modeling perspective, FA_LEASES is classified as satellite-leaning: it is a descriptive, attribute-rich structure keyed by a single surrogate identifier rather than a pure intersection of multiple business entities, though it does carry foreign key references to several independent master sources.

Key Information Stored

The surrogate primary key is LEASE_ID (NUMBER(15)), which uniquely identifies each lease record and is enforced by the FA_LEASES_PK constraint and the FA_LEASES_U1 unique index. Two business-key candidates are documented through unique indexes: FA_LEASES_U1 on LEASE_ID and FA_LEASES_U2 on the combination of LESSOR_ID and LEASE_NUMBER, meaning a given lessor cannot have two leases with the same lease number.

The most significant columns include:

• LEASE_NUMBER (VARCHAR2(15)) — the user-entered lease number, unique per lessor.
• LESSOR_ID (NUMBER(15)) — the unique identifier of the lessor, referencing PO_VENDORS.
• LESSOR_SITE_ID (NUMBER(15)) — the lessor's site, referencing PO_VENDOR_SITES_ALL.
• DESCRIPTION (VARCHAR2(30)) — a short description of the lease.
• CURRENCY_CODE — the lease currency, referencing FND_CURRENCIES.
• LEASE_TYPE and FASB_LEASE_TYPE — classification of the lease for accounting treatment.
• LEASE_TERM and ASSET_LIFE — the term of the lease and the associated asset life used in calculations.
• COST_CAPITALIZED, FAIR_VALUE, and PRESENT_VALUE — financial measures supporting lease accounting.
• TRANSFER_OWNERSHIP and BARGAIN_PURCHASE_OPTION — flags affecting lease classification.
• PAYMENT_SCHEDULE_ID — references FA_LEASE_SCHEDULES, tying the lease to its payment schedule.
• DIST_CODE_COMBINATION_ID — the default distribution account, referencing GL_CODE_COMBINATIONS.
• TERMS_ID — links the lease to its payment terms.

Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) provide audit tracking, and ATTRIBUTE1 through ATTRIBUTE15 plus ATTRIBUTE_CATEGORY_CODE comprise descriptive flexfield segments.

Common Use Cases and Queries

Typical reporting scenarios include listing all active leases by lessor, reviewing capitalized lease obligations, and reconciling lease payment schedules. A common query joins FA_LEASES to FA_ADDITIONS_B on LEASE_ID to retrieve the assets associated with a given lease:

SELECT l.lease_id, l.lease_number, l.description, a.asset_number, a.asset_id
FROM fa.fa_leases l, fa.fa_additions_b a
WHERE a.lease_id = l.lease_id;

Analysts also join FA_LEASES to PO_VENDORS on LESSOR_ID to obtain lessor names, and to FA_LEASE_SCHEDULES via PAYMENT_SCHEDULE_ID to review scheduled payments. Financial reporting on lease classification leverages FASB_LEASE_TYPE and LEASE_TYPE, while capitalized-value reporting uses COST_CAPITALIZED, FAIR_VALUE, and PRESENT_VALUE. Because the table is satellite-leaning, queries that filter by lessor and lease number benefit directly from the FA_LEASES_U2 unique index.

Related Objects

FA_LEASES is referenced by and references several core objects:

• FA_ADDITIONS_B — references FA_LEASES.LEASE_ID, associating an asset with its lease.
• FA_LEASE_PAYMENT_ITEMS — references FA_LEASES.LEASE_ID, holding individual payment items for the lease.
• FA_LEASE_SCHEDULES — referenced by FA_LEASES.PAYMENT_SCHEDULE_ID, defining the lease payment schedule.
• PO_VENDORS — referenced by FA_LEASES.LESSOR_ID, the lessor source of truth.
• PO_VENDOR_SITES_ALL — referenced by FA_LEASES.LESSOR_SITE_ID, the lessor site.
• FND_CURRENCIES — referenced by FA_LEASES.CURRENCY_CODE.
• GL_CODE_COMBINATIONS — referenced by FA_LEASES.DIST_CODE_COMBINATION_ID for the distribution account.

Together these relationships make FA_LEASES the central descriptive satellite for lease accounting in Oracle Assets.