Search Results del_obsolete_seed_data

Overview

FEM_REFRESH_UTIL_PKG is an Oracle Applications (APPS) PL/SQL package that belongs to the Enterprise Performance Foundation / Enterprise Data Management (FEM) module of Oracle E-Business Suite. Its declared purpose, as documented in the package header, is to provide procedures called by the Refresh Engine so that a database can be returned to its original install state. The package was created on 06-July-2005 by Rob Flippo specifically because the Refresh Engine required the ability to invoke a consolidated set of delete routines that remove obsolete seeded data.

Within ETRM 12.1.1 and 12.2.2 the package is classified as an OTHER API under the APPS schema and is declared with AUTHID CURRENT_USER. It is a utility or housekeeping package rather than a business-facing API: it does not create or maintain analytical metadata for end users, but instead cleans up seed rows that are no longer shipped with the current release. The only documented output statuses are SUCCESS and ERROR.

Key Procedures and Functions

The package exposes a single documented procedure:

• DEL_OBSOLETE_SEED_DATA — Removes obsolete seeded data from the FEM repository, returning an overall status of SUCCESS or ERROR through its OUT parameter. This is the procedure the Refresh Engine calls when it must reconcile a customer database with the current install baseline.

No additional procedures or functions are documented in the ETRM metadata, and no parameter list beyond the OUT status should be assumed.

Tables Accessed

The package operates across the core FEM metadata model. Documented references (via APPS synonyms) include:

• FEM_DATA_TYPES_B / _TL — base and translated data type definitions.
• FEM_DIMENSIONS_B — dimension definitions.
• FEM_DIM_ATTRIBUTES_B / _TL / _PRIV — dimension attributes, their translations, and privilege rows.
• FEM_DIM_ATTR_GRPS and FEM_DIM_ATTR_VERSIONS_B / _TL — attribute groups and versioned attribute definitions.
• FEM_ENTITY_TYPES_B / _TL — entity type definitions and translations.
• FEM_CALENDARS_ATTR, FEM_DSNP_LEDGERS_ATTR, FEM_ADMIN_DIMSETUP_TASKS — calendar attributes, ledger dimension setup attributes, and administrative dimension setup tasks.

These tables represent the FEM seeding and configuration layer. The procedure reads them to identify rows that were seeded by earlier releases, then removes those no longer valid, preserving a clean install state.

Usage Notes

FEM_REFRESH_UTIL_PKG is not invoked directly by end users or by standard application forms. Its sole documented consumer is the FEM Refresh Engine, which calls DEL_OBSOLETE_SEED_DATA during refresh operations that bring a database back in line with the shipped seed data set. ETRM records zero other packages referencing this package, indicating a narrow, internally driven call path.

Because the package is declared AUTHID CURRENT_USER, privileges are evaluated against the invoking schema, so it is typically executed from within the Refresh Engine's own session or a privileged administrative context. Custom code should not call this procedure on an ad hoc basis: it performs destructive deletes against core FEM metadata tables and is intended to run only as part of a coordinated refresh cycle. In 12.2.2 the same behavior is retained, with the package residing in the APPS schema alongside the rest of the FEM database objects.