Results for “okl_ae_tmpt_sets_v”

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

Overview

OKL_AE_TMPT_SETS_V is a reporting and integration view owned by the APPS schema within the OKL – Leasing and Finance Management product family (Oracle E-Business Suite Release 12.1.1 and 12.2.2). It exposes accounting template sets, the reusable definitions that govern how the ETRM accounting engine derives accounting events and generates journal entries for lease and finance contracts. Each row represents a single versioned template set, joined to the associated stream generation template and to the operating unit that owns it.

Because the view is defined over the transactional base table plus descriptive lookups, it provides a denormalized, read-only projection suitable for reporting, extracts, and downstream integration. Consumers do not need to resolve foreign keys to stream templates or operating units themselves; the view resolves these and returns human-readable names alongside the surrogate identifiers. The view is documented as VALID and is part of the standard ETRM data model delivered under the OKL application.

Underlying Base Objects

The view text confirms a three-object join:

• OKL_AE_TMPT_SETS (referenced through the synonym) — the primary accounting template set table, aliased AESB. It supplies the identity, versioning, lifecycle dates, and audit columns.
• OKL_ST_GEN_TMPT_SETS_ALL — the stream generation template set table, aliased GTS. It is joined on AESB.GTS_ID = GTS.ID (+), an outer join, and contributes the STREAM_TEMPLATE descriptive name.
• HR_OPERATING_UNITS — an APPS view over the operating unit definitions, aliased OU. It is joined on AESB.ORG_ID = OU.ORGANIZATION_ID and contributes the OPERATING_UNIT name.

The view is therefore an inner join between the template set table and operating units, with stream templates supplied optionally. Template sets referencing an inactive or missing stream template remain visible, but STREAM_TEMPLATE returns null for those rows.

Key Columns

• ROW_ID — the ROWID of the underlying OKL_AE_TMPT_SETS row; useful for high-volume extracts and for correlating back to the base record.
• ID — the primary surrogate key of the accounting template set.
• OBJECT_VERSION_NUMBER — optimistic locking version, incremented on each update.
• NAME / DESCRIPTION — the user-defined identifier and narrative for the template set.
• VERSION — the template set version, supporting versioned accounting configurations.
• START_DATE / END_DATE — the effective date range during which the template set applies.
• GTS_ID — foreign key to the stream generation template set.
• STREAM_TEMPLATE — the resolved name of the associated stream generation template.
• ORG_ID / OPERATING_UNIT — the owning organization identifier and its resolved name.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include auditing which accounting templates are active per operating unit, validating that every template set references a stream template, and driving integration extracts that require friendly names rather than numeric IDs.

List active template sets for an operating unit:

• SELECT name, version, stream_template, start_date, end_date FROM okl_ae_tmpt_sets_v WHERE operating_unit = :p_ou AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, TRUNC(SYSDATE)) ORDER BY name, version;

Identify template sets missing a stream template (the outer-join nulls):

• SELECT id, name, org_id FROM okl_ae_tmpt_sets_v WHERE stream_template IS NULL;

Correlate a specific template set back to its base row and owner:

• SELECT id, name, version, gts_id, org_id, operating_unit FROM okl_ae_tmpt_sets_v WHERE id = :p_tmpt_set_id;

Because the view is read-only and carries no INSTEAD-OF triggers, all maintenance must be performed against the underlying base tables through the supported ETRM forms or APIs rather than through the view itself.