Search Results g_limit_bulk_numrows

Overview

FEM_WEBADI_HIER_UTILS_PVT is a private (PVT) helper package in the Oracle EBS Application Object Library owned by APPS. It supports the WebADI-based hierarchy maintenance features of Enterprise Territory Management / Oracle Fusion Territory Management (internally known as FEM), specifically the upload and validation of territory and dimension hierarchy definitions through WebADI (Web Applications Desktop Integrator) spreadsheets. The package holds the utility logic that WebADI integrators call to translate spreadsheet rows into hierarchical dimension data, resolve dimension metadata, and perform set-based inserts into the FEM interface and hierarchy tables.

The public specification declares a set of PL/SQL collection types and global record structures rather than a broad API surface. These types model dimension metadata (g_global_val_rec_type) and bulk row sets (g_number_tbl_type, g_char_tbl_type, g_date_tbl_type), allowing the package to process hierarchies in arrays. The constant G_LIMIT_BULK_NUMROWS CONSTANT NUMBER := 100, defined at line 48, is the row-count ceiling used to control BULK COLLECT/FORALL batch sizes during hierarchy processing. This constant is the object most frequently searched by developers.

Key Procedures and Functions

The ETRM metadata documents a single callable program within this package. Its declaration in the package specification is the named constant/identifier NAME; the package is classified as PVT, indicating that the procedures are not part of a supported public API but are invoked internally by the WebADI hierarchy integrator logic.

• NAME — the sole documented program unit. In the FEM WebADI hierarchy utility pattern, this unit performs the row-wise processing of uploaded hierarchy data, applying the G_LIMIT_BULK_NUMROWS limit to batch DML against the FEM interface and hierarchy tables. Parameter lists are not documented in the ETRM metadata and must not be assumed.

Beyond the documented unit, the specification exposes the collection and record type definitions used by callers to pass dimension metadata (dimension id, interface member table names, member display codes, ledger id, value-set flags, and similar attributes). These types are consumable by the WebADI integrator and by any custom code extending the hierarchy upload flow.

Tables Accessed

The package reads and writes the following tables via APPS synonyms, as recorded in ETRM:

• FEM_HIERARCHIES_T — territory/dimension hierarchy definitions; the primary target for hierarchy row inserts and updates.
• FEM_HIER_DIM_GRPS_T — translation/hierarchy-to-dimension-group associations written when uploaded hierarchies are linked to dimension groups.
• FEM_HIER_VALUE_SETS_T — value set assignments for hierarchy members, populated when a dimension requires a value set.
• FEM_DIMENSION_GRPS_B — base dimension group definitions used to resolve group metadata during upload.
• FEM_DIM_ATTRIBUTES_B and FEM_DIM_ATTR_VERSIONS_B — dimension attribute definitions and their versioned rows, used to validate attribute values carried on the spreadsheet.
• FEM_CAL_PERIODS_ATTR — calendar period attributes, consulted when hierarchy members reference calendar/period dimensions.
• PLITBLM — the standard PL/SQL index-by table utility used for array binding of the collection types above.

These accesses are consistent with a WebADI upload path that must validate dimension metadata, resolve target tables, and persist hierarchy and value-set rows in bulk.

Usage Notes

FEM_WEBADI_HIER_UTILS_PVT is invoked indirectly. End users launch a WebADI hierarchy template, and the FEM WebADI integrator (the public uploader package) calls this private utility to stage, validate, and commit rows. It is not intended for direct invocation by customers or third-party extensions, and ETRM records zero packages referencing it, confirming its role as an internal implementation detail of the WebADI hierarchy flow.

Developers investigating g_limit_bulk_numrows should note that the constant is a compile-time limit of 100, applied to bound array operations. Changing it requires recompiling the package and is not supported without an Oracle patch or service request, since the package version string (120.0.12000000.2) indicates a shipped, Oracle-maintained build. Custom code should not depend on this package's internals; supported integration points are the public FEM WebADI APIs.