Search Results ams_dm_bin_values_u1

Overview

AMS.AMS_DM_BIN_VALUES is a table in the AMS (Advanced Marketing / Marketing) schema of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. The object holds the definitions of bins, which are logical groupings or buckets of data source field values used by the marketing data mining and segmentation engine. In the marketing analysis model, a bin represents a discrete segment of a subject attribute, such as an age range, an income band, or a category code, and this table is the repository in which those bucket definitions are persisted for later use in campaign targeting, profiling, and analytic queries.

The table is registered in FND Design Data as AMS.AMS_DM_BIN_VALUES and is marked VALID. Its physical storage resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. The table is owned by the AMS schema, and the row-level identity of each record is established by the column BIN_VALUE_ID, which is enforced by the primary key constraint AMS_DM_BIN_VALUES_PK.

Under a heuristic Data Vault classification, this object leans toward the satellite category. A satellite captures descriptive, time-variant attributes of a parent business key, and AMS_DM_BIN_VALUES attaches descriptive detail (bucket, bin value, numeric start and end values) to a source field, which functions as the parent reference. Treat this classification as a modeling suggestion rather than a normative statement; the ETRM metadata does not declare a formal Data Vault model.

Key Information Stored

Each row in AMS.AMS_DM_BIN_VALUES represents one bin definition belonging to a source field. The most operationally significant columns are:

• BIN_VALUE_ID — the surrogate unique key identifier for the bin. This column is the documented primary key and the subject of the unique index AMS_DM_BIN_VALUES_U1, making it the strongest business-key candidate in the schema.
• SOURCE_FIELD_ID — the data source field for which the bin value is defined. This column is the foreign key to AMS.AMS_LIST_SRC_FIELDS and establishes the parent relationship.
• BUCKET — the bucket to which the bin value belongs. Buckets allow multiple bins to be grouped into a common analytical band.
• BIN_VALUE — a varchar2(120) field that captures a category or code as the bin value, used for discrete or symbolic segmentation.
• START_VALUE and END_VALUE — numeric fields that define the lower and upper bounds of a numeric bucket range. Together they describe continuous ranges where a single code is insufficient.
• SECURITY_GROUP_ID — used in hosted environments and constrained by a foreign key to FND_SECURITY_GROUPS, allowing data isolation across security groups.
• OBJECT_VERSION_NUMBER — used for locking purposes to support concurrent modification control.
• Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — provide audit and change-tracking information.

A non-unique index, AMS_DM_BIN_VALUES_N1, is defined on SOURCE_FIELD_ID to support lookups by parent field. The documented physical schema contains thirteen columns in total.

Common Use Cases and Queries

The primary use case for this table is the maintenance and resolution of bin definitions consumed by the AMS data mining and segmentation processes. When the marketing engine profiles a list of subjects, it resolves each subject's value for a source field against the bin definitions here to determine which bucket the subject falls into. A typical retrieval of all bins for a given source field follows:

• SELECT BIN_VALUE_ID, SOURCE_FIELD_ID, BUCKET, BIN_VALUE, START_VALUE, END_VALUE FROM AMS.AMS_DM_BIN_VALUES WHERE SOURCE_FIELD_ID = :p_source_field_id ORDER BY BUCKET;
• Range-based resolution, for numeric sources, joins on START_VALUE and END_VALUE to place a measured value inside its numeric bucket.
• Discrete resolution, for categorical sources, matches BIN_VALUE against a code or category value.
• Reporting queries commonly join to AMS_LIST_SRC_FIELDS to display the parent field name alongside each bin definition, and filter on SECURITY_GROUP_ID in hosted deployments to restrict output to the appropriate group.
• Bucket distribution reports aggregate counts of bins per BUCKET to validate that segmentation bands are fully covered.

Related Objects

The following objects are most significant in relation to AMS.AMS_DM_BIN_VALUES, based on the documented foreign key and dependency data:

• AMS.AMS_LIST_SRC_FIELDS — the parent table referenced by SOURCE_FIELD_ID. This is the principal join path and defines the field to which bins belong.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; used to partition rows in hosted environments.
• AMS.AMS_DM_BIN_VALUES# — the companion object listed in the dependency section.
• AMS_DM_BIN_VALUES_PK — the primary key constraint on BIN_VALUE_ID.
• AMS_DM_BIN_VALUES_U1 — the unique index on BIN_VALUE_ID in APPS_TS_TX_IDX.
• AMS_DM_BIN_VALUES_N1 — the non-unique index on SOURCE_FIELD_ID.
• APPS.AMS_DM_BIN_VALUES — the APPS synonym by which the table is normally accessed from application code.

Collectively, these relationships establish AMS_DM_BIN_VALUES as a dependent, satellite-style attribute store anchored to source fields within the AMS marketing data model.