Search Results bis_bucket_s

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:

• CREATE_BIS_BUCKET_WRAPPER, UPDATE_BIS_BUCKET_WRAPPER, DELETE_BIS_BUCKET_WRAPPER, RETRIEVE_BIS_BUCKET_WRAPPER, VALIDATE_BUCKET_WRAPPER — wrapper routines that provide an API-layer envelope around the core bucket operations, handling standardized error handling, message propagation, and parameter normalization before delegating to the underlying procedures.
• CREATE_BIS_BUCKET, UPDATE_BIS_BUCKET, DELETE_BIS_BUCKET, RETRIEVE_BIS_BUCKET — the core CRUD operations that insert, modify, remove, and fetch bucket definition records.
• UPDATE_CUST_BUCKET and RESET_BUCKET — manage customer-specific bucket customizations and reset bucket definitions to their default or baseline state.
• TRANSLATE_BUCKET — handles multilingual bucket descriptions by populating the translatable (_TL) columns.
• IS_BUCKET_TYPE_EXISTS and IS_VALID_APPLICATION_ID — boolean-returning utility functions that verify the existence of a bucket type and validate an application identifier against FND_APPLICATION.
• VALIDATE_BUCKET, VALIDATE_BUCKET_OVERLAPPING, VALIDATE_BUCKET_DISCONTINUOUS, VALIDATE_FROM_TO — validation logic ensuring that bucket ranges are well-formed, do not overlap, are not discontinuous where continuity is required, and that from/to boundaries are logically consistent.
• GET_REPORT_LISTS and POPULATE_LOC_BUCKET_RANGE_TBL — retrieval helpers that assemble bucket range tables used in report rendering and localization scenarios.

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.