Search Results okl_ae_templates_all




Overview
Explore in AI Chat

Overview

The OKL_AE_TEMPLATES_ALL table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It serves as the master repository for accounting templates, which are essential for the automated generation of accounting entries for various leasing and financing transactions. These templates define the accounting rules, including the accounts and distribution logic, that are applied to transaction types within a specific ledger (Set of Books). Its role is central to ensuring accurate and consistent financial postings across the complex contract lifecycle managed by the OKL module.

Key Information Stored

The table stores the metadata that defines an accounting template. Key columns include the primary identifier (ID), a unique composite key (TRY_ID, SET_OF_BOOKS_ID, STY_ID, AES_ID, NAME, VERSION), and descriptive fields. The critical foreign key columns establish the template's context and rules: TRY_ID links to the transaction type (OKL_TRX_TYPES_B), SET_OF_BOOKS_ID identifies the ledger, STY_ID references the stream type (OKL_STRM_TYPE_B), and AES_ID is a self-referencing key. The FMA_ID column can link to a formula (OKL_FORMULAE_B) for dynamic calculations. The NAME and VERSION columns allow for management of template iterations.

Common Use Cases and Queries

This table is primarily accessed for configuration, troubleshooting, and reporting related to the accounting engine. Common scenarios include identifying which accounting template is applied to a specific transaction type for a given ledger, auditing template versions, and diagnosing missing accounting entries. A typical query would join to related setup tables to retrieve a comprehensive view of template rules.

Sample Query: Retrieving active templates for a transaction type and ledger.

SELECT tem.name,
       tem.version,
       trx.name transaction_type,
       sty.name stream_type
FROM   okl_ae_templates_all tem,
       okl_trx_types_b trx,
       okl_strm_type_b sty
WHERE  tem.try_id = trx.id
AND    tem.sty_id = sty.id
AND    tem.set_of_books_id = 1 -- Specific Ledger ID
AND    trx.name = 'LEASE_INCEPTION';

Related Objects

The OKL_AE_TEMPLATES_ALL table has integral relationships with several key setup and transaction tables, as documented in the ETRM metadata.

  • Referenced By (Child Tables):
  • References (Parent Tables):
    • OKL_TRX_TYPES_B (TRY_ID): Master transaction type.
    • OKL_STRM_TYPE_B (STY_ID): Financial stream type (e.g., Rent, Interest).
    • OKL_FORMULAE_B (FMA_ID): Optional formula for advanced distribution logic.
    • OKL_AE_TEMPLATES_ALL (AES_ID): Self-referencing hierarchical relationship.