Search Results fem_object_catalog_util_pkg




Overview
Explore in AI Chat

Overview

FEM_OBJECT_CATALOG_UTIL_PKG is a utility package in the APPS schema that supports the Oracle Enterprise Tax, Risk, and Compliance (ETRM / Financial Enterprise Management) module, specifically the object catalog and object definition framework. The package body provides the low-level programmatic services used to create and maintain entries within the FEM_OBJECT_CATALOG and FEM_OBJECT_DEFINITION metadata model. These structures describe the configurable objects that the ETRM application exposes to administrators, including their type classifications, folder organization, language translations, and dependency relationships.

Because the catalog is the authoritative registry of application objects, this utility package serves as the controlled entry point for inserting, validating, and removing the records that the rest of the ETRM infrastructure reads at runtime. Its API classification is OTHER, indicating it is an internal support utility rather than a documented public interface, though it is referenced by six other packages within the application.

Key Procedures and Functions

The package body exposes four documented procedures:

  • CREATE_OBJECT — Inserts a new catalog object into the metadata model, establishing its identity and association with the object sequences and type definitions used throughout ETRM.
  • CREATE_OBJECT_DEFINITION — Creates the corresponding object definition record, capturing the structural and configurable attributes that describe how the object behaves in the application.
  • VALIDATE_OBJ_DEF_EFFDATE — Validates the effective date of an object definition, ensuring that date-driven metadata is consistent and does not conflict with existing validity ranges before it is committed.
  • DELETE_OBJECT — Removes a catalog object and, in conjunction with the package's dependency handling, manages the related definition and translation rows so that the metadata remains referentially sound.

These routines are designed to be called in sequence: an object is defined first, its definition is attached and its effective date validated, and the object can later be retired through DELETE_OBJECT.

Tables Accessed

The package operates across the core ETRM metadata tables and their translations. It writes to FEM_OBJECT_CATALOG_B and FEM_OBJECT_CATALOG_TL (base and translated catalog rows), and to FEM_OBJECT_DEFINITION_B and FEM_OBJECT_DEFINITION_TL (base and translated definition rows). Object identity is sourced from FEM_OBJECT_ID_SEQ and FEM_OBJECT_DEFINITION_ID_SEQ. Object classification is drawn from FEM_OBJECT_TYPES and FEM_OBJECT_TYPES_B, folder placement from FEM_FOLDERS_VL and FEM_USER_FOLDERS, and dependency relationships from FEM_OBJECT_DEPENDENCIES. Reference lookups are read from FND_LOOKUP_VALUES, while global combinations are resolved through FEM_GLOBAL_VS_COMBOS_VL. The package also references the views FEM_OBJECT_CATALOG_VL and FEM_OBJECT_DEFINITION_VL, which present denormalized, language-aware representations of the underlying base and translation tables.

Usage Notes

FEM_OBJECT_CATALOG_UTIL_PKG is invoked when administrators configure object metadata, whether through ETRM setup user interfaces, Oracle Forms-based maintenance screens, or concurrent programs that seed and refresh catalog content. Because it depends on FND_API, FND_MSG_PUB, and FND_LOG, it follows the standard Oracle Application Object Library error-handling, message-stack, and logging conventions, making it suitable for use within larger transactional flows that require rollback on error. Custom extensions and integration code that need to register or retire ETRM objects should call this package rather than writing directly to the underlying catalog tables, since it enforces identifier generation, effective-date validation, and dependency cleanup. Developers should treat it as an internal utility: its procedures are intended for controlled metadata maintenance, and direct DML against the catalog base tables bypasses the validation logic this package provides.