Search Results oks_bill_sub_line_dtls




Overview
Explore in AI Chat

Overview

The OKS_BILL_SUB_LINE_DTLS table is a core data object within the Oracle E-Business Suite Service Contracts (OKS) module, specifically in versions 12.1.1 and 12.2.2. It functions as a detailed transaction ledger for billing line items, capturing granular financial and quantitative data. Its primary role is to store the detailed breakdown of quantities and monetary amounts associated with service contract billing, supporting both regular charges and subsequent adjustments. This table is essential for the accurate calculation, tracking, and auditing of revenue and billing amounts throughout the contract lifecycle, enabling detailed reconciliation and financial reporting.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's description and foreign key relationships indicate it stores transactional detail records linked to billing sub-lines. Based on its function, critical data points typically include a unique identifier (ID, serving as the primary key), references to the parent billing sub-line (BSL_ID), and the applied or averaged detail record (BSD_ID_APPLIED, BSL_ID_AVERAGED). It holds the core transactional figures such as quantity billed, unit price, extended amount, tax amounts, and adjustment amounts. The presence of self-referencing foreign keys (BSD_ID_APPLIED, BSD_ID) strongly suggests the table is designed to track adjustment chains, where one detail record can modify or reverse another, maintaining a complete audit trail.

Common Use Cases and Queries

This table is central to billing analysis and reconciliation processes. Common use cases include drilling down from a summarized invoice line to understand its component charges, auditing adjustment histories, and generating detailed revenue reports. For instance, to analyze all billing details for a specific contract line, a query would join from the contract header down to this detail table. A critical reporting pattern involves using the self-referencing keys to trace adjustment lineages, such as identifying all original charges that have been subsequently credited. Sample SQL often involves aggregating amounts from OKS_BILL_SUB_LINE_DTLS grouped by contract, product, or period to support financial accruals and management reporting.

Related Objects

The OKS_BILL_SUB_LINE_DTLS table maintains integral relationships with other Service Contracts billing tables, as documented by its foreign keys.

  • OKS_BILL_SUB_LINES (via BSL_ID): This is the primary parent relationship. Each detail record is a child of a specific billing sub-line in this table.
  • OKS_BILL_SUB_LINES (via BSL_ID_AVERAGED): Links to a billing sub-line record that may have been used for averaging calculations, indicating a relationship for prorated or averaged billing scenarios.
  • OKS_BILL_SUB_LINE_DTLS (Self-Reference via BSD_ID_APPLIED and BSD_ID): These self-referencing foreign keys create a hierarchical relationship within the same table. A detail record (identified by BSD_ID) can be applied to or adjust another detail record (identified by BSD_ID_APPLIED), forming a chain for tracking adjustments, corrections, and reversals.