Search Results ahm_subscribed_items




Overview
Explore in AI Chat

Overview

AHM_SUBSCRIBED_ITEMS is a table belonging to the AHM – Hosting Manager product family within Oracle E-Business Suite, a module now classified as obsolete. The table records the detailed online service selections made by parties, specifically organizations, that subscribe to hosted offerings. Its documented purpose is to capture, at the item level, which services a given party has elected, providing the granular breakdown beneath the service subscription header. In the Oracle EBS 12.1.1 and 12.2.2 release context, this object belongs to a legacy hosting and subscription management area that predates more modern service-provisioning frameworks.

The ETRM metadata explicitly notes that the object is "Not implemented in this database." This indicates that in the reference environment from which the documentation was extracted, the table is absent, consistent with the obsolete status of the Hosting Manager product. Implementations that still carry AHM data from earlier upgrades should treat the table as historical rather than transactional. Applying a heuristic Data Vault classification derived from the documented foreign-key topology—one foreign key toward AHM_SUBSCRIBED_SVCS—the object models as satellite-leaning, since it holds descriptive detail subordinate to a parent subscription entity rather than acting as a pure hub or link.

Key Information Stored

The documented metadata identifies a small, focused column set. The most important attributes are:

  • SUBSCRIBED_ITEM_ID – The surrogate primary key, enforced through the AHM_SUB_ITEM_PK constraint. Uniquely identifies each subscribed service line.
  • SUBSCRIBED_SVC_ID – Foreign key referencing AHM_SUBSCRIBED_SVCS, tying each item to its parent subscription record.

Beyond these, the table's description indicates it stores party (organization) online service selection detail, implying columns identifying the subscribed item itself and the owning organization. Because the metadata excerpt is limited, no unique business-key indexes beyond the primary key are documented, and no additional named columns are confirmed. The surrogate key should not be conflated with business keys; in AHM-style designs the business identity is typically anchored in the parent service subscription combined with the item identity.

Common Use Cases and Queries

The table supports reporting on which organizations have selected specific hosted services. Typical patterns join items to their parent subscription:

  • Service selection by organization: Query items grouped by organization to report subscription composition.
  • Gap analysis: Identify organizations lacking items under a service subscription.
  • Historical auditing: Trace legacy hosting entitlements during migration or decommissioning.

A representative pattern follows the documented FK:

SELECT svc.subscribed_svc_id, itm.subscribed_item_id
FROM ahm_subscribed_svcs svc, ahm_subscribed_items itm
WHERE svc.subscribed_svc_id = itm.subscribed_svc_id;

Because the object is not implemented, queries against it will fail unless the legacy schema persists. Always verify existence via ALL_TABLES before relying on it.

Related Objects

The most significant related object is the parent table documented through the foreign key:

  • AHM_SUBSCRIBED_SVCS – Referenced via AHM_SUBSCRIBED_ITEMS.SUBSCRIBED_SVC_ID; the subscription header to which each item belongs.

Other AHM-family objects—service definitions, party/organization tables (for example, HZ_PARTIES in the trading community model), and hosting manager setup tables—are conceptually related, though the provided metadata documents only the AHM_SUBSCRIBED_SVCS relationship explicitly. Given the obsolete status, no active APIs or concurrent programs are documented as depending on this table.