Search Results bne_attributes_b

Overview

BNE.BNE_PARAM_GROUP_ITEMS is a transactional detail table within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 ETRM (Enterprise Transaction/Reference Model) schema owned by the BNE product. It stores the ordered collection of parameters that belong to a parameter group, where each group is itself part of a parameter list. The table serves as the linking structure between parameter groups (BNE_PARAM_GROUPS_B), parameter list items (BNE_PARAM_LIST_ITEMS), and parameter definitions (BNE_PARAM_DEFN_B), while also referencing BNE_ATTRIBUTES_B for generic, attribute-based storage of parameter values. This object is central to the BNE parameter framework used by Oracle Application Framework (OAF) regions, personalization, and runtime parameter binding.

From a heuristic Data Vault modeling perspective, this table is best classified as a link entity. Its composite primary key and foreign key structure connect multiple business entities (parameter groups, parameter list items, and application contexts) rather than acting as a standalone hub or descriptive satellite. The presence of standard WHO columns (CREATED_BY, CREATION_DATE, etc.) and OBJECT_VERSION_NUMBER supports the link interpretation with audit and concurrency metadata attached.

Key Information Stored

The table contains 12 documented columns. The most operationally significant are:

• APPLICATION_ID — Numeric foreign key to FND_APPLICATIONS.APPLICATION_ID, identifying the owning application context. This is the leading column of the primary key.
• PARAM_LIST_CODE — VARCHAR2(30) code uniquely identifying the parameter list entity for the given application. Second column of the primary key.
• GROUP_SEQ_NUM — Number identifying the parameter group sequence. Third primary key column, also part of the unique index BNE_PARAM_GROUP_ITEMS_UK1.
• SEQUENCE_NUM — Sequence number of the parameter within the group. Fourth primary key column and part of the unique business key.
• PARAM_SEQ_NUM — Numeric pointer to the underlying parameter definition sequence.
• OBJECT_VERSION_NUMBER — Supports optimistic locking and row versioning for concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording creation and modification history.
• ZD_EDITION_NAME — Editioning column used in EBS 12.2 online patching; also part of the unique index.

The surrogate primary key is BNE_PARAM_GROUP_ITEMS_PK (APPLICATION_ID, PARAM_LIST_CODE, GROUP_SEQ_NUM, SEQUENCE_NUM). The business-key candidate is defined by the unique index BNE_PARAM_GROUP_ITEMS_UK1, which extends the primary key with ZD_EDITION_NAME, reflecting the edition-aware uniqueness required in 12.2.

Common Use Cases and Queries

Typical scenarios include retrieving the ordered parameters for a given parameter list, tracing which parameter definitions are bound to a group, and diagnosing parameter resolution failures during OAF page rendering. A common query pattern joins this table to BNE_PARAM_LIST_ITEMS on APPLICATION_ID and PARAM_LIST_CODE to obtain the item-level context:

• SELECT pgi.APPLICATION_ID, pgi.PARAM_LIST_CODE, pgi.GROUP_SEQ_NUM, pgi.SEQUENCE_NUM, pgi.PARAM_SEQ_NUM FROM BNE.BNE_PARAM_GROUP_ITEMS pgi WHERE pgi.APPLICATION_ID = :app_id AND pgi.PARAM_LIST_CODE = :list_code ORDER BY pgi.GROUP_SEQ_NUM, pgi.SEQUENCE_NUM;
• Joining to BNE_PARAM_GROUPS_B on APPLICATION_ID and PARAM_LIST_CODE to validate group membership and ordering.
• Reporting on parameter usage across applications for personalization audits, using OBJECT_VERSION_NUMBER to detect stale configuration rows.

Because the table is edition-aware (ZD_EDITION_NAME), queries in a 12.2 environment must account for the active edition when filtering, or rely on the editioning view that exposes only the run edition.

Related Objects

The following objects are directly referenced by or depend on BNE_PARAM_GROUP_ITEMS based on the documented foreign keys and primary key relationships:

• BNE.BNE_PARAM_GROUPS_B — Referenced via APPLICATION_ID; provides the group-level definition that owns each item.
• BNE.BNE_PARAM_LIST_ITEMS — Referenced via APPLICATION_ID; supplies the list-level item context and links to the containing parameter list.
• BNE.BNE_PARAM_DEFN_B — Parameter definition base table consulted through PARAM_SEQ_NUM for the actual parameter metadata.
• BNE.BNE_ATTRIBUTES_B — Generic attribute storage referenced for parameter data values, matching the user search term "bne_attributes_b".
• FND. FND_APPLICATIONS — Referenced via APPLICATION_ID for application naming and context.
• FND_USER and FND_LOGINS — Referenced indirectly through the WHO columns (CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN).

These relationships make BNE_PARAM_GROUP_ITEMS a critical junction for parameter resolution, personalization troubleshooting, and BNE configuration reporting across EBS 12.1.1 and 12.2.2 environments.