Search Results okl_strm_typ_allocs_u2

Overview

OKL.OKL_STRM_TYP_ALLOCS is a transaction-data table in the Oracle Lease and Finance Management (OKL) schema of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It records the allocation rules that determine how insufficient or underpaid cash receipts are distributed across stream types. The table expresses two complementary behaviors: the priority or sequence in which receipt payments are applied to stream types in a defined order of transaction types, and the group of stream types over which an underpayment is prorated. It therefore acts as the configuration backbone for cash application logic within the contracts and billing stream processing flow.

From a Data Vault modeling perspective, the mined FK structure suggests classifying this object as a link. It associates an allocation rule (OKL_CASH_ALLCTN_RLS) with a stream type (OKL_STRM_TYPE_B) and carries a type discriminator plus an ordering attribute, which is characteristic of a relationship table rather than a descriptive hub or satellite.

Key Information Stored

The table holds 28 documented columns. The most significant are:

• ID — surrogate primary key, enforced by unique index OKL_STRM_TYP_ALLOCS_U1 and constraint OKL_STRM_TYP_ALLOCS_PK.
• CAT_ID — foreign key to OKL_CASH_ALLCTN_RLS, identifying the parent cash allocation rule.
• STY_ID — foreign key to OKL_STRM_TYPE_B, identifying the stream type within the rule.
• STREAM_ALLC_TYPE — a VARCHAR2(10) discriminator denoting the stream allocation type (for example, ordered application versus proration grouping).
• SEQUENCE_NUMBER — drives the priority/order in which receipt payments are applied to the selected stream types.
• OBJECT_VERSION_NUMBER — optimistic locking column used to detect concurrent updates.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield (DFF) columns for customer-defined extensions.
• ORG_ID — multi-org operating unit context.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

The business-key candidate is the composite unique index OKL_STRM_TYP_ALLOCS_U2 over (CAT_ID, STY_ID, STREAM_ALLC_TYPE), which guarantees that a given stream type appears at most once per allocation rule and allocation type. A nonunique index, STA_STY_FK_I, supports lookups by STY_ID.

Common Use Cases and Queries

Typical usage centers on diagnosing why a receipt was applied against a particular stream type, or reordering the application priority. A representative query retrieves the ordered rules for a given allocation rule:

• SELECT a.sequence_number, t.sty_name, a.stream_allc_type FROM okl_strm_typ_allocs a, okl_strm_type_b t WHERE a.sty_id = t.sty_id AND a.cat_id = :p_cat_id ORDER BY a.sequence_number;
• Identify all stream types participating in a proration group for underpayments by filtering on stream_allc_type and joining to OKL_CASH_ALLCTN_RLS.
• Report on flexfield attributes (ATTRIBUTE1–ATTRIBUTE15) where clients have configured extensions.
• Audit changes via last_updated_by and last_update_date for compliance reporting.

Because SEQUENCE_NUMBER defines application priority, reporting queries frequently sort on it to visualize the cash application order.

Related Objects

• OKL.OKL_CASH_ALLCTN_RLS — parent rule referenced by CAT_ID.
• OKL.OKL_STRM_TYPE_B — stream type definition referenced by STY_ID.
• OKL.OKL_STRM_TYP_ALLOCS primary key and unique indexes (OKL_STRM_TYP_ALLOCS_PK, U1, U2).
• Cash application and receipt processing logic within the OKL streams module, which reads this table at runtime.
• Contract and billing stream tables that consume the resulting allocation decisions.