Search Results region_item

Overview

APPS.BIS_CUSTOMIZATION is a database package body that supports the Oracle E-Business Suite personalization and customization framework surrounding the Oracle Business Intelligence System (BIS), the historical predecessor of Oracle Daily Business Intelligence and the Oracle EBS Analytics family of products. Its specific responsibility is to seed and maintain the customization registry that governs how region items — the individual attributes, columns, and nodes rendered inside a region of an EBS page or dashboard — can be personalized by end users. The package operates on the metadata definition layer rather than on transactional data. By inserting rows into AK_CUSTOM_REGISTRY with a customization_level_id of 60 and a custom_level of 'REGION_ITEM', the package declares which personalization properties are legally available at the region item level, ensuring the customization UI exposes a consistent and controlled set of options.

Key Procedures and Functions

• INSERT_CUSTOM_REGISTRY — Idempotent registration routine. It queries AK_CUSTOM_REGISTRY for a fixed set of property names — ATTRIBUTE_LABEL_LONG, NODE_DISPLAY_FLAG, DISPLAY_SEQUENCE, ORDER_DIRECTION, and INITIAL_SORT_SEQUENCE — and tracks which already exist. For any property that is absent, it inserts a corresponding row scoped to the REGION_ITEM customization level (customization_level_id 60). Translatability is set per property, with ATTRIBUTE_LABEL_LONG marked translatable ('Y') and the display and ordering flags marked non-translatable ('N').
• DELETE_REGION_ITEM — Cleanup counterpart that removes region item customization definitions. Together the two routines provide the create-and-remove lifecycle for the region item personalization registry.

Tables Accessed

• AK_CUSTOM_REGISTRY — The central registry of customization levels and their permitted properties. The package reads from it to test for existing definitions and writes to it to seed missing ones.
• AK_REGION_ITEMS — Stores the region item definitions themselves; accessed to identify which region items require registry coverage, particularly during removal processing.
• AK_REGION_ITEMS_TL — The translation table for region items, holding the language-specific display text associated with each item, relevant where translatable properties such as ATTRIBUTE_LABEL_LONG apply.

Usage Notes

The package is classified as OTHER and is referenced by no other packages, indicating it is invoked directly rather than through an API chain. It is typically executed as a one-time or upgrade-time setup step — most commonly from a SQL*Plus session, an installation script, or a concurrent program run by an administrator — to guarantee that the region item customization properties exist before users attempt personalization. Because INSERT_CUSTOM_REGISTRY performs its own existence checks, re-running it is safe and will not create duplicate registry entries. The header revision (120.1, dated 2006) places this code in the EBS 11i/12.0 lineage carried forward unchanged into 12.1.1 and 12.2.2, so behavior is consistent across both releases. The DELETE_REGION_ITEM routine is intended only for deliberate decommissioning of the region item configuration and should not be run during normal operations.