Search Results drop_synonym_list

Overview

AD_OBSOLETE_PRODUCTS is a maintenance utility package owned by the APPS schema in Oracle E-Business Suite. Its business function is to support the deinstallation and cleanup of Oracle EBS products by removing residual database objects and the APPS-schema synonyms that reference them. When a product is obsoleted or removed from an environment, the base schema objects and their corresponding APPS synonyms are frequently left behind. This package provides the controlled mechanisms used during product removal to drop both the synonym layer and the underlying schema objects, keeping the APPS schema consistent with the set of products that are actually installed.

The package is classified as OTHER in the ETRM metadata and is not a public integration API. It is an internal administrative package invoked by Oracle-provided cleanup logic rather than by end-user applications. Its procedures operate on application identifiers and application short names, driving deletion against the AD_OBSOLETE_OBJECTS registry and Oracle data dictionary views.

Key Procedures and Functions

The ETRM metadata documents five procedures or functions for this package:

• DROP_SYNONYM_LIST — Drops correspondence synonyms in the APPS schema that point to base schema objects. This is the primary procedure associated with the user search term "drop_synonym_list". It accepts an application identifier and application short name to scope the operation.
• DROP_SYNONYM_ALL — Drops all synonyms in the APPS schema that point to objects in a base schema. This performs a broader cleanup than DROP_SYNONYM_LIST, again scoped by application identifier and short name.
• DROP_APPS_OBJECTS — Drops objects based on the application identifier from the AD_OBSOLETE_OBJECTS table. This procedure consults the obsolete object registry to determine which objects belong to the application being removed.
• DROP_SCHEMA_OBJECTS — Drops schema objects based on application identifier. This procedure returns SQLCODE and SQLERRM through output parameters, allowing the caller to capture any error raised during the drop operation.
• UNDO_DELETE_OBJECT — Documented in the package metadata as the fifth procedure/function, supporting reversal of a prior object deletion.

Tables Accessed

The package reads and writes several documented tables and views through APPS synonyms:

• AD_OBSOLETE_OBJECTS — the registry that identifies objects marked as obsolete and drives DROP_APPS_OBJECTS.
• FND_APPLICATION — resolves application identifiers and short names used as procedure arguments.
• FND_ORACLE_USERID — identifies the base Oracle schema (user) associated with an application, needed to locate the objects behind APPS synonyms.
• FND_PRODUCT_DEPENDENCIES and FND_PRODUCT_INSTALLATIONS — product installation and dependency metadata consulted during cleanup.
• DBA_OBJECTS and DBA_SYNONYMS — data dictionary views used to enumerate the actual objects and synonyms targeted for removal.
• PLITBLM — the PL/SQL table and index-by table support structure used for internal processing.

Usage Notes

AD_OBSOLETE_PRODUCTS is not intended for direct invocation by end users, forms, or standard concurrent programs. It is invoked as part of Oracle's product deinstallation and cleanup routines, where removal of a product requires dropping both APPS synonyms and base schema objects. Because DROP_SCHEMA_OBJECTS returns SQLCODE and SQLERRM, callers can capture and handle errors when drops fail due to dependencies or locks. Custom code should avoid calling these procedures directly, as improper use can remove synonyms or objects still required by other installed products. Where cleanup must be scripted, the procedures should be executed under the APPS schema with appropriate privileges and only after verifying that the target application is genuinely obsolete. A DBA-level backup or export is strongly recommended before any drop operation is attempted. Note that the package is referenced by zero other packages, confirming its role as a terminal administrative utility rather than a shared API.