Search Results okl_ae_tmpt_sets

Overview

The table OKL_AE_TMPT_SETS 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 template sets. In the context of lease accounting, these template sets define the collection of specific accounting templates (e.g., for revenue recognition, depreciation, or liability amortization) that are grouped together and applied to lease contracts. The table's primary role is to establish and maintain the definitions of these reusable rule sets, which are then linked to transaction contracts to govern their automated accounting entries. It is a foundational table for the configuration and execution of the subledger accounting engine within the leasing module.

Key Information Stored

The table stores the defining attributes of an accounting template set. The primary identifier is the system-generated surrogate key, ID, used for all internal relationships. The business key is defined by the combination of NAME and VERSION, which uniquely identifies a specific iteration of a template set. This design allows for version control, enabling the creation of new versions of a template set for different accounting standards or effective dates without altering historical data. While the provided metadata does not list all columns, typical attributes for such a master table would include a description, effective dates (FROM_DATE and TO_DATE), and status controls to manage the lifecycle of the template set.

Common Use Cases and Queries

A primary use case is the setup and maintenance of accounting rules during implementation. Administrators create named template sets (e.g., 'US GAAP Operating Lease Set') and associate specific accounting templates to them. During transaction processing, the system references the template set linked to a contract to determine the correct accounting entries. Common reporting and validation queries include listing all active template sets or identifying which contracts use a specific set. A sample query to retrieve basic template set information would be:

SELECT id, name, version
FROM okl_ae_tmpt_sets
WHERE SYSDATE BETWEEN from_date AND NVL(to_date, SYSDATE);

Another critical operational query involves joining to the OKL_TRX_CONTRACTS table to analyze the assignment of accounting rules to active lease contracts.

Related Objects

As documented in the provided foreign key relationships, OKL_AE_TMPT_SETS is central to the leasing accounting structure. It has direct parent-child relationships with two key transactional tables:

• OKL_AE_TEMPLATES: This table stores the individual accounting templates. The foreign key OKL_AE_TEMPLATES.AES_ID references OKL_AE_TMPT_SETS.ID, establishing that multiple templates belong to a single template set.
• OKL_TRX_CONTRACTS: This table holds lease contract transactions. The foreign key OKL_TRX_CONTRACTS.AES_ID references OKL_AE_TMPT_SETS.ID, linking a specific contract to the accounting rule set that governs its journal entries.

These relationships confirm that the table acts as a hub: it groups detailed templates and is assigned to contracts, thereby controlling the accounting treatment for lease transactions.