Search Results bne_param_list_items




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BNE_PARAM_LIST_ITEMS is a Web Applications Desktop Integrator (BNE) configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the individual parameter items that make up a parameter list. Where a parameter list defines an ordered grouping of parameters, each row in this table represents one parameter within that list, including its sequence, the parameter definition it resolves to, and an optional constant default value. The table is owned by the BNE schema and is documented as VALID in the ETRM metadata.

From a data-modeling perspective, the mined structure suggests a satellite-leaning classification. The table carries descriptive and value attributes (parameter name, attribute reference, default values) attached to a parent parameter list identifier, rather than acting as an independent hub of business entities or a pure associative link. This classification is a heuristic suggestion mined from the foreign key structure, not an authoritative Data Vault design assertion.

Key Information Stored

The primary key is defined by the constraint BNE_PARAM_LIST_ITEMS_PK over three columns:

  • APPLICATION_ID – identifies the owning application, the leading key component.
  • PARAM_LIST_CODE – the parameter list to which this item belongs, tying the row to the parent list.
  • SEQUENCE_NUM – the ordinal position of the item within the list, defining parameter ordering.

A unique index, BNE_PARAM_LIST_ITEMS_UK1 (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, ZD_EDITION_NAME), extends the primary key with the ZD_EDITION_NAME column, indicating an editioning or versioning dimension. This is a business-key candidate for tools that key on the natural identifier plus edition rather than the surrogate composite key.

The remaining columns hold the substantive content:

Common Use Cases and Queries

Typical reporting and diagnostic scenarios include auditing which parameters belong to a given list and their default values, tracing how a parameter item resolves to its attribute definition, and reviewing the ordering of parameters presented to the user.

SELECT pli.param_list_code,
       pli.sequence_num,
       pli.param_name,
       pli.param_defn_code,
       pli.attribute_code,
       pli.string_value,
       pli.formula_value
FROM   bne.bne_param_list_items pli
WHERE  pli.application_id  = :app_id
AND    pli.param_list_code = :list_code
ORDER  BY pli.sequence_num;

Joining to BNE_ATTRIBUTES resolves the attribute metadata behind each parameter item, which is useful when validating that defaults match the declared attribute data type. Because the table is edition-aware, queries against 12.2.2 environments should consider ZD_EDITION_NAME to avoid returning rows from an inactive edition.

Related Objects

  • BNE_ATTRIBUTES – referenced via ATTRIBUTE_CODE and ATTRIBUTE_APP_ID; supplies the attribute definition for each parameter item.
  • BNE_PARAM_GROUP_ITEMS – references this table through APPLICATION_ID, PARAM_LIST_CODE, and PARAM_SEQ_NUM, forming the parent-to-child relationship by which a group item resolves to a specific parameter item.
  • The parameter definition reference – the PARAM_DEFN_APP_ID and PARAM_DEFN_CODE columns resolve to the parameter definition entity documented in the metadata as a referenced foreign key.
  • The owning application reference – APPLICATION_ID participates both as a primary key component and as a foreign reference, linking each item to its application context.

Because the table is an internal BNE configuration object, it is typically accessed through the Desktop Integrator setup forms and APIs rather than modified directly. Direct DML should be avoided in favor of supported configuration paths.