Search Results ahm_subscription_items_map




Overview
Explore in AI Chat

Overview

AHM_SUBSCRIPTION_ITEMS_MAP is a mapping, or association, table within the AHM (Hosting Manager) product family of Oracle E-Business Suite. The AHM module is documented as obsolete in the ETRM repository. The table associates Subscription Items with Online Services. The documented cardinality is restrictive in one direction and permissive in the other: a Subscription Item can belong to only one Online Service, whereas a single Online Service can have many unique Subscription Items mapped to it. This one-to-many pattern defines the operational semantics of the table and explains why the mapping is modeled as a distinct entity rather than as a column on a subscription item record.

The ETRM metadata flags this object as not implemented in the reference database, which is consistent with the obsolete status of AHM. The table nonetheless remains referenced in historical schemas, upgrade paths, and archived customizations. From a heuristic Data Vault modeling perspective, the metadata classifies the table as hub-leaning. Its reliance on a single surrogate primary key, together with multiple downstream foreign key dependents, supports treating it as a durable identity hub for the Subscription Item–Online Service association rather than as a pure descriptive satellite.

Key Information Stored

The ETRM excerpt documents a limited column set; the principal columns are as follows.

  • SUBSCRIPTION_ITEM_MAP_ID — The surrogate primary key, enforced by the AHM_SUB_ITEM_M_PK constraint. This identifier is the stable handle for each Subscription Item–Online Service association and is the column propagated to dependent exclusion-map tables.
  • HOSTED_SVC_ID — The foreign key column pointing to the Online Service side of the association. It is the documented foreign key reference for the relationship between the mapping record and the hosted service entity, and functions as the business-key candidate that identifies which Online Service a Subscription Item is attached to.

The metadata does not document additional descriptive attributes for this table, reflecting its narrow role as a pure association entity rather than a descriptive satellite. No unique business-key index beyond the surrogate primary key is documented in the excerpt provided, so HOSTED_SVC_ID should be treated as a business-key candidate within the composite association but not asserted as uniquely constrained.

Common Use Cases and Queries

The principal use case is resolving which Online Services a given Subscription Item is attached to, and conversely enumerating all Subscription Items belonging to a Hosted Service. A typical reporting query joining the mapping to its dependent exclusion tables would resemble the following pattern:

  • SELECT m.SUBSCRIPTION_ITEM_MAP_ID, m.HOSTED_SVC_ID FROM AHM_SUBSCRIPTION_ITEMS_MAP m WHERE m.HOSTED_SVC_ID = :hosted_service_id; — returns all Subscription Items mapped to a specific Online Service, supporting entitlement and provisioning reports.
  • SELECT f.SUBSCRIPTION_ITEM_MAP_ID FROM AHM_FUNCTION_EXCLUSION_MAP f JOIN AHM_SUBSCRIPTION_ITEMS_MAP m ON f.SUBSCRIPTION_ITEM_MAP_ID = m.SUBSCRIPTION_ITEM_MAP_ID WHERE m.HOSTED_SVC_ID = :hosted_service_id; — identifies function-level exclusions applied to the mapped Subscription Items.
  • Equivalent joins against AHM_MENU_EXCLUSION_MAP and AHM_RESP_EXCLUSION_MAP support menu and responsibility exclusion audits for hosted, online-service-based subscription offerings.

Because AHM is obsolete, these patterns are most commonly encountered during migration discovery, legacy data archival, and upgrade impact analysis rather than in current production reporting.

Related Objects

The relationship data identifies AHM_SUBSCRIPTION_ITEMS_MAP as a parent to three exclusion-map tables and as a child of the hosted service entity.

  • AHM_FUNCTION_EXCLUSION_MAP — References AHM_SUBSCRIPTION_ITEMS_MAP via SUBSCRIPTION_ITEM_MAP_ID; records function-level exclusions tied to each Subscription Item mapping.
  • AHM_MENU_EXCLUSION_MAP — References AHM_SUBSCRIPTION_ITEMS_MAP via SUBSCRIPTION_ITEM_MAP_ID; records menu-level exclusions.
  • AHM_RESP_EXCLUSION_MAP — References AHM_SUBSCRIPTION_ITEMS_MAP via SUBSCRIPTION_ITEM_MAP_ID; records responsibility-level exclusions.
  • AHM_SUBSCRIPTION_ITEMS_MAP.HOSTED_SVC_ID — Declared as a foreign key against the hosted or online service entity, establishing the parent side of the one-to-many relationship documented in the table description.

Together these objects form the exclusion and mapping backbone of the AHM subscription-to-online-service model.