Search Results oks_stream_levels_b




The OKS_STREAM_LEVELS_B table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the Oracle Service Contracts module. It serves as the foundation table for storing billing and revenue recognition schedules associated with service contracts, subscriptions, and entitlements. This table is part of the Oracle Contracts Core schema and is essential for managing complex billing arrangements, including milestone-based, periodic, and usage-based invoicing.

Table Structure and Key Columns

The OKS_STREAM_LEVELS_B table contains the following key columns:
  • ID (Primary Key): Unique identifier for each billing/revenue schedule record.
  • STY_ID: Foreign key linking to OKS_STREAMS_B (parent stream record).
  • LEVEL_NUMBER: Indicates the hierarchical level within a multi-level billing structure.
  • DATE_TYPE: Specifies whether dates are fixed, relative, or based on events.
  • START_DATE and END_DATE: Define the active period for the billing level.
  • AMOUNT: Stores the monetary value for the billing event.
  • GL_DATE: Accounting date for revenue recognition purposes.
  • STATUS_CODE: Tracks the lifecycle state (DRAFT, ACTIVE, CANCELLED).
  • UOM_CODE: Unit of measure for quantity-based billing.

Functional Significance

The table enables several critical business processes:
  1. Multi-level Billing Structures: Supports complex billing hierarchies where parent-child relationships exist between billing events.
  2. Flexible Billing Timing: Through DATE_TYPE and related date columns, it accommodates various billing scenarios:
    • Fixed calendar dates
    • Relative dates (e.g., 30 days after contract start)
    • Event-based triggers (e.g., project milestones)
  3. Revenue Recognition Compliance: The GL_DATE and accounting attributes ensure proper revenue scheduling per ASC 606/IAS 15 standards.
  4. Partial Period Billing: Proration calculations for mid-period starts/terminations.

Integration Points

The table integrates with several EBS modules:
  • Oracle Receivables: Via interface tables for invoice generation
  • General Ledger: For revenue recognition journal entries
  • Advanced Collections: For billing dispute management
  • Order Management: For subscription order fulfillment

Technical Considerations

Key technical aspects include:
  • Indexing Strategy: Heavily indexed on STY_ID, LEVEL_NUMBER, and date fields for performance.
  • Concurrent Processing: The "Generate Billing Events" program reads this table to create billing transactions.
  • Audit Trail: Changes are tracked in OKS_STREAM_LEVELS_H for compliance.
  • Table Size: Can grow significantly for organizations with recurring billing models.

Customization Considerations

Common extension scenarios include:
  • Adding custom columns for industry-specific billing attributes
  • Creating database triggers for complex validation rules
  • Developing custom reports using the table's data structure
The OKS_STREAM_LEVELS_B table exemplifies Oracle's flexible approach to contract billing management, providing both out-of-the-box functionality and extensibility for complex billing scenarios in service-oriented businesses.