Search Results oks_bsd_pr




Overview
Explore in AI Chat

Overview

OKS_BSD_PR is a transactional detail table within the Oracle Service Contracts (OKS) module of Oracle E-Business Suite, present in releases 12.1.1 and 12.2.2. The table stores the detail of quantities and monetary amounts, whether regular or adjustment, that underlie service contract billing schedules. Each row captures a measured or computed value — a quantity, reading, or amount — that contributes to a billing schedule line or is applied against another billing schedule detail row. The table resides in the OKS schema and is composed of 43 documented columns, including the standard EBS audit and descriptive flexfield attribute columns.

From a dimensional modeling perspective, the foreign key structure suggests a satellite-leaning classification. The table carries a surrogate primary key (ID) and several self-referencing and cross-referencing foreign keys (BSD_ID, BSD_ID_APPLIED, BSL_ID, BSL_ID_AVERAGED), which is characteristic of a satellite attached to a billing schedule hub or link rather than a standalone hub. This classification is a heuristic derived from the FK graph and should be treated as a modeling suggestion rather than an authoritative Data Vault designation.

Key Information Stored

The table's grain is a single billing schedule detail record. The most significant columns are:

Common Use Cases and Queries

Typical reporting scenarios include reconciling billing schedule amounts, auditing adjustments, and tracing usage readings to invoiced quantities. A common join pattern links details to their schedule lines:

  • Select BSD_ID, BSL_ID, AMOUNT, RESULT from OKS_BSD_PR where BSD_ID equals a supplied schedule detail identifier, ordered by ID.
  • Join OKS_BSD_PR to OKS_BSL_PR on BSL_ID = BSL_ID to report quantities and amounts per billing schedule line.
  • Filter on ADJUSTMENT_LEVEL IS NOT NULL to isolate adjustment rows, and reference BSD_ID_APPLIED to identify the adjusted original detail.
  • Aggregate ESTIMATED_QUANTITY versus ACTUAL across UNIT_OF_MEASURE to compare forecast and realized usage.

Related Objects

  • OKS_BSD_PR — self-referencing via BSD_ID and BSD_ID_APPLIED for parent and applied-adjustment relationships.
  • OKS_BSL_PR — referenced through BSL_ID and BSL_ID_AVERAGED; the billing schedule line parent.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for row-level security.
  • FV_CCR_VENDORS — referenced through CCR_ID for vendor context.
  • OKS_BSD_PR_PK and OKS_BSD_PR_U1 — primary key and unique index enforcing identity on ID.