Search Results okl_fe_eo_terms_all_b




Overview
Explore in AI Chat

Overview

The OKL_FE_EO_TERMS_ALL_B table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the OKL (Lease and Finance Management) product module. It functions as the header table for managing End of Term (EOT) values. In lease and finance management, the end-of-term process is critical for handling options available to a lessee at contract maturity, such as purchase, renewal, or return. This table serves as the master definition for these EOT configurations, linking them to specific financial products and providing a foundation for associated versioned details and calculations.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the primary and foreign keys, the structure and relationships indicate the type of information stored. The primary identifier is the END_OF_TERM_ID, a unique system-generated key. A crucial foreign key is PRODUCT_ID, which links the EOT terms definition to a specific financial product in the OKL_PRODUCTS table. This relationship ensures that EOT options are correctly associated with the lease or finance product for which they are valid. The table's "ALL_B" suffix and its self-referencing foreign key suggest it supports multi-organization architecture (Multi-Org), allowing definitions to be shared or specific across operating units.

Common Use Cases and Queries

This table is central to configuring and reporting on end-of-lease options. Common operational and analytical use cases include product setup validation, auditing EOT configurations, and generating reports for portfolio management. A typical query would join the header to its related version detail table to retrieve a complete set of active terms for a product.

  • Retrieve EOT Headers for a Specific Product:
    SELECT eot.END_OF_TERM_ID, eot.PRODUCT_ID, prod.PRODUCT_NAME FROM OKL_FE_EO_TERMS_ALL_B eot, OKL_PRODUCTS prod WHERE eot.PRODUCT_ID = prod.PRODUCT_ID AND prod.PRODUCT_ID = :p_product_id;
  • Validate Product-EOT Configuration (Existence Check):
    SELECT COUNT(*) FROM OKL_FE_EO_TERMS_ALL_B WHERE PRODUCT_ID = :p_product_id;
  • List All EOT Headers with Associated Product Information:
    SELECT eot.END_OF_TERM_ID, prod.PRODUCT_NAME, prod.PRODUCT_DESC FROM OKL_FE_EO_TERMS_ALL_B eot INNER JOIN OKL_PRODUCTS prod ON eot.PRODUCT_ID = prod.PRODUCT_ID ORDER BY prod.PRODUCT_NAME;

Related Objects

The OKL_FE_EO_TERMS_ALL_B table is a nexus within the End of Term data model, with documented relationships to several key objects.

  • Primary Key Reference: The table is primarily accessed via its END_OF_TERM_ID column (Primary Key: OKL_FE_EO_TERMS_ALL_B_PK).
  • Foreign Keys (This Table References):
    • OKL_PRODUCTS via PRODUCT_ID: Establishes the financial product to which the EOT terms apply.
    • OKL_FE_EO_TERMS_ALL_B (self-reference) via END_OF_TERM_ID: Likely supports hierarchical or template-based data structures within the same table.
  • Foreign Keys (Tables Referencing This Table):
    • OKL_FE_EO_TERMS_ALL_B (self-reference): As above.
    • OKL_FE_EO_TERM_VERS via END_OF_TERM_ID: This is the most critical relationship. The version table (OKL_FE_EO_TERM_VERS) holds the detailed, versioned terms (e.g., pricing, effective dates) for each header record defined in OKL_FE_EO_TERMS_ALL_B.