Search Results process_attribute

Overview

FEM_WEBADI_MEMBER_UTILS_PVT is a private PL/SQL package body in the APPS schema that supports the WebADI (Web Applications Desktop Integrator) member upload and metadata generation framework for Oracle Enterprise Performance Foundation / Enterprise Resource Tracking Manager (ETRM), now marketed as Oracle Financial Consolidation Hub and related Profitability and Cost Management components. The package operates in the FEM module namespace and is responsible for preparing dimension member metadata, interface column definitions, and member header interface records so that users can upload and validate dimension member data through WebADI spreadsheets.

The package declares several package-level global collections, including g_dim_varchar_label_tbl, g_interface_col_name_tbl, g_attribute_name_tbl, g_attribute_data_type_tbl, and g_not_null_attr_name_tbl, all instantiated as FND_TABLE_OF_VARCHAR2_30 or related types. Additional globals support display code mapping (g_attribute_vs_display_code, g_version_display_code) and null-attribute value handling. These collections cache map table column values and attribute metadata during a single session, avoiding repeated queries against the BNE and FEM metadata tables. The private nature of the package (PVT classification) means it is not published as a supported public API; it is invoked internally by other WebADI member utility packages and concurrent processes.

Key Procedures and Functions

The documented procedures and functions include:

• POPULATE_MEM_WEBADI_METADATA — The primary driver procedure. It populates the WebADI metadata structures required for member download and upload, including attribute labels, interface column names, data types, and null-attribute constraints, by reading from the BNE integrator, interface, layout, and column tables and the FEM dimension metadata tables.
• NAME — A general-purpose utility routine used to derive or resolve naming conventions, likely mapping internal column or attribute identifiers to user-facing labels used in the generated WebADI spreadsheet.
• UPLOAD_MEMBER_HEADER_INTERFACE — Handles insertion and processing of member header interface rows, transferring validated member header data from the WebADI staging structures into the FEM interface tables for subsequent validation and loading.
• DELETE_FEM_WEBADI_SEED — Removes previously seeded WebADI metadata records associated with FEM member integrations, allowing regeneration of seed data during setup or upgrade.

An additional debug helper procedure, pd, is present for development-time diagnostics via DBMS_OUTPUT and is not part of the functional interface.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• BNE_INTEGRATORS_B and BNE_INTEGRATORS_TL — Define the WebADI integrator registered for FEM member upload, including the integrator name, parameters, and translated descriptions.
• BNE_INTERFACES_B and BNE_INTERFACES_TL — Define the specific WebADI interface and its translated prompt and description text.
• BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL — Define the columns exposed on the WebADI interface, including column ordering, data types, and display labels.
• BNE_LAYOUTS_B, BNE_LAYOUTS_TL, BNE_LAYOUT_BLOCKS_B, BNE_LAYOUT_BLOCKS_TL, and BNE_LAYOUT_COLS — Define the spreadsheet layout structure, block organization, and column placement used to generate the member upload template.
• FEM_DIMENSIONS_B and FEM_DIMENSIONS_TL — Source the dimension definitions and translated dimension names that become WebADI member attributes.
• FEM_DIMENSION_GRPS_B — Provides dimension group information used to scope the member metadata to the correct grouping.
• FEM_DIM_ATTRIBUTES_B — Supplies dimension attribute definitions, data types, and mandatory (not-null) flags that drive attribute-level validation in the WebADI interface.

Usage Notes

FEM_WEBADI_MEMBER_UTILS_PVT is invoked indirectly through the FEM WebADI member upload flow, typically triggered from the Enterprise Performance Foundation / ETRM application when a user launches a member download or upload template. It is not called directly by end users or custom forms in supported configurations; instead, it is referenced by higher-level member utility packages that orchestrate the WebADI integration.

The package is versioned under the FEMVADIMEMBUTILB.pls source file, with a header indicating maintenance through patch level 120.3.12010000.2. Because the package is classified as PVT (private), its procedures are not documented as public APIs and Oracle does not guarantee backward compatibility of their signatures across releases. The term "process_attribute" does not map to a documented procedure in this package; attribute processing is handled through the metadata population logic in POPULATE_MEM_WEBADI_METADATA and the global attribute collections declared at package level. Customizations should rely on public FEM APIs rather than invoking this package directly, and any diagnostic use of the pd procedure requires DBMS_OUTPUT to be enabled on the session.