Search Results oks_bill_txn_lines




Overview
Explore in AI Chat

Overview

The OKS_BILL_TXN_LINES table is a core transactional data store within the Oracle E-Business Suite Service Contracts (OKS) module. Its primary role is to capture the final, audited financial details for individual billing lines after they have been processed by the Accounts Receivable (AR) application. This table acts as the system of record for the actual revenue and tax amounts that are ultimately recognized, serving as a critical link between the contractual billing schedules defined in Service Contracts and the finalized invoices in the financial subledger.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's description and foreign key relationships define its essential data elements. It holds the actual transaction amounts and tax figures returned from AR for a specific billing line. The primary key is the ID column. Crucially, it stores foreign key references to its parent objects: BCL_ID links to the OKS_BILL_CONT_LINES table (contract billing line), BSL_ID links to the OKS_BILL_SUB_LINES table (subscription billing line), and BTN_ID links to the header-level OKS_BILL_TRANSACTIONS table. This structure allows it to store the finalized financial outcome for different line types within a broader billing transaction.

Common Use Cases and Queries

This table is central to reconciliation and revenue reporting. A common use case involves verifying that the amounts billed in Service Contracts match the amounts invoiced in AR. Analysts query this table to report on actual revenue by contract, line type, or period. Troubleshooting discrepancies between the contract module and financial statements also frequently involves examining records in OKS_BILL_TXN_LINES. A typical reporting query would join this table to its parent billing line and transaction headers to retrieve a full audit trail.

SELECT btn.transaction_number,
       bcl.line_number,
       txln.actual_amount,
       txln.tax_amount
FROM oks_bill_txn_lines txln,
     oks_bill_cont_lines bcl,
     oks_bill_transactions btn
WHERE txln.bcl_id = bcl.id
AND txln.btn_id = btn.id
AND btn.creation_date >= :p_start_date;

Related Objects

The table maintains documented foreign key relationships with three key parent tables in the OKS billing schema:

  • OKS_BILL_CONT_LINES: Linked via the BCL_ID column. This relationship ties the actual transaction amounts back to the specific contractual billing line from a service contract.
  • OKS_BILL_SUB_LINES: Linked via the BSL_ID column. This relationship ties the actual transaction amounts back to a subscription billing line.
  • OKS_BILL_TRANSACTIONS: Linked via the BTN_ID column. This relationship rolls up all transaction lines to their parent billing transaction header.

These relationships are essential for navigating from a high-level billing transaction down to the detailed, AR-finalized amounts for each component line.