Search Results oks_subscr_header_v




Overview
Explore in AI Chat

Overview

OKS_SUBSCR_HEADER_V is a VALID database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKS – Service Contracts product family. It exposes subscription header information stored in the Service Contracts transactional schema, presenting a denormalized, language-aware projection of the subscription header entity. A subscription in OKS represents an agreement to deliver recurring goods or services to a customer at a defined cadence, and the header row carries the attributes that govern that cadence: status, frequency, media, item type, fulfillment channel, and offset.

The view is intended for reporting and integration rather than for online transaction processing. Because it joins the base table to its translation table and filters on the session language, it returns a single row per subscription header with the descriptive name, description, and comments resolved in the run-time session language. This makes it safe for concurrent-user queries, BI Publisher reports, OAF page-level lookups, and outbound interface extraction, without requiring the consumer to reimplement the language join or the USERENV('LANG') predicate.

Underlying Base Objects

The view is defined over two documented base objects, each exposed in the APPS schema as a synonym:

  • OKS_SUBSCR_HEADER_B — the subscription header base table, holding the language-independent columns: ID, subscription type, item type, media type, status, frequency, fulfillment channel, offset, the CLE_ID and DNZ_CHR_ID foreign keys, INSTANCE_ID, and the standard WHO audit columns plus OBJECT_VERSION_NUMBER.
  • OKS_SUBSCR_HEADER_TL — the translation table for the subscription header, supplying NAME, DESCRIPTION, COMMENTS, and the SFWT_FLAG (the "seed/feature" indicator pattern used across EBS translation tables) for each installed language.

The join is a simple equijoin on ID (SCHB.ID = SCHT.ID) combined with the language restriction SCHT.LANGUAGE = USERENV('LANG'). This is the canonical EBS _V view pattern: a "_B" base table supplying transactional keys and a "_TL" table supplying translated content. Because the join is inner, a header must have a translation row in the current language for the view to return it.

Key Columns

  • ROW_ID — the ROWID of the OKS_SUBSCR_HEADER_B row, useful for direct-row operations.
  • ID — the primary key of the subscription header, common to both base objects.
  • NAME / DESCRIPTION / COMMENTS — translated attributes resolved through OKS_SUBSCR_HEADER_TL.
  • SUBSCRIPTION_TYPE — the specific attribute referenced in the user's search; it classifies the subscription (for example, a new subscription, a renewal, or a change to an existing subscription) and drives downstream processing logic.
  • ITEM_TYPE / MEDIA_TYPE — the classification of the item being subscribed and the delivery medium.
  • STATUS — the current lifecycle state of the subscription header.
  • FREQUENCY / OFFSET / FULFILLMENT_CHANNEL — scheduling and delivery controls that determine when and how each subscription period is fulfilled.
  • CLE_ID / DNZ_CHR_ID / INSTANCE_ID — foreign keys that anchor the subscription to an entitlement, a source contract line, or an inventory instance.
  • SFWT_FLAG — the translated-table flag column propagated from OKS_SUBSCR_HEADER_TL.
  • OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard concurrency and audit columns.

Common Use Cases and Queries

The view is commonly used to list subscriptions by type, to reconcile renewal versus original subscriptions, to drive fulfillment extracts, and to feed analytics on subscription mix by media or channel. A typical query filtering on the searched attribute is:

  • SELECT id, name, subscription_type, status, frequency FROM oks_subscr_header_v WHERE subscription_type = :p_type;
  • SELECT subscription_type, status, COUNT(*) FROM oks_subscr_header_v GROUP BY subscription_type, status;
  • SELECT h.id, h.name, h.fulfillment_channel, h.offset FROM oks_subscr_header_v h WHERE h.last_update_date >= :p_since;

Consumers should remain aware that, as with all _TL-based views, results are language-dependent; a run-time session with no matching translation row will not see the header.