Search Results oks_subscr_header_b_pk

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:

• ID – Surrogate primary key, enforced by OKS_SUBSCR_HEADER_B_PK. Also the single column of the unique index OKS_SUBSCR_HEADER_B_U1, making it the only documented business-key candidate.
• CLE_ID – Foreign key to OKC_K_LINES_B, tying the subscription header to a contract line.
• DNZ_CHR_ID – Contract header reference linking the subscription to its parent contract.
• INSTANCE_ID – Foreign key to CSI_ITEM_INSTANCES, identifying the specific item instance placed under subscription.
• SUBSCRIPTION_TYPE – Classifies the nature of the subscription.
• ITEM_TYPE and MEDIA_TYPE – Describe the subscribed item and the media or delivery form.
• STATUS – Tracks the lifecycle state of the subscription header.
• FREQUENCY – Defines the recurring cadence for billing or delivery.
• FULFILLMENT_CHANNEL – Identifies the channel through which the subscription is fulfilled.
• OFFSET – Supports scheduling or timing adjustments relative to a baseline period.
• OBJECT_VERSION_NUMBER – Optimistic locking column used by the OKS framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS who-columns for audit and concurrency.
• SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS supporting multi-org or data-security partitioning.
• UPG_ORIG_SYSTEM_REF, UPG_ORIG_SYSTEM_REF_ID, ORIG_SYSTEM_ID1, ORIG_SYSTEM_REFERENCE1, ORIG_SYSTEM_SOURCE_CODE – Upgrade and legacy-system provenance columns used to trace migrated subscription records back to their originating systems.

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.