Results for “okl_st_gen_tmpt_sets_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_ST_GEN_TMPT_SETS_ALL is a transactional configuration table within the Oracle E-Business Suite (EBS) Leasing and Finance Management module (OKL). As its description states, the table holds stream template sets. A stream template set defines a reusable collection of stream generation rules that determine how cash flows, payment schedules, and revenue streams are produced for leases and financing contracts. The template set acts as a governing container that drives downstream stream generation logic, ensuring consistent treatment of interest calculation, revenue recognition, and payment timing across contracts that share the same commercial profile.

The object resides in the OKL schema and is valid in both EBS 12.1.1 and 12.2.2. In the EBS 12.2.2 online patching architecture, OKL objects are editioned and accessed through the editions-based redefinition (EBR) framework, so the physical table name remains stable while editions are managed transparently. The columns OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN confirm standard EBS concurrency control and audit handling are in force. From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone, which suggests it can be treated as a hub-like reference entity without mandatory parent foreign key dependencies. In practice it functions as a configuration reference table whose rows are consumed by downstream stream generation processes.

Key Information Stored

The table carries 19 documented columns. The most significant are:

• ID — the surrogate primary key, enforced by OKL_ST_GEN_TMPT_SETS_ALL_PK and additionally by unique index OKL_ST_GEN_TMPT_SETS_ALL_U2. This is the internal identifier referenced by child processes.
• NAME and ORG_ID — the composite business key, enforced by OKL_ST_GEN_TMPT_SETS_ALL_U1 and OKL_ST_GEN_TMPT_SETS_ALL_UK1. NAME is the user-visible template set name, and ORG_ID scopes the row to a specific operating unit, making the set available only within that organization.
• PRODUCT_TYPE and DEAL_TYPE — categorize which leasing or finance product and deal structure the template set applies to, enabling selective application during stream generation.
• TAX_OWNER and PRICING_ENGINE — identify the responsible tax entity and the pricing engine configuration used to compute rates and charges.
• INTEREST_CALC_METH_CODE, REVENUE_RECOG_METH_CODE, DAYS_IN_MONTH_CODE, and DAYS_IN_YR_CODE — control the calculation methodology for interest accrual, revenue recognition, day-count conventions for months, and day-count conventions for years respectively.
• ISG_ARREARS_PAY_DATES_OPTION — governs how arrears payment dates are derived within the generated stream.
• DESCRIPTION — free-text annotation for administrative clarity.

Common Use Cases and Queries

Typical reporting scenarios include retrieving all template sets for a given operating unit, identifying which sets apply to a particular product or deal type, and auditing calculation methodology assignments for compliance reviews.

• List template sets for an operating unit:

  SELECT id, name, description, product_type, deal_type
FROM okl_st_gen_tmpt_sets_all
WHERE org_id = :p_org_id
ORDER BY name;

• Locate a set by business key:

  SELECT * FROM okl_st_gen_tmpt_sets_all
WHERE name = :p_name AND org_id = :p_org_id;

• Audit methodology assignments:

  SELECT name, interest_calc_meth_code, revenue_recog_meth_code,
days_in_month_code, days_in_yr_code
FROM okl_st_gen_tmpt_sets_all
WHERE org_id = :p_org_id;

Because ORG_ID is part of the unique business key, multi-org secured queries should always filter by the active operating unit to avoid cross-organization leakage in custom reports.

Related Objects

The metadata documents this object as standalone, meaning no foreign key relationships were mined from its structure. Consequently, relationships to other OKL objects are established logically rather than through declared constraints. The following objects are commonly associated:

• OKL_ST_GEN_TMPTS_ALL — the stream generation template entity that consumes a template set; the set ID referenced from stream template rows links back to OKL_ST_GEN_TMPT_SETS_ALL.ID.
• OKL_STREAMS_ALL — generated streams that inherit calculation and day-count conventions from the template set applied to their contract.
• OKL_TRX_CONTRACTS_ALL — lease and finance contracts whose stream generation is governed by the applicable template set.
• OKL_PRICING_PARAMETERS — pricing configuration consulted alongside PRICING_ENGINE during rate determination.
• FND_LOOKUPS — validation source for coded columns such as INTEREST_CALC_METH_CODE and REVENUE_RECOG_METH_CODE.
• HR_OPERATING_UNITS — resolves ORG_ID to the operating unit name for reporting.