Search Results bne_param_groups_b




Overview
Explore in AI Chat

Overview

BNE_PARAM_GROUPS_B is a core configuration table within the BNE (Web Applications Desktop Integrator) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definition of a group of parameters, functioning as the parent container that organizes related parameters into a logical grouping for use by the desktop integrator framework. Parameter groups defined here drive the layout, sequencing, and resolution behavior of parameters presented to end users during Web ADI integrations and related BNE-driven processes.

From a data-modeling perspective, the heuristic Data Vault classification for this object is satellite-leaning. It carries descriptive attributes (such as the attribute reference and group resolver) that hang off the more stable business-key structures represented by BNE_PARAM_LISTS_B and BNE_ATTRIBUTES. This classification should be treated as a modeling suggestion rather than a definitive architectural mandate, since the table also owns a composite primary key that behaves as a business key in its own right.

Key Information Stored

BNE_PARAM_GROUPS_B is defined with 13 documented columns. The most significant are:

  • PARAM_LIST_CODE — Identifier of the parent parameter list to which this group belongs. This is part of the primary key.
  • APPLICATION_ID — The application owning the parameter list. Also part of the primary key and a foreign key to BNE_PARAM_LISTS_B.
  • SEQUENCE_NUM — Ordering value establishing the position of the group within the parameter list. Completes the primary key.
  • ATTRIBUTE_CODE — Reference to the attribute associated with this group; foreign key to BNE_ATTRIBUTES.
  • ATTRIBUTE_APP_ID — Application identifier of the referenced attribute, completing the composite foreign key to BNE_ATTRIBUTES.
  • GROUP_RESOLVER — Logic or resolver designation controlling how the group is resolved at runtime.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the framework to detect concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.
  • ZD_EDITION_NAME — Editioning column supporting Oracle EBS 12.2 online patching (Edition-Based Redefinition).

The surrogate primary key is BNE_PARAM_GROUPS_B_PK on (PARAM_LIST_CODE, APPLICATION_ID, SEQUENCE_NUM). A unique index, BNE_PARAM_GROUPS_B_UK1, exists on (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, ZD_EDITION_NAME) and serves as the business-key candidate, extending the PK with the edition name to support 12.2 editioning.

Common Use Cases and Queries

This table is typically queried to enumerate the parameter groups configured for a given parameter list, to inspect the ordering and resolver assignment, or to reconcile configuration across editions. A representative query joining to the parent list:

SELECT pg.param_list_code,
       pg.application_id,
       pg.sequence_num,
       pg.attribute_code,
       pg.group_resolver
FROM   bne.bne_param_groups_b pg
WHERE  pg.param_list_code = :p_list_code
AND    pg.application_id  = :p_app_id
ORDER  BY pg.sequence_num;

Reporting scenarios include auditing parameter group definitions before an upgrade, validating that every group references a valid attribute via BNE_ATTRIBUTES, and tracing which items are produced by a group through BNE_PARAM_GROUP_ITEMS. Resolution logic driven by GROUP_RESOLVER is often extracted to understand dynamic behavior at runtime.

Related Objects

  • BNE_PARAM_LISTS_B — Parent table; joined on APPLICATION_ID and PARAM_LIST_CODE.
  • BNE_ATTRIBUTES — Referenced attribute; joined on ATTRIBUTE_CODE and ATTRIBUTE_APP_ID.
  • BNE_PARAM_GROUP_ITEMS — Child table; joins on APPLICATION_ID, PARAM_LIST_CODE, and GROUP_SEQ_NUM, listing the individual items within each group.
  • BNE_PARAM_GROUPS_TL — Translation table for group descriptions, where present in the BNE schema.
  • BNE_PARAM_LISTS_TL — Translation companion to the parent parameter list.

Together these objects form the parameter configuration hierarchy that underpins Web ADI and BNE-driven desktop integration behavior in EBS 12.1.1 and 12.2.2.