Search Results bis_bucket_customizations_u1

Overview

BIS.BIS_BUCKET_CUSTOMIZATIONS is a customization table within the Oracle E-Business Suite Business Intelligence System (BIS) schema. It stores user-defined bucket range definitions that override or supplement the default bucket boundaries maintained in the BIC_MEASURE_BUCKETS table. Buckets in BIS are numeric intervals used to group and classify measures — for example, aging bands, value ranges, or distribution intervals — so that BI dashboards, analytics, and reports can aggregate data into meaningful categories.

Because bucket boundaries may need to vary by user, responsibility, operating unit, application, site, page, or function, this table provides a resolution matrix that allows different audiences to view the same underlying measure grouped into different ranges. The table resides in the APPS_TS_TX_DATA tablespace and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. From a Data Vault modeling perspective, the table is heuristically classified as standalone; it functions as a reference or configuration entity rather than a transactional hub, link, or satellite. Its character is closer to a customizable reference satellite, since it modifies the interpretation of an existing dimension (the bucket) rather than recording business events.

Key Information Stored

Each row represents one customized bucket set for a specific resolution context. The significant columns include:

• ID — Surrogate primary key for the customization record.
• BUCKET_ID — Foreign key to BIC_MEASURE_BUCKETS, identifying which bucket definition is being customized.
• USER_ID, RESPONSIBILITY_ID, ORG_ID, APPLICATION_ID, SITE_ID, PAGE_ID, FUNCTION_ID — The resolution key columns. Together with BUCKET_ID these form the business-key candidate BIS_BUCKET_CUSTOMIZATIONS_U1, a unique index. This composite key determines the context in which the customization applies, allowing the same bucket to be overridden differently per user, responsibility, or organizational scope.
• RANGE1_LOW through RANGE10_HIGH — Twenty numeric columns defining the low and high boundaries of up to ten custom buckets. These override the default ranges for reporting and analytics.
• CUSTOMIZED — Flag indicating whether the row is an active customization.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include administering bucket thresholds, auditing which customizations exist for a given responsibility, and troubleshooting why a report groups values unexpectedly. A representative query retrieves all customizations for a bucket and responsibility:

• SELECT * FROM bis.bis_bucket_customizations WHERE bucket_id = :p_bucket_id AND responsibility_id = :p_resp_id;
• Reporting on coverage of customizations: SELECT bucket_id, COUNT(*) FROM bis.bis_bucket_customizations WHERE customized = 'Y' GROUP BY bucket_id;
• Joining to the base bucket definition: SELECT c.id, b.bucket_name, c.range1_low, c.range1_high FROM bis.bis_bucket_customizations c, bic_measure_buckets b WHERE c.bucket_id = b.bucket_id AND c.org_id = :p_org_id;

Related Objects

The most significant related object is BIC_MEASURE_BUCKETS, referenced through the documented foreign key BUCKET_ID → BIC_MEASURE_BUCKETS. This parent table defines the default bucket definitions that the customization rows override. Other relevant dependencies include the standard FND WHO columns (populated via FND_STANDARD), the FND_USER and FND_RESPONSIBILITY tables implied by the USER_ID and RESPONSIBILITY_ID columns, and the BIS reporting views and concurrent programs that read bucketed measures at runtime. Because the table is standalone, no child tables reference it directly; its influence is expressed through the reporting layer that resolves bucket ranges at query execution time.