Search Results ad_appl_tops

Overview

The AD_APPL_TOPS table is a core Applications DBA (AD) repository table within the Oracle E-Business Suite (EBS) system. It serves as the master registry for all APPL_TOP directories configured in an EBS instance. The APPL_TOP is a critical file system directory that houses the application tier software code, forms, reports, and other executable files. This table provides the system with a centralized, database-level reference for each APPL_TOP, uniquely identifying them by name and ID. Its primary role is to enable the EBS architecture to manage and track operations—such as patching and system maintenance—across multiple or distinct application top directories, which is essential in complex, multi-node, or shared APPL_TOP configurations.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the structure and foreign key relationships define its critical data elements. The primary key column, APPL_TOP_ID, is a unique numeric identifier for each registered APPL_TOP. This ID is the fundamental reference used throughout the AD (Applications DBA) schema. A corresponding column, likely named APPL_TOP_NAME or similar, stores the logical name of the APPL_TOP directory. The table's design ensures that each physical APPL_TOP path or logical grouping used in the EBS environment is cataloged with a persistent identifier that the system's administrative utilities can reliably reference.

Common Use Cases and Queries

The primary use of AD_APPL_TOPS is to support patching and system maintenance operations. When an AutoPatch session (recorded in AD_PATCH_RUNS) is executed, it must be associated with a specific APPL_TOP target. Similarly, system snapshots or context file backups (in AD_SNAPSHOTS) are linked to an APPL_TOP. Administrators can query this table to inventory configured application tops or join it with related tables for reporting. Common SQL patterns include identifying which APPL_TOP was used for recent patches or verifying registration.

• Listing all registered APPL_TOPs: SELECT appl_top_id, name FROM applsys.ad_appl_tops ORDER BY appl_top_id;
• Joining with AD_PATCH_RUNS to see patch history per APPL_TOP: SELECT pr.patch_name, pr.start_date, at.name FROM applsys.ad_patch_runs pr, applsys.ad_appl_tops at WHERE pr.appl_top_id = at.appl_top_id;

Related Objects

As indicated by the foreign key metadata, AD_APPL_TOPS is a referenced parent table for several key AD module tables. The APPL_TOP_ID column is a foreign key in:

• AD_PATCH_RUNS: Tracks each AutoPatch execution, linking it to the APPL_TOP where it was applied.
• AD_SNAPSHOTS: Stores snapshots of system configuration and context files, associating each snapshot with a specific APPL_TOP.

These relationships underscore the table's central role in the audit trail for change management. The primary key constraint AD_APPL_TOPS_PK enforces data integrity for these critical dependencies.