Search Results okl_ae_tmpt_sets_all




Overview
Explore in AI Chat

Overview

The table OKL_AE_TMPT_SETS_ALL is a core data object within the Oracle E-Business Suite (EBS) module OKL (Leasing and Finance Management). It serves as the master repository for accounting template sets, which are foundational to the financial accounting and revenue recognition processes for lease and finance contracts. These template sets define the accounting rules and journal entry structures that are applied to transactions, ensuring compliance with accounting standards. The table's multi-org structure, indicated by the "_ALL" suffix, allows it to store data for multiple operating units, a critical feature for enterprise deployments.

Key Information Stored

The table stores the definitional attributes of each accounting template set. While the full column list is not detailed in the provided metadata, the documented primary and unique keys highlight the most critical fields. The primary key is the ID column, a unique system-generated identifier for each template set record. The unique key constraint (UK1) is a composite key on the NAME and VERSION columns, which together define a specific, versioned instance of an accounting template set. This structure allows for the maintenance of multiple versions of a template set over time, supporting audit trails and changes in accounting policies.

Common Use Cases and Queries

This table is central to configuration and transactional accounting flows. Common operational scenarios include the setup and maintenance of accounting rules for new products or contract types, and the system's selection of the appropriate accounting template during contract booking or revenue recognition. A frequent reporting need is to list all active template sets for an operating unit. A sample query pattern, joining on the standard `ORG_ID` column for security, would be:

  • SELECT NAME, VERSION, ID FROM OKL.OKL_AE_TMPT_SETS_ALL WHERE ORG_ID = :p_org_id ORDER BY NAME;

For troubleshooting, one might query which specific template set is assigned to a product or contract by joining on the foreign key column AES_ID.

Related Objects

OKL_AE_TMPT_SETS_ALL has defined foreign key relationships with other major tables in the OKL schema, as documented. These relationships are crucial for understanding its integration points.

  • OKL_PRODUCTS: The column `OKL_PRODUCTS.AES_ID` references `OKL_AE_TMPT_SETS_ALL.ID`. This links an accounting template set to a specific leasing or financial product, determining the default accounting for contracts created from that product.
  • OKL_TRX_CONTRACTS_ALL: The column `OKL_TRX_CONTRACTS_ALL.AES_ID` references `OKL_AE_TMPT_SETS_ALL.ID`. This links the accounting template set directly to a transaction contract, which may override the product-level default and dictates the precise accounting for that contract's lifecycle events.

These relationships establish the table as a key reference point in the accounting configuration hierarchy, from product definition to individual contract execution.