Search Results oks_subscr_header_b




Overview
Explore in AI Chat

Overview

OKS_SUBSCR_HEADER_B is the base table that stores subscription header information within the OKS – Service Contracts module of Oracle E-Business Suite (documented against 12.1.1 and 12.2.2). It resides in the OKS schema and is classified as VALID. The table acts as the parent record for subscription-based service agreements, capturing the defining attributes of a subscription such as its type, the inventory item being subscribed, the fulfillment channel, billing frequency, and processing status. Each row represents a single subscription header that other OKS tables reference to hold patterns, elements, and downstream subscription detail.

Under Data Vault modeling heuristics mined from the foreign key structure, this table is classified as satellite-leaning. This suggests the object behaves primarily as a descriptive satellite holding attribute context around one or more business keys, rather than as a pure hub or an associative link. The classification should be treated as a modeling suggestion, not a structural constraint, because the table also carries relationships to OKC_K_LINES_B and CSI_ITEM_INSTANCES that give it link-like characteristics.

Key Information Stored

The documented physical schema contains 23 columns. The most significant are:

Common Use Cases and Queries

Typical reporting includes identifying active subscriptions by customer contract and item instance, auditing fulfillment channels, and reconciling recurring billing frequency across a portfolio. A typical join retrieves subscription headers alongside their contract lines and item instances:

  • SELECT h.ID, h.SUBSCRIPTION_TYPE, h.STATUS, h.FREQUENCY, c.CLE_ID, i.INSTANCE_ID FROM OKS_SUBSCR_HEADER_B h JOIN OKC_K_LINES_B c ON h.CLE_ID = c.CLE_ID JOIN CSI_ITEM_INSTANCES i ON h.INSTANCE_ID = i.INSTANCE_ID;
  • Filtering by STATUS or FULFILLMENT_CHANNEL to produce operational dashboards on subscription health.
  • Using DNZ_CHR_ID to roll subscriptions up to contract headers for contract-level reporting.
  • Querying the ORIG_SYSTEM_* columns during upgrade validation to confirm source-system mappings.

Related Objects

  • OKC_K_LINES_B – Referenced via OKS_SUBSCR_HEADER_B.CLE_ID; provides the contract line context.
  • CSI_ITEM_INSTANCES – Referenced via OKS_SUBSCR_HEADER_B.INSTANCE_ID; supplies the subscribed item instance.
  • FND_SECURITY_GROUPS – Referenced via OKS_SUBSCR_HEADER_B.SECURITY_GROUP_ID for security partitioning.
  • OKS_SUBSCR_PATTERNS – Child table referencing OKS_SUBSCR_HEADER_B via OSH_ID.
  • OKS_SUBSCR_ELEMENTS – Child table referencing OKS_SUBSCR_HEADER_B via OSH_ID.