Results for “bne_param_defns_vl”

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

Overview

BNE_PARAM_DEFNS_VL is a standard Oracle EBS translation (VL) view owned by the APPS schema and defined over the BNE_PARAM_DEFNS entity. It belongs to the BNE — Web Applications Desktop Integrator product family, the technology stack that supports Oracle Web ADI, spreadsheet-based integrations, and parameter-driven layout generation. The view presents parameter definition metadata that governs how parameters are declared, defaulted, validated, and displayed within BNE-driven interfaces. Because BNE_PARAM_DEFNS_VL is a _VL view, it resolves language-dependent descriptive attributes against the session language using USERENV('LANG'), returning a single localized row per parameter definition. In Oracle EBS 12.1.1 and 12.2.2, this view is the reporting-friendly read interface for parameter definitions, allowing developers and administrators to inspect configuration without joining the underlying _B and _TL tables manually.

Underlying Base Objects

The view is documented as being defined over two synonyms in the APPS schema: BNE_PARAM_DEFNS_B (the base, non-translated table) and BNE_PARAM_DEFNS_TL (the translation table). The join condition links the two on APPLICATION_ID and PARAM_DEFN_CODE, restricted by T.LANGUAGE = USERENV('LANG'). The _B table supplies structural and behavioral attributes such as PARAM_SOURCE, DATATYPE, PARAM_RESOLVER, default flags, validation attributes, and audit columns. The _TL table supplies translatable text attributes: USER_NAME, DEFAULT_DESC, PROMPT_LEFT, PROMPT_ABOVE, USER_TIP, ACCESS_KEY, and DEFAULT_STRING. The view text uses NVL(T.DEFAULT_STRING, D.DEFAULT_STRING) so that a translated default string is used when present, otherwise the base value is returned, and derives DEFAULT_STRING_TRANS_FLAG via DECODE(T.DEFAULT_STRING, NULL, 'N', 'Y').

Key Columns

• APPLICATION_ID / PARAM_DEFN_CODE — composite key identifying the parameter definition.
• ROW_ID — base-table ROWID exposed from the _B table.
• PARAM_NAME, PARAM_SOURCE, PARAM_CATEGORY — logical naming, origin, and grouping of the parameter.
• DATATYPE, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, PARAM_RESOLVER — data typing and value resolution behavior.
• DEFAULT_REQUIRED_FLAG, DEFAULT_VISIBLE_FLAG, DEFAULT_USER_MODIFYABLE_FLAG — UI control flags.
• DEFAULT_STRING, DEFAULT_STRING_TRANS_FLAG, DEFAULT_DATE, DEFAULT_NUMBER, DEFAULT_BOOLEAN_FLAG, DEFAULT_FORMULA — default value resolution by type.
• VAL_TYPE, VAL_VALUE, MAX_SIZE — validation behavior and length constraints.
• DISPLAY_TYPE, DISPLAY_STYLE, DISPLAY_SIZE, FORMAT_MASK — presentation attributes.
• USER_NAME, DEFAULT_DESC, PROMPT_LEFT, PROMPT_ABOVE, USER_TIP, ACCESS_KEY — language-dependent text from _TL.
• OA_FLEX_APPLICATION_ID, OA_FLEX_CODE, OA_FLEX_NUM — linkage to descriptive flexfield context where applicable.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard audit columns.

Common Use Cases and Queries

Typical uses include auditing parameter configuration for Web ADI layouts, verifying translation coverage, and driving custom integrations that build parameter-driven spreadsheets. Because it is a _VL view, it is safe to query in any language session and returns exactly one row per definition.

List all parameters for an application:

SELECT param_defn_code, param_name, datatype, display_type
FROM apps.bne_param_defns_vl
WHERE application_id = :app_id
ORDER BY param_name;

Identify translated default strings:

SELECT param_defn_code, default_string, default_string_trans_flag
FROM apps.bne_param_defns_vl
WHERE default_string_trans_flag = 'Y';

Inspect required versus visible parameters:

SELECT param_defn_code, default_required_flag, default_visible_flag,
       default_user_modifyable_flag
FROM apps.bne_param_defns_vl
WHERE default_visible_flag = 'Y';

Join to flexfield definitions when a parameter references a DFF:

SELECT p.param_defn_code, p.oa_flex_code, p.oa_flex_num
FROM apps.bne_param_defns_vl p
WHERE p.oa_flex_application_id IS NOT NULL;