Search Results frm_repository_maintenance




Overview
Explore in AI Chat

Overview

APPS.FRM_REPOSITORY_MAINTENANCE is a maintenance and housekeeping package body belonging to the Oracle E-Business Suite Forms repository subsystem. Its documented status is VALID, and it is classified as an OTHER API under the APPS schema in ETRM 12.2.2. The package provides the administrative and purge logic used to manage metadata associated with Forms-based function, menu, and repository content held in the EBS database.

The business purpose of the package is to support the cleanup and lifecycle management of Forms repository artifacts. Administrators and scheduled maintenance routines use these procedures to remove obsolete menu entries, form function registrations, menu-form associations, and repository document content that is no longer required. By centralizing these deletions in a single package, the application enforces consistent handling of dependent records across the FRM and FND schema objects rather than relying on ad hoc SQL.

Key Procedures and Functions

The documented package exposes five procedures:

  • DELETE_MENU_ENTRIES — Removes menu entry records associated with the Forms repository, operating against FND_MENU_ENTRIES so that stale navigation entries no longer appear in the EBS menu hierarchy.
  • DELETE_FORM_ENTRIES — Deletes form function definitions, coordinating with FND_FORM_FUNCTIONS so that obsolete form-based functions are purged from the function registry.
  • DELETE_MENUFORM_ENTRIES — Cleans up the association between menus and forms, addressing entries that tie form functions into specific menu structures.
  • DELETE_MARKED_ENTRIES — Removes records that have been flagged or marked for deletion, providing a batch-style purge mechanism for pre-identified repository content.
  • DELETE_DOCUMENT_TIMEFRAME — Purges repository documents and related detail data falling outside a specified validity window, supporting retention and archival policies.

These procedures rely on the corresponding FND public APIs, specifically FND_FORM_FUNCTIONS_PKG and FND_MENU_ENTRIES_PKG, to perform their deletions safely. No parameter lists are documented in the ETRM metadata, so exact signatures should be confirmed from the package specification before direct invocation.

Tables Accessed

The package references the following documented tables through APPS synonyms:

  • FND_FORM_FUNCTIONS and FND_FORM_FUNCTIONS_PKG — form function definitions and their maintenance API.
  • FND_MENU_ENTRIES and FND_MENU_ENTRIES_PKG — menu structure entries and their maintenance API.
  • FRM_ARCHIVED_LOBS — archived large object content associated with repository documents.
  • FRM_DOCUMENT_DETAILS — detailed document metadata tied to repository documents.
  • FRM_DOC_PUB_OPTIONS — publishing options governing document visibility and behavior.
  • FRM_DOC_REVIEWERS — reviewer assignments attached to repository documents.
  • FRM_REPOSITORY_LOBS — the large object repository store itself.

These tables collectively represent the Forms repository and its governing menu/function registrations. The package reads and deletes from them to keep the repository synchronized with the active application configuration.

Usage Notes

FRM_REPOSITORY_MAINTENANCE is not referenced by any other database object, indicating it is a top-level utility rather than a dependency of other packages, forms, or concurrent programs. It is typically invoked directly by a DBA or system administrator performing repository cleanup, or called from custom maintenance scripts and scheduled concurrent programs that automate purge activities.

Because deletions propagate through multiple FRM and FND tables, the procedures should be executed during maintenance windows with appropriate backups. The package’s reliance on the FND form function and menu entry APIs means it respects the same validation and cleanup logic used elsewhere in EBS, reducing the risk of orphaned menu or function records.