Results for “okl_fe_eo_terms_all_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_FE_EO_TERMS_ALL_B is the End of Term (EOT) value header table within the Oracle Lease and Finance Management (OKL) module. It stores the defining header records for End of Term terms — the contractual constructs that govern residual values, end-of-lease purchase options, and asset disposition terms applied when a lease or financing contract reaches maturity. In Oracle EBS 12.1.1 and 12.2.2, this table operates as the primary definition surface for reusable EOT templates that are subsequently versioned and attached to contracts, products, and rate/fee structures across the leasing lifecycle.

The documented heuristic Data Vault classification for this object is satellite-leaning. From a dimensional-modeling perspective, this suggests the table behaves primarily as a descriptive satellite hanging off a business key (the End of Term identifier and name), carrying descriptive and control attributes rather than acting as a pure hub of distinct business entities or a pure link between them. The multiple self-referencing and inbound foreign keys reinforce that interpretation: OKL_FE_EO_TERMS_ALL_B both references and is referenced by itself, indicating a hierarchical or versioned descriptive structure.

Key Information Stored

The table is documented with 33 columns under the OKL schema. The most significant include:

• END_OF_TERM_ID — The surrogate primary key, enforced by OKL_FE_EO_TERMS_ALL_B_PK. This is the internal identifier propagated to dependent tables.
• END_OF_TERM_NAME — The user-facing name of the End of Term term; combined with ORG_ID it forms unique index OKL_FE_EO_TERMS_ALL_B_U2, making it the primary business-key candidate.
• ORG_ID — The operating unit (multi-org) discriminator, essential for row-level security and for the U2 uniqueness constraint.
• PRODUCT_ID — Foreign key to OKL_PRODUCTS, tying the EOT term to the lease product under which it may be offered.
• CURRENCY_CODE — Currency in which EOT values are expressed.
• EOT_TYPE_CODE — Classifies the End of Term term type (for example, residual or purchase-option oriented).
• CATEGORY_TYPE_CODE — Categorization used to group or filter EOT terms.
• ORIG_END_OF_TERM_ID — Reference to the originating EOT term, supporting copies and derived definitions.
• STS_CODE — Status code controlling whether the term is active, draft, or otherwise usable.
• EFFECTIVE_FROM_DATE / EFFECTIVE_TO_DATE — Date-effective range governing when the term is valid.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/ADF framework.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — The standard Oracle DFF (descriptive flexfield) columns for extensible, customer-defined attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Typical usage involves retrieving the header definition for a given EOT term, driving setups, or joining to version and contract-level tables for reporting. A representative query lists active terms for an operating unit and product:

• SELECT eot.END_OF_TERM_ID, eot.END_OF_TERM_NAME, eot.CURRENCY_CODE, eot.STS_CODE FROM OKL_FE_EO_TERMS_ALL_B eot WHERE eot.ORG_ID = :org_id AND eot.PRODUCT_ID = :product_id AND eot.STS_CODE = 'ACTIVE'
• Date-effectiveness filtering: WHERE SYSDATE BETWEEN eot.EFFECTIVE_FROM_DATE AND NVL(eot.EFFECTIVE_TO_DATE, SYSDATE + 1)
• Joining to product definition: FROM OKL_FE_EO_TERMS_ALL_B eot, OKL_PRODUCTS p WHERE eot.PRODUCT_ID = p.PRODUCT_ID

Reporting scenarios commonly include listing all EOT terms by currency, auditing which EOT definitions are linked to live contracts, and reconciling attributes across versions by joining to OKL_FE_EO_TERM_VERS on END_OF_TERM_ID. Because flexibility matters, reporting teams frequently expose ATTRIBUTE1–ATTRIBUTE15 alongside the seeded columns.

Related Objects

The most significant dependent and referenced objects are:

• OKL_PRODUCTS — Referenced via OKL_FE_EO_TERMS_ALL_B.PRODUCT_ID.
• OKL_FE_EO_TERM_VERS — References this table via END_OF_TERM_ID and holds version-level EOT detail.
• OKL_LS_RT_FTR_SETS_ALL_B — References this table via END_OF_TERM_ID, tying EOT terms to rate/fee feature sets.
• OKL_FE_EO_TERMS_ALL_B (self-reference) — Via END_OF_TERM_ID and ORIG_END_OF_TERM_ID, supporting copies and hierarchical definitions.

Applications and concurrent programs within the OKL module read this header table to drive contract End of Term processing and value determination. Because it is a protected seed/setup table, changes should be made through supported leasing setup flows rather than direct DML.