Search Results oks_stream_levels_b




Overview
Explore in AI Chat

Overview

The OKS_STREAM_LEVELS_B table is a core data object within the Oracle Service Contracts (OKS) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It stores the billing stream level definitions that govern how service contract revenue and invoices are scheduled, staggered, and offset across defined periods. Each row represents a discrete billing level associated with a contract line or contract header, capturing the period structure, unit of measure, advance periods, and monetary amounts that drive the contract's billing stream generation. This table is central to the Service Contracts billing engine, which uses these level definitions to determine when charges should be interfaced to receivables and how installment amounts should be distributed.

The heuristic Data Vault classification mined from the foreign key structure identifies this table as standalone. From a modeling perspective, this suggests the table behaves as an independent hub-like entity rather than a dependent satellite or an associative link, since it carries its own surrogate key and does not derive its identity from a composite parent reference in the documented FK set.

Key Information Stored

The table contains 29 documented columns. The most significant for functional and reporting purposes include:

Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, OBJECT_VERSION_NUMBER) are also present and support concurrency control and audit reporting.

Common Use Cases and Queries

Typical use cases include reconciliation of billing schedules, verification of installment amounts, and auditing of offset configurations before interface to Oracle Receivables. A common query pattern joins the level to the contract header and line:

  • Retrieve all levels for a contract: SELECT * FROM OKS.OKS_STREAM_LEVELS_B WHERE CHR_ID = :p_chr_id ORDER BY SEQUENCE_NO
  • Summarize scheduled amounts per contract line: SELECT CLE_ID, SUM(LEVEL_AMOUNT) FROM OKS.OKS_STREAM_LEVELS_B GROUP BY CLE_ID
  • Audit security partitioning: SELECT SECURITY_GROUP_ID, COUNT(*) FROM OKS.OKS_STREAM_LEVELS_B GROUP BY SECURITY_GROUP_ID
  • Trace integration origin: filter on ORIG_SYSTEM_SOURCE_CODE to identify records sourced from external systems.

Related Objects

The documented foreign key relationship ties SECURITY_GROUP_ID to FND_SECURITY_GROUPS, which governs data access. Functionally, the table is most significant in relation to:

  • OKS_STREAM_LEVELS_TL — the translation table holding language-specific descriptive text for the same levels.
  • OKS_CONTRACTS / OKS_K_HEADERS_B — contract header tables referenced through CHR_ID and DNZ_CHR_ID.
  • OKS_K_LINES_B — contract lines referenced through CLE_ID.
  • FND_SECURITY_GROUPS — enforces security group partitioning via SECURITY_GROUP_ID.
  • OKS_BILLING_SCHEDULES and Service Contracts billing APIs — consume level definitions to generate billing streams and interface to Receivables.

These relationships make OKS_STREAM_LEVELS_B a foundational table for Service Contracts billing configuration and downstream revenue scheduling.