Results for “oks_bill_cont_lines”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKS_BILL_CONT_LINES is a transactional table in the OKS (Service Contracts) module of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. It stores the contract line records that are prepared and forwarded to Oracle Receivables (AR) for invoicing, forming the bridge between the contract authoring structures held in OKC and the billing transaction staging tables within OKS. Each row represents a billable contract line instance associated with a billing transaction header, carrying the billed period, the amount, and the settlement and processing state at the time of transfer.

The table also underpins a range of dependent artefacts: sub-line detail, transaction-line records, pricing adjustments and their associations, and the transaction detail rows consumed by Oracle Leasing. This breadth of downstream dependency means the table is both a billing source of truth and a distribution hub for pricing and AR detail.

From a Data Vault modelling perspective, the mined foreign-key structure suggests a hub-leaning classification: OKS_BILL_CONT_LINES is referenced by seven dependent tables (as a parent of BCL_ID relationships) while itself holding a small number of outbound references. It behaves as a central business entity or hub, with surrounding structures supplying descriptive and transactional context.

Key Information Stored

The documented physical schema comprises 35 columns. The most operationally significant are:

• ID — surrogate primary key, defined by OKS_BILL_CONT_LINES_PK and also enforced by unique index OKS_BILL_CONT_LINES_U1; this is the internal row identifier and the column targeted by all child BCL_ID references.
• CLE_ID — foreign key to OKC_K_LINES_B, identifying the underlying contract line that is being billed.
• BTN_ID — foreign key to OKS_BILL_TRANSACTIONS, the billing transaction header under which the line was raised.
• DATE_BILLED_FROM and DATE_BILLED_TO — the service period for which the line is billed.
• AMOUNT — the billable value passed to Receivables.
• BILL_ACTION — the action applied to the line during the billing run.
• DATE_NEXT_INVOICE — the next scheduled invoice date for the line.
• SENT_YN — indicates whether the record has been transmitted to AR.
• CURRENCY_CODE — the currency of the billed amount.
• AVERAGED_YN — flag indicating whether an averaging method was applied to the line amount.
• SETTLED_YN — settlement state of the billed line.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-tenant and reporting security partitioning.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the PL/SQL and OAF-based APIs.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard DFF extension block used by implementations.

Common Use Cases and Queries

The dominant use case is reconciliation of contract billing to Receivables: identifying lines that have not yet been transmitted, or explaining an invoice back to its originating contract line.

• Unbilled lines pending AR transmission: select BCL.ID, BCL.CLE_ID, BCL.AMOUNT, BCL.CURRENCY_CODE from OKS.OKS_BILL_CONT_LINES BCL where BCL.SENT_YN = 'N';
• Billing history by contract line: join BCL.CLE_ID to OKC_K_LINES_B to list every billed period for a contract line, ordering by DATE_BILLED_FROM.
• Transaction roll-up: group by BCL.BTN_ID to total amounts per billing transaction header, joined to OKS_BILL_TRANSACTIONS.
• Pricing adjustment audit: join to OKC_PRICE_ADJUSTMENTS and OKC_PRICE_ADJ_ASSOCS on BCL_ID to verify adjustments applied to a billed line.
• Settlement and averaging reporting: filter on SETTLED_YN and AVERAGED_YN to analyse revenue treatment.

Queries should consistently include SECURITY_GROUP_ID predicates where reporting security is enforced.

Related Objects

• OKS_BILL_TRANSACTIONS — parent billing transaction header, joined via OKS_BILL_CONT_LINES.BTN_ID.
• OKC_K_LINES_B — contract line definition, joined via OKS_BILL_CONT_LINES.CLE_ID.
• OKS_BILL_SUB_LINES — sub-line detail, referencing OKS_BILL_CONT_LINES.BCL_ID.
• OKS_BILL_TXN_LINES — billing transaction lines, referencing BCL_ID.
• OKC_PRICE_ADJUSTMENTS and OKC_PRICE_ADJ_ASSOCS — pricing adjustment definitions and associations, referencing BCL_ID.
• OKC_PRICE_ADJUSTMENTS_H and OKC_PRICE_ADJ_ASSOCS_H — historical versions of the same adjustment records, also referencing BCL_ID.
• OKL_TXD_AR_LN_DTLS_B — leasing transaction detail records feeding AR lines, referencing BCL_ID.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for organisational security.