Results for “date_next_invoice”

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

Overview

OKS_BCL_PR is a Service Contracts (OKS) module table in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to hold records that are sent to Oracle Receivables (AR). Within the Service Contracts architecture, OKS_BCL_PR sits at the boundary between contract billing activity and downstream AR invoice creation, capturing billing-relevant records derived from contract lines and billing transaction types. The table is owned by the OKS schema and is reported with VALID status in the ETRM 12.2.2 data dictionary.

From a Data Vault modeling perspective, the foreign-key structure is heuristic-classified as satellite-leaning. The table behaves less like a pure hub and more like a descriptive satellite that hangs off contract billing and line identifiers, carrying measurable attributes (amounts, billed date ranges, settlement and averaging flags) alongside audit columns. This classification is a modeling suggestion based on FK topology rather than an enforced design constraint.

Key Information Stored

OKS_BCL_PR contains 35 documented columns. The most significant include:

• ID — surrogate primary key defined by OKS_BCL_PR_PK and also covered by the unique index OKS_BCL_PR_U1, making it the strongest business-key candidate documented.
• CLE_ID — foreign key to OKC_K_LINES_B, tying the record to a specific contract line.
• BTN_ID — foreign key to OKS_BTN_PR, linking the record to the billing transaction type context.
• DATE_BILLED_FROM / DATE_BILLED_TO — the billing service period covered by the record.
• DATE_NEXT_INVOICE — the projected date of the next invoice for the line.
• AMOUNT and CURRENCY_CODE — monetary value and its currency.
• BILL_ACTION — the billing action applied to the record.
• SENT_YN — indicates whether the record has been transmitted to AR.
• AVERAGED_YN and SETTLED_YN — flags for averaging and settlement processing.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS for row-level security.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit and concurrency columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle descriptive flexfield column set.

Common Use Cases and Queries

OKS_BCL_PR is typically queried to reconcile Service Contracts billing output against AR receipts. A common pattern joins OKS_BCL_PR to OKC_K_LINES_B on CLE_ID to resolve the underlying contract line, and filters on SENT_YN to isolate records not yet transferred to AR:

SELECT b.ID, b.CLE_ID, b.AMOUNT, b.CURRENCY_CODE, l.NAME
FROM OKS.OKS_BCL_PR b, OKC.OKC_K_LINES_B l
WHERE b.CLE_ID = l.ID AND b.SENT_YN = 'N';

Financial reporting often aggregates AMOUNT by CURRENCY_CODE and DATE_BILLED_FROM to produce period billing summaries. Reconciliation queries compare SENT_YN = 'Y' records against AR invoice lines to detect discrepancies. Analytics on SETTLED_YN and AVERAGED_YN support contract profitability and accrual reporting. Because SECURITY_GROUP_ID drives multi-org style visibility, operational queries should respect the security group of the requesting responsibility.

Related Objects

• OKS_BSL_PR — references OKS_BCL_PR.BCL_ID; is the parent side of one FK relationship.
• OKS_BTL_PR — references OKS_BCL_PR.BCL_ID; is the parent side of a second FK relationship.
• OKS_BTN_PR — parent of OKS_BCL_PR.BTN_ID, supplying billing transaction type context.
• OKC_K_LINES_B — parent of OKS_BCL_PR.CLE_ID, providing the contract line definition.
• FND_SECURITY_GROUPS — parent of OKS_BCL_PR.SECURITY_GROUP_ID, controlling row visibility.
• Oracle Receivables (AR) — the external consumer of records flagged via SENT_YN.
• OKS_BCL_PR_PK / OKS_BCL_PR_U1 — the primary key constraint and unique index on ID, used for direct lookups.