Search Results bis_bucket_pvt




Overview
Explore in AI Chat

Overview

The APPS.BIS_BUCKET_PVT package body is the private implementation unit of the BIS (Business Intelligence System) Bucket API, delivered as part of the Oracle E-Business Suite application foundation. Its primary business function is to manage the definition, validation, translation, and maintenance of "buckets" — configurable numeric or range-based groupings used throughout Oracle EBS reporting and dashboard components to categorize transactions, measures, or dimensional values for analytical display. The package serves as the internal engine behind the public BIS_BUCKET_PUB API, encapsulating the low-level logic that the public layer exposes to callers. Because it resides in the APPS schema and is classified as a PVT (private) package, it is not intended for direct invocation by external or custom code but is instead called by its public counterpart, forms-based region components, and ETRM/Oracle BI components that render bucket-driven analytics.

Key Procedures and Functions

The package exposes 22 documented procedures and functions organized around maintenance, validation, and retrieval of bucket definitions:

Tables Accessed

The package reads and writes the core bucket repository tables BIS_BUCKET, its translation table BIS_BUCKET_TL, and its secure public synonym views BIS_BUCKET_VL and BIS_BUCKET_S. Customization data is maintained in BIS_BUCKET_CUSTOMIZATIONS, BIS_BUCKET_CUSTOMIZATIONS_TL, and their associated sequence and view objects. It references AK_REGION_ITEMS to associate buckets with specific region items on analytical pages, and reads FND_APPLICATION, FND_LANGUAGES, FND_LOOKUP_TYPES, and FND_LOOKUP_VALUES for application and language validation. Utility and diagnostic support is provided through DBMS_UTILITY, DUAL, and PLITBLM.

Usage Notes

BIS_BUCKET_PVT is not called directly from custom code; it is invoked internally by BIS_BUCKET_PUB and related public APIs. Typical invocation paths include Oracle EBS forms that maintain bucket definitions, concurrent programs that populate or refresh bucket range data, and the BI/analytics components that consume bucket ranges at report runtime. Because the package is classified PVT and is not referenced by other database objects outside its own public sibling, customizations should target BIS_BUCKET_PUB or the underlying tables through supported APIs rather than calling this package directly, preserving the integrity of validation, error handling, and translation logic.