Search Results oks_bill_sub_lines




Overview
Explore in AI Chat

Overview

The OKS_BILL_SUB_LINES table is a core data object within the Oracle E-Business Suite (EBS) Service Contracts module (OKS). It functions as a transactional repository for billing information associated with lower-level, or "child," contract lines. Specifically, it stores billing details for components such as coverage levels or individual products that are subordinate to a main contract line. This table is integral to the billing engine's ability to accurately calculate and generate invoices for complex, multi-level service contracts. Its existence enables granular billing at a detailed level, supporting sophisticated pricing and revenue recognition scenarios within the EBS architecture for versions 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is the ID column, uniquely identifying each billing sub-line record. Its structure is defined by critical foreign key relationships that link it to the broader contract and billing hierarchy. The BCL_ID column establishes a foreign key relationship to the OKS_BILL_CONT_LINES table, connecting the sub-line to its parent billing contract line. The CLE_ID column is a foreign key to OKC_K_LINES_B, which is the base table for contract lines in the Oracle Contracts Core, thereby anchoring the billing sub-line to the specific contractual line item. These relationships are fundamental for tracing billing data back to its source contract and for maintaining data integrity across the billing process.

Common Use Cases and Queries

This table is primarily accessed for detailed billing analysis, audit reporting, and troubleshooting invoice generation. A common reporting use case involves aggregating billing amounts for all sub-lines under a specific service contract or parent line to validate total charges. Technical consultants often query this table to investigate billing discrepancies by joining it to related contract line and header tables. A typical diagnostic SQL pattern might be:

  • SELECT bsl.id, bsl.bcl_id, bsl.cle_id, okl.name contract_line FROM oks_bill_sub_lines bsl JOIN okc_k_lines_b okl ON bsl.cle_id = okl.id WHERE bsl.bcl_id = :parent_billing_line_id;

This query helps map billing sub-lines to their corresponding contractual elements. The table is also central to processes that calculate prorated charges, apply price adjustments, and interface billing data to Oracle Receivables.

Related Objects

The OKS_BILL_SUB_LINES table sits at a nexus of relationships within the Service Contracts schema. As per the provided metadata, it is a parent table to several key transactional entities. The OKS_BILL_SUB_LINE_DTLS table stores further detailed breakdowns, such as averaged billing details, linked via the BSL_ID and BSL_ID_AVERAGED columns. The OKS_BILL_TXN_LINES table references it for billing transaction processing. Crucially, it is referenced by pricing objects like OKC_PRICE_ADJUSTMENTS and OKC_PRICE_ADJ_ASSOCS, which store discount and surcharge information applied at this granular level. Furthermore, its relationship with OKL_TXD_AR_LN_DTLS_B indicates its role in interfacing billing data to the Receivables module for final invoice creation.