Search Results bic_measure_buckets

Overview

The BIC_MEASURE_BUCKETS table resides in the BIC (Customer Intelligence) schema, a product line that is now marked obsolete in Oracle EBS 12.1.1 and 12.2.2. Its documented purpose is to store groupings for Loyalty and Satisfaction measures together with their child measures, effectively acting as a classification container that organizes disparate measurement definitions into logical buckets used by the Customer Intelligence analytics stack.

In Data Vault modeling terms, the ETRM heuristic classifies this object as hub-leaning. The table centers on a stable, unique business concept—the bucket—identified by BUCKET_ID. This hub-like posture is reinforced by the many downstream foreign key references from value, summary, and translation tables that all point back to BUCKET_ID. Although the table carries descriptive attributes (name, points, thresholds), its dominant structural role is to serve as the anchor identity for buckets that other satellites and links resolve against.

Key Information Stored

The physical schema documents 13 columns. The most significant are:

BUCKET_ID – Surrogate primary key, defined by the unique index BIC_MEASURE_BUCKETS_PK and additionally protected by unique index BIC_MEASURE_BUCKETS_U1. This column is the business-key candidate and the join anchor for all dependent tables.
MEASURE_ID – Foreign key to BIC_MEASURES_ALL, linking each bucket to the parent measure it classifies (Loyalty or Satisfaction).
BUCKET_NAME – Human-readable label for the bucket, used in reporting and user-facing analytics.
BUCKET_POINTS – Scoring or weighting value assigned to the bucket for aggregation calculations.
LOW_VALUE / HIGH_VALUE – Numeric bounds defining the range that qualifies a measurement for assignment to this bucket.
OPERATOR – Comparison operator used when evaluating whether a measurement falls inside the low/high range.
SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, enabling multi-org / data-security filtering.
LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – Standard EBS WHO-column audit trail.

The surrogate key (BUCKET_ID) is distinct from the measure linkage, and the unique index confirms it as the definitive business identifier.

Common Use Cases and Queries

Typical usage centers on analyzing how customer measurements are bucketed for Loyalty and Satisfaction scoring. A common reporting pattern joins buckets to their parent measures:

Listing all buckets for a given measure: SELECT b.bucket_id, b.bucket_name, b.bucket_points FROM bic_measure_buckets b WHERE b.measure_id = :measure_id;
Range evaluation: querying LOW_VALUE, HIGH_VALUE, and OPERATOR to determine which bucket a score maps to.
Security-filtered extracts using SECURITY_GROUP_ID joined to FND_SECURITY_GROUPS.
Drill-down into bucket values via BIC_BUCKET_VALUES to enumerate individual thresholds.

Because BIC is obsolete, these queries are primarily relevant for historical data migration, archive extraction, or legacy reporting maintained during upgrade projects from 12.1.1 to 12.2.2.

Related Objects

BIC_MEASURES_ALL – Parent measure definitions; joined via BIC_MEASURE_BUCKETS.MEASURE_ID.
BIC_BUCKET_VALUES – Child threshold records; joined via BUCKET_ID.
BIC_CUSTOMER_SUMMARY_ALL – Customer-level rollups referencing BUCKET_ID.
BIC_PARTY_SUMMARY – Party-level summaries keyed by BUCKET_ID.
BIS_BUCKET and BIS_BUCKET_TL – Business Intelligence bucket definitions and translations referencing BUCKET_ID.
BIS_BUCKET_CUSTOMIZATIONS – User customizations of buckets, joined via BUCKET_ID.
FND_SECURITY_GROUPS – Security framework joined via SECURITY_GROUP_ID.

Table: BIC_MEASURE_BUCKETS 12.1.1
owner:BIC, object_type:TABLE, fnd_design_data:BIC.BIC_MEASURE_BUCKETS, object_name:BIC_MEASURE_BUCKETS, status:VALID, product: BIC - Customer Intelligence (obsolete) , description: This table will store groups for Loyalty, Satisfaction and their child measures , implementation_dba_data: BIC.BIC_MEASURE_BUCKETS ,
Table: BIC_MEASURE_BUCKETS 12.2.2
owner:BIC, object_type:TABLE, fnd_design_data:BIC.BIC_MEASURE_BUCKETS, object_name:BIC_MEASURE_BUCKETS, status:VALID, product: BIC - Customer Intelligence(Obsolete) , description: This table will store groups for Loyalty, Satisfaction and their child measures , implementation_dba_data: BIC.BIC_MEASURE_BUCKETS ,
Table: BIC_BUCKET_VALUES 12.2.2
product: BIC - Customer Intelligence(Obsolete) , description: Values are specified for groups belonging to measures which have lov_flag as ?Y? , implementation_dba_data: Not implemented in this database ,
Table: BIC_BUCKET_VALUES 12.1.1
product: BIC - Customer Intelligence (obsolete) , description: Values are specified for groups belonging to measures which have lov_flag as ?Y? , implementation_dba_data: Not implemented in this database ,
VIEW: BIC.BIC_MEASURE_BUCKETS# 12.2.2
owner:BIC, object_type:VIEW, object_name:BIC_MEASURE_BUCKETS#, status:VALID,
VIEW: BIC.BIC_MEASURE_BUCKETS# 12.2.2
SYNONYM: APPS.BIC_MEASURE_BUCKETS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BIC_MEASURE_BUCKETS, status:VALID,
SYNONYM: APPS.BIC_MEASURE_BUCKETS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:BIC_MEASURE_BUCKETS, status:VALID,
eTRM - BIC Tables and Views 12.2.2
description: This table stores industry standard values for satisfaction ,
eTRM - BIC Tables and Views 12.1.1
description: This table stores industry standard values for satisfaction ,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
Table: BIC_MEASURES_ALL 12.1.1
owner:BIC, object_type:TABLE, fnd_design_data:BIC.BIC_MEASURES_ALL, object_name:BIC_MEASURES_ALL, status:VALID, product: BIC - Customer Intelligence (obsolete) , description: The list of measures will be seeded , implementation_dba_data: BIC.BIC_MEASURES_ALL ,
12.2.2 FND Design Data 12.2.2
12.1.1 FND Design Data 12.1.1
Table: BIC_MEASURES_ALL 12.2.2
owner:BIC, object_type:TABLE, fnd_design_data:BIC.BIC_MEASURES_ALL, object_name:BIC_MEASURES_ALL, status:VALID, product: BIC - Customer Intelligence(Obsolete) , description: The list of measures will be seeded , implementation_dba_data: BIC.BIC_MEASURES_ALL ,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
TABLE: BIC.BIC_MEASURE_BUCKETS 12.1.1
owner:BIC, object_type:TABLE, fnd_design_data:BIC.BIC_MEASURE_BUCKETS, object_name:BIC_MEASURE_BUCKETS, status:VALID,
TABLE: BIC.BIC_MEASURE_BUCKETS 12.2.2
owner:BIC, object_type:TABLE, fnd_design_data:BIC.BIC_MEASURE_BUCKETS, object_name:BIC_MEASURE_BUCKETS, status:VALID,
PACKAGE BODY: APPS.BIC_SUMMARY_EXTRACT_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BIC_SUMMARY_EXTRACT_PKG, status:VALID,
PACKAGE BODY: APPS.BIC_SUMMARY_EXTRACT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:BIC_SUMMARY_EXTRACT_PKG, status:VALID,
eTRM - BIC Tables and Views 12.2.2
description: This table stores industry standard values for satisfaction ,
eTRM - BIC Tables and Views 12.1.1
description: This table stores industry standard values for satisfaction ,
APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on BIC_MEASURE_BUCKETS 12.2.2
APPS.BIC_SUMMARY_EXTRACT_PKG SQL Statements 12.2.2
APPS.BIC_SUMMARY_EXTRACT_PKG SQL Statements 12.1.1
APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on BIC_MEASURE_BUCKETS 12.1.1
PACKAGE BODY: APPS.BIC_SUMMARY_EXTRACT_PKG 12.1.1
PACKAGE BODY: APPS.BIC_SUMMARY_EXTRACT_PKG 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1