Results for “okl_st_gen_templates”

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

Overview

OKL_ST_GEN_TEMPLATES is a table within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It stores stream templates that belong to a stream template set, providing the reusable definitions from which contract streams are generated during lease and finance agreement origination and administration. Streams in OKL represent the scheduled cash flow lines — payments, interest, residuals, fees, and similar financial events — that drive contract accounting and billing. A stream template set groups related templates so that a complete, consistent set of stream generation rules can be applied to a contract or template assignment.

The object is documented as "Not implemented in this database," meaning it is a model or seed definition present in the ETRM reference rather than an active, populated table in the environment from which the metadata was mined. Consultants should verify existence and row counts in the target instance before relying on it for queries or extensions. The heuristic Data Vault classification mined from the foreign key structure is standalone, which suggests modeling this object as an independent hub rather than a satellite or link, since no dependent relationships were detected in the mined metadata.

Key Information Stored

The documented metadata identifies a small set of structurally significant columns:

• ID — Surrogate primary key column, governed by the constraint OKL_ST_GEN_TEMPLATES_PK. This is the internal, system-generated identifier for each stream template record.
• GTS_ID — Business-key column participating in the unique index OKL_ST_GEN_TEMPLATES_U1. It identifies the stream template set (generation template set) to which the row's stream templates belong, establishing the parent grouping context.
• VERSION — Version attribute, also part of the unique index OKL_ST_GEN_TEMPLATES_U1. It supports versioned template definitions, allowing multiple revisions of a template set to coexist without collision on the combination of template set and version.

The unique index defined on GTS_ID and VERSION establishes the business key: a given stream template set may have only one definition per version. The surrogate ID remains the stable internal reference, while GTS_ID plus VERSION provides the meaningful business identity used when referencing or comparing template revisions. Additional descriptive and attribute columns typical of stream template configuration — such as template identifiers, stream type or class references, generation parameters, and audit columns — are expected in the physical table but are not enumerated in the documented metadata and should be confirmed against the data dictionary.

Common Use Cases and Queries

Typical usage centers on template administration and troubleshooting of stream generation. Reporting queries commonly join to the parent template set and to stream type setup tables to list which templates are available for a given set and version:

• Listing all templates for a template set: SELECT id, gts_id, version FROM okl_st_gen_templates WHERE gts_id = :gts_id ORDER BY version;
• Retrieving the current version of a set: SELECT MAX(version) FROM okl_st_gen_templates WHERE gts_id = :gts_id;
• Auditing historical revisions by comparing rows sharing the same GTS_ID across VERSION values.
• Validating uniqueness during data migration or cloning, ensuring no duplicate GTS_ID/VERSION pairs exist.

Because the table is documented as not implemented in the mined database, use cases should be treated as design-intent scenarios. Verification with USER_TAB_COLUMNS and USER_CONSTRAINTS is recommended before authoring production reports.

Related Objects

Based on the documented relationships and OKL stream architecture, the most significant related objects include:

• OKL_ST_GEN_TEMPLATES parent/set definition table, joined via GTS_ID to the template set header.
• Stream type and stream generation setup tables in the OKL module, referenced by templates to determine generated stream characteristics.
• OKL contract and stream tables that consume generated stream templates during contract booking and billing.
• The OKL stream template set entity implied by GTS_ID, which acts as the grouping parent for these template rows.

Join columns are driven by GTS_ID (parent set linkage) and ID (internal references). Because the mined relationship classification is standalone, no enforced foreign keys were detected, so joins should be validated against the actual instance before use in production SQL.