Search Results bne_param_lists_b_pk

Overview

BNE_PARAM_LISTS_B is a core configuration table in the BNE — Web Applications Desktop Integrator product (also known as Oracle ETRM / Web ADI), owned by the BNE schema and valid in both Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores the definition of a list of parameters, acting as the master catalogue from which Web ADI parameter lists are resolved at runtime. Parameter lists govern how integrators, importers, and integrator viewers assemble their prompts, and therefore this table underpins the dynamic parameter prompts presented to end users when creating documents or running Web ADI imports.

The table is a multilingual ("_B") base table, paired with a corresponding "_TL" translation table, which is consistent with standard Oracle EBS seed-data modeling. Based on the foreign-key topology, the object has a hub-leaning Data Vault classification: it is referenced by multiple dependent tables and holds relatively stable reference rows, making it a natural business hub around which link and satellite structures would form in a Data Vault model.

Key Information Stored

The table exposes 14 documented columns in the 12.2.2 schema. The most significant are:

• APPLICATION_ID — the owning application context, part of the composite primary key.
• PARAM_LIST_CODE — the business identifier for the parameter list; the second component of the primary key.
• OBJECT_VERSION_NUMBER — optimistic locking control column added under the 12.2 OAF framework standard.
• PERSISTENT_FLAG — indicates whether the parameter list is persisted across sessions.
• COMMENTS — descriptive text for administrators.
• ATTRIBUTE_APP_ID and ATTRIBUTE_CODE — foreign key pair pointing to BNE_ATTRIBUTES, binding the list to a definition attribute.
• LIST_RESOLVER — the resolver used to evaluate the list at runtime.
• ZD_EDITION_NAME — editioning column introduced for EBR (Edition-Based Redefinition) support in 12.2.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard "Who" auditing columns.

The surrogate/system primary key is BNE_PARAM_LISTS_B_PK (APPLICATION_ID, PARAM_LIST_CODE). The unique business-key candidate is BNE_PARAM_LISTS_B_UK1 (APPLICATION_ID, PARAM_LIST_CODE, ZD_EDITION_NAME), which enforces edition-scoped uniqueness.

Common Use Cases and Queries

Typical scenarios include auditing which parameter lists are registered for a given application, troubleshooting an integrator that is not presenting the expected prompts, and reporting on parameters used by Web ADI importers. A representative query listing parameter lists with their attribute bindings:

• SELECT APPLICATION_ID, PARAM_LIST_CODE, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, PERSISTENT_FLAG, LIST_RESOLVER FROM BNE.BNE_PARAM_LISTS_B WHERE APPLICATION_ID = :app_id;
• Joining to the translation table for the display name: SELECT b.PARAM_LIST_CODE, t.USER_PARAM_LIST_NAME FROM BNE.BNE_PARAM_LISTS_B b, BNE.BNE_PARAM_LISTS_TL t WHERE b.APPLICATION_ID = t.APPLICATION_ID AND b.PARAM_LIST_CODE = t.PARAM_LIST_CODE AND t.LANGUAGE = USERENV('LANG');
• Locating integrators bound to a list: SELECT i.IMPORT_PROGRAM_CODE FROM BNE.BNE_IMPORT_PROGRAMS i WHERE i.IMPORT_PARAM_LIST_APP_ID = :app_id AND i.IMPORT_PARAM_LIST_CODE = :code;

Reporting use cases include cataloguing parameter lists per viewer, verifying persistence settings, and checking edition name coverage after upgrade to 12.2.

Related Objects

• BNE_ATTRIBUTES — referenced via ATTRIBUTE_APP_ID and ATTRIBUTE_CODE.
• BNE_IMPORT_PROGRAMS — references this table via IMPORT_PARAM_LIST_APP_ID and IMPORT_PARAM_LIST_CODE.
• BNE_PARAM_GROUPS_B — references via APPLICATION_ID and PARAM_LIST_CODE.
• BNE_VIEWERS_B — references both through PARAM_LIST_APP_ID/PARAM_LIST_CODE and CREATE_DOC_LIST_APP_ID/CREATE_DOC_LIST_CODE.
• BNE_PARAM_LISTS_TL — the translation table supplying language-specific names.