Search Results fem_pb_parameters

Overview

FEM_ADMIN_UTIL_PKG is a utility package in the Application Object Library (APPS) schema of Oracle Enterprise Business Suite (EBS) 12.1.1 and 12.2.2, serving as a foundational component of the Enterprise Taxation and Regulatory Management (ETRM) / Financial Enterprise Management (FEM) administrative layer. Its primary business function is to support the metadata-driven configuration and validation of ETRM objects, tables, views, and table classes. These are the structural definitions that underpin data loading, process options, and data slices used elsewhere in the ETRM engine.

The package body provides reusable validation and lookup routines invoked by ETRM setup forms, concurrent programs, and other dependent packages. It abstracts common administrative operations—such as resolving a view's underlying table owner, validating table class assignments, and managing tuning options—so that the broader ETRM engine (FEM_ENGINES_PKG) and object catalog utilities (FEM_OBJECT_CATALOG_UTIL_PKG) can operate on a consistent, validated metadata model. Given its broad dependency list, the package acts as a central administrative gateway rather than a transaction-processing unit.

Key Procedures and Functions

Eight documented procedures/functions are exposed, classified as OTHER APIs:

• DELETE_OBJ_TUNING_OPTIONS — Removes stored tuning options associated with an ETRM object, typically invoked during object reconfiguration or cleanup.
• NEW_LOCAL_VS_COMBO_ID — Generates or returns a new identifier for a local versus combination construct used in data slice definitions.
• VALIDATE_TAB_CLASS_ASSIGNMT — Validates whether a table class assignment is permitted for a given table, enforcing setup integrity.
• VALIDATE_TAB_CLASS — Confirms that a table class definition is valid against the object catalog metadata.
• VALIDATE_VIEW_CLASS — Validates a view class definition, ensuring the view conforms to ETRM class expectations.
• VALIDATE_OBJ_CLASS_ASSIGNMT — Validates the assignment of a class to an ETRM object.
• GET_TABLE_OWNER_FOR_VIEW — Resolves and returns the table owner associated with a given view, used to qualify database objects.
• GET_INDEX_OWNER_FOR_VIEW — Resolves and returns the index owner associated with a given view.

These routines collectively enforce referential and structural consistency across ETRM administrative metadata.

Tables Accessed

The package reads and writes a broad set of ETRM metadata tables, including FEM_MP_DATA_SLICES and FEM_MP_DATA_SLICE_COLS, which store multi-period data slice definitions and their columns—directly relevant to the search term. It also references FEM_MP_PROCESS_OPTIONS and FEM_PB_PARAMETERS for process configuration, FEM_TABLES_B/TL/VL and FEM_TABLE_PROPERTIES/FEM_TABLE_CLASS_PROP/FEM_TABLE_PROP_COL_REQ/FEM_TABLE_PROP_STP for table and property metadata, FEM_TAB_COLUMNS_B/V and FEM_TAB_COLUMN_PROP for column metadata, FEM_OBJECT_CATALOG_B/TL and FEM_OBJECT_DEFINITION_B for object definitions, FEM_COLUMN_REQUIREMNT_B for requirements, FEM_DATA_LOADER_OBJECTS and FEM_DATA_TYPES_VL for loader definitions, and FEM_XDIM_DIMENSIONS(_VL) for dimension metadata. Dictionary views (ALL_TABLES, ALL_TAB_COLUMNS, ALL_INDEXES, ALL_IND_COLUMNS, USER_OBJECTS, USER_UPDATABLE_COLUMNS) and FND tables (FND_LOOKUP_VALUES, FND_MESSAGE, FND_MSG_PUB, FND_NEW_MESSAGES) support validation and error messaging.

Usage Notes

FEM_ADMIN_UTIL_PKG is typically invoked indirectly through ETRM administrative forms and concurrent programs, and is referenced by one other database package. Developers extending ETRM should call these routines rather than querying metadata tables directly, ensuring validation and owner-resolution logic remain centralized. It is documented as VALID and is not referenced by external objects, reinforcing its utility-layer role.