Search Results ad_obsolete_products




Overview
Explore in AI Chat

Overview

AD_OBSOLETE_PRODUCTS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented status is VALID, and it is classified under the ETRM API classification of OTHER, indicating it is an internal maintenance utility rather than a public application programming interface. The package forms part of the AD (Applications DBA) utility layer that Oracle uses during the product installation, upgrade, and cleanup lifecycle. Its core business function is to remove or reverse the artifacts associated with obsolete Oracle EBS products — database objects, synonyms, and schema-level structures that persist after a product has been de-installed or superseded during an upgrade. By automating this cleanup, the package helps keep the APPS schema and registered Oracle schemas free of orphaned objects that could otherwise conflict with patching, AD utilities, or online patching in the 12.2.2 architecture.

Key Procedures and Functions

The ETRM metadata documents five procedures or functions in this package. No parameter lists are published in the reference material, so only their documented purpose is described below.

  • DROP_SYNONYM_LIST — Removes a specific, enumerated set of synonyms associated with obsolete products. It applies targeted cleanup where only a defined list of synonym names is affected.
  • DROP_SYNONYM_ALL — Removes all synonyms belonging to an obsolete product across the relevant schemas, providing a bulk cleanup counterpart to the list-based procedure.
  • DROP_APPS_OBJECTS — Drops objects that reside in the APPS schema and are tied to the obsolete product, purging remaining artifacts after the product is no longer supported.
  • DROP_SCHEMA_OBJECTS — Drops objects within a designated Oracle schema (a product schema identified via FND_ORACLE_USERID), extending cleanup beyond APPS itself.
  • UNDO_DELETE_OBJECT — Provides a reversal or undo path for previously deleted objects, allowing recovery of objects removed during the cleanup process.

Tables Accessed

The package reads and writes a set of APPS synonyms reflecting EBS registration, dependency, and product installation data, plus data dictionary views:

  • AD_OBSOLETE_OBJECTS — Tracks objects marked obsolete; central to identifying what should be dropped or restored.
  • FND_APPLICATION — Application registration metadata used to resolve product context.
  • FND_ORACLE_USERID — Maps application schemas to Oracle users, needed by DROP_SCHEMA_OBJECTS.
  • FND_PRODUCT_DEPENDENCIES and FND_PRODUCT_INSTALLATIONS — Determine which products are installed and how they depend on one another, guiding safe removal.
  • DBA_OBJECTS and DBA_SYNONYMS — Data dictionary sources used to locate actual database objects and synonyms.
  • PLITBLM — An internal PL/SQL table type used by AD utilities to hold collections during processing.

Usage Notes

AD_OBSOLETE_PRODUCTS is not referenced by any other database object, confirming it is a top-level AD utility invoked from the Applications DBA toolset rather than from application forms or public APIs. It is typically called by AD scripts and concurrent programs during product de-installation, upgrade cleanup, and post-patch maintenance, where obsolete product objects must be reconciled. Because it performs destructive DDL (dropping synonyms, objects, and schema structures), it should only be executed under the direction of Oracle support or AD patching procedures, or within a controlled custom maintenance script. The presence of UNDO_DELETE_OBJECT indicates the design anticipates rollback of accidental deletions. The package carries Oracle Proprietary, Confidential Information markings.