Search Results group_seq_num




Overview
Explore in AI Chat

Overview

BNE_PARAM_GROUP_ITEMS is a table owned by the BNE schema (Web Applications Desktop Integrator) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definition of the individual parameter items that belong to each parameter group within a parameter list. In practical terms, it is the intersection-level detail table that maps a parameter-list item (from BNE_PARAM_LIST_ITEMS) into a specific ordered position inside a parameter group (from BNE_PARAM_GROUPS_B). This makes it the mechanism by which Web ADI controls how parameter values are grouped, ordered, and presented when a user launches a BNE-integrated concurrent program or layout.

From a Data Vault modeling perspective (heuristic classification mined from the documented FK structure), this table is best characterized as a link entity. It resolves a many-to-many association between parameter groups and parameter list items, carrying its own sequence attributes. It is not purely a hub (it is not a standalone business concept) and it carries only sequencing and audit attributes rather than descriptive history, so it is not modeled as a satellite.

Key Information Stored

The table carries 12 documented columns. The composite primary key is defined by BNE_PARAM_GROUP_ITEMS_PK, comprising APPLICATION_ID, PARAM_LIST_CODE, GROUP_SEQ_NUM, and SEQUENCE_NUM. A unique index, BNE_PARAM_GROUP_ITEMS_UK1, extends that key with ZD_EDITION_NAME for edition-based redefinition support in 12.2.2. Because the primary key is composite and fully natural (no surrogate sequence ID appears), the "business key" and the primary key converge on the same set of columns.

  • APPLICATION_ID — Identifies the owning application; part of the PK and of both foreign keys.
  • PARAM_LIST_CODE — The parameter list to which the group and item belong; part of the PK.
  • GROUP_SEQ_NUM — Sequence of the parameter group within the list; the primary join column to BNE_PARAM_GROUPS_B and part of the PK. This is the attribute users search for.
  • SEQUENCE_NUM — Ordering of the individual item within the group; part of the PK.
  • PARAM_SEQ_NUM — Foreign key to the underlying parameter list item in BNE_PARAM_LIST_ITEMS; identifies which parameter is being placed.
  • OBJECT_VERSION_NUMBER — Optimistic concurrency control token maintained by the framework.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO audit columns.
  • ZD_EDITION_NAME — Editioning column supporting online patching in 12.2.2.

Common Use Cases and Queries

Typical scenarios include diagnosing the ordering and grouping of BNE parameters, and reconstructing how a parameter list renders in Web ADI. A frequent query pattern joins items to their group:

  • Locate items for a given group: SELECT SEQUENCE_NUM, PARAM_SEQ_NUM FROM BNE_PARAM_GROUP_ITEMS WHERE APPLICATION_ID = :app AND PARAM_LIST_CODE = :code AND GROUP_SEQ_NUM = :grp ORDER BY SEQUENCE_NUM;
  • Join to resolve the actual parameter: join PARAM_SEQ_NUM to BNE_PARAM_LIST_ITEMS on APPLICATION_ID, PARAM_LIST_CODE, PARAM_SEQ_NUM.
  • Join to the group header: join GROUP_SEQ_NUM to BNE_PARAM_GROUPS_B on APPLICATION_ID, PARAM_LIST_CODE, GROUP_SEQ_NUM.
  • Audit reporting: filter on LAST_UPDATE_DATE to track recent configuration changes.

Because the primary key is natural, searches by GROUP_SEQ_NUM should always be qualified with APPLICATION_ID and PARAM_LIST_CODE to use the BNE_PARAM_GROUP_ITEMS_PK index efficiently rather than triggering a full scan.

Related Objects

  • BNE_PARAM_GROUPS_B — Referenced via APPLICATION_ID, PARAM_LIST_CODE, GROUP_SEQ_NUM; holds the group header.
  • BNE_PARAM_LIST_ITEMS — Referenced via APPLICATION_ID, PARAM_LIST_CODE, PARAM_SEQ_NUM; holds the underlying parameter item definitions.
  • BNE_PARAM_LISTS_B — Parent of the parameter list that groups and items hang from.
  • BNE_PARAM_GROUPS_TL — Translation table for group labels.
  • FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_PROGRAM_PARAMETERS — Related through the BNE parameter framework that Web ADI uses to drive program launches.

These relationships confirm the table's role as a sequencing link between group and item definitions within the BNE Web ADI parameter model.