Search Results oks_bsd_pr_u1

Overview

OKS.OKS_BSD_PR is a transactional table in the Service Contracts (OKS) schema that stores billing details for usage counter lines. Each row records the amount charged and the detailed quantities billed against a contract sub line for a given billing period. The table is populated by the Service Contracts Main Billing concurrent programs and is intended primarily as a reporting source, enabling custom reports that analyze usage-based billing across service contracts.

From a Data Vault modeling perspective, the mined foreign key structure classifies this object as satellite-leaning. This is a modeling suggestion rather than a physical property: the table carries descriptive, time-stamped billing attributes (amounts, readings, quantities) that naturally accrete around the contract sub line business key rather than serving as an independent hub or as a pure link between entities.

Key Information Stored

The table contains 43 documented columns. The most significant include:

• ID — the surrogate primary key, enforced by the primary key constraint OKS_BSD_PR_PK and the unique index OKS_BSD_PR_U1. This is the only documented unique index and therefore the only business-key candidate of record.
• BSL_ID — identifier of the contract sub line billing record; references OKS_BILL_SUB_LINES.ID (physically OKS_BSL_PR). This is the principal join path to the service contract billing structure.
• RESULT — quantity billed for usage. The value may be Fixed, Actual, Default, Minimum, or Actual + Estimated Quantity.
• AMOUNT — the invoice amount for the period associated with the contract sub line. It is sourced from OKS_LEVEL_ELEMENTS.AMOUNT for most sub lines; for usage lines of type 'Fixed per period', 'Actual by quantity', and 'Actual per period', it is derived by the pricing engine.
• AMCV_YN — flags whether Average Monthly Counter Values (AMCV) estimation was applied to compute the counter quantity for the current billing period.
• UNIT_OF_MEASURE — unit of measure referenced from MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE.
• START_READING, END_READING, BASE_READING — counter readings used to derive usage quantities.
• ESTIMATED_QUANTITY — estimated usage component when AMCV estimation is in effect.
• FIXED, ACTUAL, DEFAULT_DEFAULT — billing quantity components supporting the pricing derivation logic.
• OBJECT_VERSION_NUMBER — optimistic locking counter set to 1 on insert and incremented on update, used by APIs.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.
• SECURITY_GROUP_ID — references FND_SECURITY_GROUPS and supports multi-org data security.
• ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield columns for customer-defined extensions.

Common Use Cases and Queries

Typical scenarios center on usage-based billing reconciliation and reporting. A common query joins billing detail rows to the contract sub line to attribute charges:

SELECT b.ID, b.BSL_ID, b.RESULT, b.AMOUNT, b.AMCV_YN,
       b.START_READING, b.END_READING, b.ESTIMATED_QUANTITY
FROM   OKS.OKS_BSD_PR b
WHERE  b.BSL_ID = :sub_line_id;

Reporting use cases include summarizing billed usage amounts by period, isolating sub lines where AMCV estimation was applied (AMCV_YN = 'Y'), auditing counter readings against billed quantities, and reconciling AMOUNT against the pricing engine output for 'Fixed per period', 'Actual by quantity', and 'Actual per period' usage lines. Because the table exists specifically to support custom reporting, extract queries frequently restrict by CREATION_DATE or LAST_UPDATE_DATE to limit the billing cycle window.

Related Objects

• OKS.OKS_BSL_PR — contract sub line billing table; the primary parent via BSL_ID and the averaged counterpart via BSL_ID_AVERAGED.
• OKS.OKS_BSD_PR — self-referencing join through BSD_ID and BSD_ID_APPLIED, linking billing detail rows to one another.
• OKS.ES_LEVEL_ELEMENTS / OKS_LEVEL_ELEMENTS — source of the AMOUNT value for non-usage-priced sub lines.
• FND.FND_SECURITY_GROUPS — multi-org security context via SECURITY_GROUP_ID.
• FV.FV_CCR_VENDORS — vendor reference through CCR_ID.
• MTL_SYSTEM_ITEMS_B — supplies PRIMARY_UOM_CODE for UNIT_OF_MEASURE.
• Service Contracts Main Billing — the concurrent program that populates this table.