Search Results okl_strm_typ_allocs




Overview
Explore in AI Chat

Overview

OKL_STRM_TYP_ALLOCS is a transactional configuration table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. Its documented purpose is to describe the priority or sequence in which insufficient cash is applied across stream types. In lease and finance contracts, a single receipt or disbursement may not satisfy every scheduled stream obligation in full; this table supplies the ordered allocation rules that the allocation engine consults so that partial cash is distributed deterministically rather than arbitrarily across the streams defined on a contract.

The table resides in the OKL schema and is owned by the Lease and Finance Management product. Its heuristic Data Vault classification is link, meaning it is best modeled as an associative relationship joining two business entities — a category and a stream type — rather than as a standalone hub or a descriptive satellite. It carries a small set of descriptive columns alongside its foreign keys, but its defining role is to resolve the many-to-many association between allocation categories and stream types, ordered by an explicit sequence.

Key Information Stored

The table is physically documented with 28 columns. The most significant are:

  • ID — the surrogate primary key, enforced by OKL_STRM_TYP_ALLOCS_PK and backed by the unique index OKL_STRM_TYP_ALLOCS_U1. It uniquely identifies each allocation rule row.
  • CAT_ID — foreign key referencing an allocation category; part of the composite business key.
  • STY_ID — foreign key referencing OKL_STRM_TYPE_B, identifying the stream type to which cash is allocated.
  • STREAM_ALLC_TYPE — the allocation type qualifier, distinguishing the kind of allocation rule being defined.
  • SEQUENCE_NUMBER — the priority or ordering value that determines the sequence in which stream types receive insufficient cash; this is the operative column behind the table’s documented purpose.
  • OBJECT_VERSION_NUMBER — the optimistic locking token used by the framework to detect concurrent updates.
  • ORG_ID — the multi-org operating unit identifier, supporting data segregation across organizations.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns for client-specific extensions.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard audit columns tracking who created and last modified each rule and when.

The business-key candidate is captured by the unique index OKL_STRM_TYP_ALLOCS_U2 on (CAT_ID, STY_ID, STREAM_ALLC_TYPE), which guarantees that a given category and stream type cannot be paired more than once for a given allocation type.

Common Use Cases and Queries

The primary use case is determining allocation priority at runtime. A typical lookup retrieves the ordered stream types for a category:

  • SELECT sty_id, stream_allc_type, sequence_number FROM okl_strm_typ_allocs WHERE cat_id = :p_cat_id ORDER BY sequence_number;
  • Reporting on configured allocation rules joined to stream type descriptions via STY_ID for audit and setup review.
  • Diagnosing why a partial receipt was applied to one stream before another, by inspecting SEQUENCE_NUMBER values.
  • Extracting configuration for migration between instances, filtering by ORG_ID.

Related Objects

  • OKL_STRM_TYPE_B — referenced through STY_ID; supplies the stream type definition that each allocation row points to.
  • OKL_STRM_TYP_ALLOCS self-referencing entries through CAT_ID, relating rows to their allocation category.
  • OKL_STRM_TYP_ALLOCS_PK / _U1 / _U2 — the primary key and unique indexes enforcing identity and business-key integrity.
  • Contract and stream transaction tables in OKL that consume these allocation rules during cash application.