Search Results avl_avl_uk




Overview
Explore in AI Chat

Overview

The OKL_AE_TEMPLATES table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for accounting templates. These templates define the rules and structures for generating accounting entries (journal lines) for various financial transactions processed within the leasing system. The table's primary role is to link a specific transaction type, stream type, and accounting template set to a set of books, ensuring that revenue, expense, and balance sheet postings are created accurately and consistently according to the configured accounting rules.

Key Information Stored

The table stores the defining attributes of an accounting template. Its structure, as indicated by the primary and foreign keys, centers on unique combinations of key identifiers. The primary key constraint AVL_AVL_UK enforces uniqueness on the combination of TRY_ID (Transaction Type), SET_OF_BOOKS_ID, STY_ID (Stream Type), AES_ID (Accounting Template Set), NAME, and VERSION. The surrogate primary key is the ID column. Other critical foreign key columns include FMA_ID, which links to a formula (OKL_FORMULAE_B) potentially used within the template logic. The NAME and VERSION columns allow for the management and evolution of template definitions over time.

Common Use Cases and Queries

This table is central to the accounting engine of Oracle Leasing. Common operational and reporting use cases include validating the accounting setup for a new lease product, troubleshooting missing or incorrect journal entries, and auditing the active templates for a given set of books. A typical diagnostic query would join to related setup tables to list all configured templates. For example:

  • Template Listing: SELECT avl.name, avl.version, tt.name transaction_type, sty.name stream_type, aes.name template_set FROM okl_ae_templates avl, okl_trx_types_b tt, okl_strm_type_b sty, okl_ae_tmpt_sets aes WHERE avl.try_id = tt.id AND avl.sty_id = sty.id AND avl.aes_id = aes.id AND avl.set_of_books_id = :sob_id;
  • Impact Analysis: Identifying which contracts or lines use a specific template is crucial before modifying it. This involves joining OKL_AE_TEMPLATES to OKL_TXL_CNTRCT_LNS via the AVL_ID column.

Related Objects

The OKL_AE_TEMPLATES table sits at the intersection of several key setup and transaction tables in the OKL schema, as documented by its foreign key relationships.

  • Referenced By (Child Tables):
    • OKL_TRNS_ACC_DSTRS links via TEMPLATE_ID. This table likely stores the detailed accounting distributions generated by the template.
    • OKL_TXL_CNTRCT_LNS links via AVL_ID. This indicates the template is assigned to contract lines, driving their accounting.
  • References (Parent Tables):
    • OKL_AE_TMPT_SETS via AES_ID: The accounting template set grouping.
    • OKL_FORMULAE_B via FMA_ID: The formula used in the template logic.
    • OKL_STRM_TYPE_B via STY_ID: The financial stream type (e.g., Rent, Interest).
    • OKL_TRX_TYPES_B via TRY_ID: The transaction type (e.g., Invoice, Accrual).