Results for “okl_sty_u2”

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

Overview

OKL.OKL_STRM_TYPE_B is the master definition table for stream types in Oracle Lease and Loan Management (OLM), part of the E-Business Suite Enterprise Contracts and asset financing modules. A stream type classifies the economic nature of every cash flow generated or consumed by a contract, expressed through flags and attributes such as ACCRUAL_YN, BILLABLE_YN, FUNDABLE_YN, PERIODIC_YN, and CAPITALIZE_YN. As the documentation excerpt states, it stores payment types and their details; for example, a payment of type RENT could be taxable, billable, fundable, and periodic. The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10 and carries 42 columns in the 12.2.2 physical schema.

From a Data Vault modeling perspective, the mined FK topology classifies this object as a hub: it holds a stable business key (stream type code and purpose) with descriptive attributes, while transactional tables reference it as a foreign key. Practitioners modeling downstream warehouses may therefore treat OKL_STRM_TYPE_B as a reference or hub-style dimension, with satellite-style descriptive attributes separated from the identifier.

Key Information Stored

• ID (NUMBER) — surrogate primary key, enforced by OKL_STRM_TYPE_B_PK; the target of every STY_ID foreign key in dependent tables.
• CODE (VARCHAR2 150) — internal code identifying the stream type; part of the OKL_STY_U2 business-key candidate.
• VERSION (VARCHAR2 24) and STREAM_TYPE_PURPOSE (VARCHAR2 30) — complete the OKL_STY_U2 unique business key, ensuring codes are unique per version and purpose.
• ZD_EDITION_NAME — editioning column present in both OKL_STRM_TYPE_B_U1 and OKL_STY_U2, reflecting the 12.2 online patching architecture.
• CUSTOMIZATION_LEVEL (VARCHAR2 30) — distinguishes seeded (S) from user-defined (U) stream types, essential for upgrade impact analysis.
• STREAM_TYPE_CLASS and STREAM_TYPE_SUBCLASS — classify the stream type (for example FEES, EXPENSE) and drive process behavior.
• ACCRUAL_YN, TAXABLE_DEFAULT_YN, BILLABLE_YN, FUNDABLE_YN, PERIODIC_YN, CAPITALIZE_YN — behavioral flags that govern accrual, taxation defaults, invoicing, funding, and capitalization.
• ALLOCATION_FACTOR (VARCHAR2 30) — allocation basis by which a stream type is allocated from contract to assets.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF framework during updates.
• START_DATE / END_DATE — effective dating of the definition.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield storage.
• CONTINGENCY / CONTINGENCY_ID — contingency linkage referencing AR_DEFERRAL_REASONS.

Nonunique indexes OKL_STRM_TYPE_B_N1 (STREAM_TYPE_PURPOSE) and OKL_STY_IDX1 (STREAM_TYPE_SUBCLASS) support common filtering paths.

Common Use Cases and Queries

Typical reporting and integration scenarios include validating seeded versus user-defined stream types, reconciling cash flows to their payment classifications, and extracting stream type behavior for downstream billing or tax engines.

• Listing user-defined stream types introduced after go-live: SELECT code, version, stream_type_class FROM okl_strm_type_b WHERE customization_level = 'U'.
• Identifying taxable, billable, and periodic stream types for a pricing model review: SELECT code FROM okl_strm_type_b WHERE taxable_default_yn = 'Y' AND billable_yn = 'Y' AND periodic_yn = 'Y'.
• Joining transactions to their definitions, for example SELECT s.sty_id, t.code FROM okl_streams s, okl_strm_type_b t WHERE s.sty_id = t.id, to aggregate balances by stream type.
• Effective-date filtering for point-in-time reporting using START_DATE and END_DATE.

Related Objects

• OKL_STREAMS.STY_ID — the principal transactional consumer, linking generated streams to their type definition.
• OKL_CASH_FLOWS.STY_ID — associates anticipated or actual cash flows with the stream type.
• OKL_AE_TEMPLATES_ALL.STY_ID and OKL_AE_TEMPLATES.STY_ID — accounting entry templates mapped to stream types.
• OKL_QUOTE_LINE_STRM.STY_ID and OKL_QUOTE_LINE_STRM_ALL.STY_ID — quotation line stream assignments.
• OKL_TAX_SOURCES.STY_ID and OKL_TXL_CNTRCT_LNS.STY_ID — tax source and contract-line tax detail references.
• OKL_STRM_TYP_ALLOCS.STY_ID — stream type allocation rules, working with ALLOCATION_FACTOR.
• OKL_SUBSIDIES_B.STREAM_TYPE_ID — subsidy definition linkage.
• OKL_SYSTEM_PARAMS_ALL.TAX_UPFRONT_STY_ID — system-level parameter identifying the upfront tax stream type.
• AR_DEFERRAL_REASONS — referenced through CONTINGENCY_ID.