Search Results ams_dm_party_details_time




Overview
Explore in AI Chat

Overview

AMS_DM_PARTY_DETAILS_TIME is a staging table owned by the AMS schema within the Oracle E-Business Suite Marketing (AMS) module. It functions as a container for time-based, generic party details and holds derived attribute rows that correspond to records in AMS_DM_DRV_STG. The table is populated and consumed by the mining collection pack, which is the component of Oracle Marketing responsible for building and refreshing customer intelligence used by segmentation, list generation, and campaign targeting.

As a staging table, AMS_DM_PARTY_DETAILS_TIME is not a transactional source of truth. It is a transient landing area where computed party-level metrics are assembled before being promoted into downstream mining models or data marts. In the 12.2.2 documented schema the table contains 92 columns, and in 12.1.1 the same structure is present; only the file system or online patching mechanics differ between the two releases, not the table definition. Each row is keyed to a single party.

Applying Data Vault classification heuristics to the documented foreign key structure yields a satellite-leaning classification. The table is anchored by PARTY_ID, which references the parent party dimension, and it carries descriptive, time-windowed measures rather than acting as a hub or a many-to-many link. This suggests the object is best modeled as a satellite attached to a party hub, with SECURITY_GROUP_ID providing the multi-tenant or operating-unit discriminator.

Key Information Stored

The table stores party-level behavioral and interaction metrics. The most operationally significant columns include:

Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER, LAST_UPDATE_LOGIN) are present, consistent with OAF/BC4J-managed staging objects.

Common Use Cases and Queries

The primary use case is scoring and prioritization of parties for target lists. A typical query selects high-value, recently inactive parties:

Because this is a staging artifact, reports should join to AMS_DM_PARTY_DETAILS for stable descriptive attributes rather than treating measures here as permanently retained history.

Related Objects

  • AMS_DM_PARTY_DETAILS — parent table; join on AMS_DM_PARTY_DETAILS_TIME.PARTY_ID = AMS_DM_PARTY_DETAILS.PARTY_ID.
  • AMS_DM_DRV_STG — the driving staging table whose rows these details describe.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for access control.
  • AMS_DM_PARTY_DETAILS_TIME_PK / _U1 — primary key and unique indexes enforcing single-row-per-party.
  • Mining collection pack concurrent programs — the processes that populate and consume this table.