Results for “oks_bill_sub_lines”

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

Overview

OKS_BILL_SUB_LINES is a Service Contracts (OKS) table that stores billing information associated with lower-level contract lines, such as coverage levels or products. It sits beneath the billing contract line layer and provides the granular billing record against which pricing adjustments, transaction lines, sub-line details, and tax details are attached. The object is owned by the OKS schema and is classified as VALID in the ETRM 12.1.1 / 12.2.2 documentation set.

From a modeling perspective, the heuristic Data Vault classification for this table is hub-leaning. The table carries a surrogate primary key and a stable business key, and it is the target of numerous foreign keys from surrounding tables, which is characteristic of a hub or a strongly-referenced core entity rather than a pure satellite. In practice, OKS_BILL_SUB_LINES acts as the anchor point for billing sub-line records across the Service Contracts billing model.

Key Information Stored

The table is documented with 32 columns. The most significant columns are:

• ID — the surrogate primary key, enforced by the OKS_BILL_SUB_LINES_PK constraint and backed by the unique index OKS_BILL_SUB_LINES_U1. This is the single documented business-key candidate.
• BCL_ID — foreign key to OKS_BILL_CONT_LINES, identifying the parent billing contract line to which this sub-line belongs.
• CLE_ID — foreign key to OKC_K_LINES_B, linking the record to the underlying contract line (coverage level or product).
• AVERAGE and AMOUNT — billing monetary values for the sub-line.
• DATE_BILLED_FROM and DATE_BILLED_TO — the billing period boundaries for the sub-line.
• DATE_TO_INTERFACE — indicates the date the record is eligible for transfer to the interface layer.
• MANUAL_CREDIT — flag indicating a manually applied credit on this sub-line.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting Multi-Org / security-based data access.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/BC4J framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS who-columns providing audit lineage.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the flexfield descriptive columns available for customer-specific extensions.

The ID column is the surrogate key; the documented unique index OKS_BILL_SUB_LINES_U1 on ID is the sole business-key candidate listed in the metadata, while the surrounding foreign keys establish the true relational identity of a sub-line.

Common Use Cases and Queries

Typical reporting and integration scenarios include reconciling billed amounts against contract lines, extracting billing periods for revenue recognition, and isolating manual credits for audit review. A representative query joining the sub-line to its parent billing contract line and contract line follows:

SELECT bsl.ID, bsl.BCL_ID, bsl.CLE_ID, bsl.AMOUNT,
       bsl.DATE_BILLED_FROM, bsl.DATE_BILLED_TO, bsl.MANUAL_CREDIT
FROM   OKS.OKS_BILL_SUB_LINES bsl,
       OKS.OKS_BILL_CONT_LINES bcl,
       OKC.OKC_K_LINES_B cle
WHERE  bsl.BCL_ID = bcl.ID
AND    bsl.CLE_ID = cle.ID;

For pricing audit purposes, joining to OKC.OKC_PRICE_ADJUSTMENTS on BSL_ID reveals adjustments applied to each sub-line. Filtering on SECURITY_GROUP_ID supports Multi-Org-restricted reporting, and DATE_TO_INTERFACE is useful when identifying sub-lines pending interface processing.

Related Objects

The following tables are the most significant dependents and parents of OKS_BILL_SUB_LINES:

• OKS_BILL_CONT_LINES — parent billing contract line, joined via OKS_BILL_SUB_LINES.BCL_ID.
• OKC_K_LINES_B — contract line (coverage level or product), joined via OKS_BILL_SUB_LINES.CLE_ID.
• OKS_BILL_SUB_LINE_DTLS — sub-line detail records, joined via BSL_ID (and BSL_ID_AVERAGED for averaged details).
• OKS_BILL_TXN_LINES — billing transaction lines, joined via BSL_ID.
• OKC_PRICE_ADJUSTMENTS / OKC_PRICE_ADJUSTMENTS_H — price adjustment records, joined via BSL_ID.
• OKC_PRICE_ADJ_ASSOCS / OKC_PRICE_ADJ_ASSOCS_H — price adjustment associations, joined via BSL_ID.
• OKL_TXD_AR_LN_DTLS_B — lease/AR tax line details, joined via BSL_ID.
• FND_SECURITY_GROUPS — security group definition, joined via SECURITY_GROUP_ID.