Search Results ams_dm_bin_values




Overview
Explore in AI Chat

Overview

AMS_DM_BIN_VALUES is a table in the AMS (Marketing) schema of Oracle E-Business Suite, present and VALID in both release 12.1.1 and 12.2.2. The table stores the definitions of buckets for data source fields used by Oracle Marketing's data management and list-selection functionality. In practical terms, it defines how continuous or discrete values from a marketing data source field are grouped, or "binned," into named categories. Such bucketing supports segmentation, targeting, and analytical grouping of customer or prospect records without requiring the raw value to be transformed at query time.

The documented description is exact: "Definitions of buckets for data source fields." The table therefore acts as a configuration layer that maps a source field to one or more bucket definitions, each with a starting value, an ending value, and a bin value that identifies or labels the bucket. From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification, meaning the table is best understood as a descriptive, attribute-bearing structure dependent on a parent entity rather than as a central hub or a pure link. This classification is a heuristic suggestion only; the authoritative structure remains the documented relational schema.

Key Information Stored

The table contains 13 documented columns. The primary key is AMS_DM_BIN_VALUES_PK, defined on BIN_VALUE_ID, which is also exposed through the unique index AMS_DM_BIN_VALUES_U1. BIN_VALUE_ID is the surrogate primary key and the unique business-key candidate documented for this table.

Common Use Cases and Queries

The primary use case is resolving which bucket a source field value belongs to during list generation and segmentation. A typical query joins the bucket definitions to their source field:

  • List all buckets for a source field: SELECT BIN_VALUE, START_VALUE, END_VALUE FROM AMS.AMS_DM_BIN_VALUES WHERE SOURCE_FIELD_ID = :id ORDER BY START_VALUE;
  • Resolve a value to a bucket: SELECT BIN_VALUE FROM AMS.AMS_DM_BIN_VALUES WHERE SOURCE_FIELD_ID = :id AND :value BETWEEN START_VALUE AND END_VALUE;
  • Join to the parent source field: SELECT f.FIELD_NAME, b.BIN_VALUE, b.START_VALUE, b.END_VALUE FROM AMS.AMS_DM_BIN_VALUES b, AMS.AMS_LIST_SRC_FIELDS f WHERE b.SOURCE_FIELD_ID = f.SOURCE_FIELD_ID;
  • Security-filtered reporting: add AND SECURITY_GROUP_ID = :org_security_group_id to any query to respect multi-tenant visibility.

Reporting scenarios include auditing bucket configuration for a marketing list, validating that bucket ranges do not overlap or leave gaps, and extracting bucket assignments for downstream analytical models.

Related Objects

The documented foreign-key relationships identify the parent and security dependencies of this table, while the primary key identifies its dependent context.

  • AMS_LIST_SRC_FIELDS — Parent table; joined via AMS_DM_BIN_VALUES.SOURCE_FIELD_ID = AMS_LIST_SRC_FIELDS.SOURCE_FIELD_ID. Defines the data source fields that buckets are built upon.
  • FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID; enforces multi-tenant data security.
  • AMS_DM_BIN_VALUES_PK / AMS_DM_BIN_VALUES_U1 — Primary key constraint and unique index on BIN_VALUE_ID; the authoritative unique identifier for each bucket definition.
  • AMS schema objects that consume bucket definitions — Data management and list-selection components within the AMS Marketing module read these definitions at runtime when segmenting source field values.

Because the table carries no child foreign keys of its own, it functions as a leaf configuration object: it depends on its parent source field and security group, and is referenced indirectly by the marketing processes that resolve source values into meaningful buckets.