Search Results update_bis_bucket

Overview

BIS_BUCKET_PUB is the public API package for the Oracle E-Business Suite "BIS" (Business Intelligence System / Balanced Scorecard) bucket framework. Buckets represent the user-defined groupings used by BIS to organize, aggregate, and display performance indicators, scorecards, and analytic data. The package body provides the externally callable, standardized entry points through which forms, concurrent programs, and custom PL/SQL code create, modify, remove, retrieve, and load bucket definitions, together with their translated (multi-language) content.

The package follows the standard Oracle EBS Public API architecture. Each procedure in BIS_BUCKET_PUB is a thin validation-and-delegation wrapper that transfers the caller's record structure and outs to the corresponding worker procedure in the private package BIS_BUCKET_PVT. Error handling is centralized: when an unexpected exception is raised, the wrapper sets the return status to FND_API.G_RET_STS_UNEXP_ERROR and calls BIS_UTILITIES_PVT.ADD_ERROR_MESSAGE, passing SQLCODE, SQLERRM, and the fully qualified procedure name (G_PKG_NAME concatenated with the procedure) so the failure is captured in the standard error table structure BIS_UTILITIES_PUB.ERROR_TBL_TYPE. This conforms to the EBS API error-handling and message-stack conventions used across the ETRM module family.

Key Procedures and Functions

The package exposes six documented procedures:

• CREATE_BIS_BUCKET — Inserts a new bucket definition. Accepts a BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE record and delegates to BIS_BUCKET_PVT.CREATE_BIS_BUCKET, returning a standard return status and error table.
• UPDATE_BIS_BUCKET — Modifies an existing bucket definition. Accepts the same record type and delegates to BIS_BUCKET_PVT.UPDATE_BIS_BUCKET.
• DELETE_BIS_BUCKET — Removes a bucket. The documented wrapper passes a bucket identifier (P_BUCKET_ID) to BIS_BUCKET_PVT.DELETE_BIS_BUCKET; it is the procedure most commonly referenced in customization and cleanup scripts.
• RETRIEVE_BIS_BUCKET — Returns bucket definition details to the caller for display or downstream processing.
• LOAD_BIS_BUCKET — Bulk-loads bucket rows, typically from a staging or interface source, supporting data migration and seeding.
• ADD_LANGUAGE — Inserts or maintains translated bucket names and descriptions in the translation table.

Tables Accessed

All table access flows through the private package, but the tables are documented as follows:

• BIS_BUCKET — The base table holding bucket definitions; read, inserted, updated, and deleted by the create, update, delete, retrieve, and load routines.
• BIS_BUCKET_TL — The translation table storing language-specific bucket text; maintained by ADD_LANGUAGE and read during retrieval.
• BIS_BUCKET_CUSTOMIZATIONS — Stores user-specific or customer-specific bucket customizations, preserved and applied independently of the seeded definition.

Usage Notes

BIS_BUCKET_PUB is invoked from BIS setup forms and concurrent programs, and is referenced by 32 other packages within APPS, indicating that bucket maintenance is a shared dependency across scorecard and analytic configuration. Custom code should call only the PUB procedures, never BIS_BUCKET_PVT directly, and must always inspect X_RETURN_STATUS and the returned error table before committing. Because DELETE_BIS_BUCKET is destructive, ensure dependent scorecard objects and customizations are reconciled first. The package is documented for both EBS 12.1.1 and 12.2.2; the underlying business logic is unchanged between releases, though the editioning and synonym configuration of the APPS schema applies as standard in 12.2.2.