AD Tables (90)
AD - Applications DBA — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
AD_APPLIED_PATCHES |
15 | Oracle Applications patches |
AD_APPL_TOPS |
14 | APPL_TOP names |
AD_APPS_DEPENDENCIES |
4 | dependencies in fresh install APPS schema |
AD_BUGS |
12 | Oracle Applications bugs fixed |
AD_CHECK_FILES |
5 | Checkfile-repository: Highest versions of sql/exec files ever executed |
AD_CHECK_FILE_TEMP |
32 | Interface table for loading the files, file versions, and/or checkfile repositories |
AD_COMPRISING_PATCHES |
8 | Comprising patches in a "merged" patch |
AD_EVENTS |
10 | To store the events |
AD_EVENT_TRANSITIONS |
12 | Contains the history information on various state changes that an event undergoes in its life cycle |
AD_EVENT_VERSIONS |
11 | To store event versions |
AD_FEATURE_VERSIONS |
7 | Current datamodel version and status of various AD features |
AD_FILES |
10 | Files repository: Oracle Applications files |
AD_FILES_SRC_DEST_TEMP |
9 | A temporary table that stores the relation between a source file and its destination. |
AD_FILE_VERSIONS |
18 | File Versions repository: Versions of Oracle Applications files |
AD_FIXED_ISSUES |
2 | This table holds information about the bugs fixed on top of a baseline |
AD_HIDDEN_PATCHES |
5 | Stores a list of patches selected by the user to not display in the Patch Advisor UI pages when displaying recommended patches. |
AD_INSTALL_PROCESSES |
25 | Concurrent-sessions worker/manager communications area |
AD_INVOKER_TASKS |
10 | Used for Invoker Rights processing |
AD_JOBS_DEFERRED |
11 | Hold jobs which failed during a patching session and are being deferred until the end of the phase to run again |
AD_LONG_COLUMN_CONVERSIONS |
8 | Table to store the registation details of tables and columns to be migrated and table level processing status |
AD_MANUAL_STEP_HISTORY |
8 | Stores history of manual steps applied to this instance. For each manual step applied into a customer instance, there will be one entry whic |
AD_MERGED_TABLES |
3 | Tables which have been DataMerged |
AD_OBSOLETE_OBJECTS |
8 | This table stores plsql objects to be dropped as part of the R12 upgrade |
AD_PARALLEL_COMPILE |
8 | List of invalid objects to compile in a schema |
AD_PARALLEL_COMPILE_ERRORS |
5 | Used to list non-fatal errors from parallel compile |
AD_PARALLEL_UPDATES |
12 | Used by the Large Table Updates framework |
AD_PARALLEL_UPDATE_UNITS |
13 | Used by the Large Table Updates framework |
AD_PARALLEL_WORKERS |
11 | Used by the Large Table Updates framework |
AD_PATCH_COMMON_ACTIONS |
19 | Common Actions performed by Autopatch |
AD_PATCH_COND_HISTORY |
7 | |
AD_PATCH_DRIVERS |
22 | Patch drivers in a patch |
AD_PATCH_DRIVER_LANGS |
7 | Languages to which the patch driver pertains |
AD_PATCH_DRIVER_MINIPKS |
8 | Mini Packs contained in a patch (driver) |
AD_PATCH_HIST_SNAPS_TEMP |
22 | Temporary staging table for updating snapshots |
AD_PATCH_HIST_TEMP |
81 | Temporary staging table for recording patch-history |
AD_PATCH_RUNS |
29 | High level Autopatch history, one row per driver applied |
AD_PATCH_RUN_BUGS |
13 | Bugs fixed in a specific run of Autopatch |
AD_PATCH_RUN_BUG_ACTIONS |
14 | Actions included in a bug (fix) |
AD_PATCH_RUN_SESS_ATTRIBS |
8 | This table stores values of different attributes, for different runs of ad utilities. |
AD_PA_ANALYSIS_RUNS |
9 | Stores the history of Requirement Set Analyis Runs |
AD_PA_ANALYSIS_RUN_BUGS |
15 | List of bugs resulting from criteria analysis run |
AD_PA_ANAL_BUG_DEPS |
9 | Stores the dependencies for bugs resulting from Criteria Analysis run |
AD_PA_ANAL_RUN_BUG_CODELEVELS |
9 | Detailed table for new Codelevels introduced by recommended patchsets or latest Codelevel patches for a particular run |
AD_PA_ANAL_RUN_BUG_PREREQS |
7 | Detailed table for pre-requisite Codelevels for a particular patch by recommended patchsets or latest Codelevel patches for a particular run |
AD_PA_ANAL_RUN_PREFERENCES |
7 | Stores the user preferences for download options, platforms and languages for a particular request.. |
AD_PA_CRITERIA |
7 | Stores the requirement set from the Maintain Requirement Set page |
AD_PA_CRITERIA_PRODUCTS |
10 | Seeded values for criteria creation |
AD_PA_CRITERIA_PROD_FAMS |
9 | Stores criteria for Patch Advisor used when determining what types of patches should be applied for given products |
AD_PA_ENTITY_INFO |
7 | Master table to store the entity information of all the entities in Patch Wizard |
AD_PA_PATCH_COND_REQUIRES_INFO |
9 | Detailed table to store the conditional pre-requisite codelevel information of a patch from patch_metadata.xml |
AD_PA_PATCH_ENTITY_INFO |
9 | Master table to store the entity information of all the entities in Patch Wizard |
AD_PA_PATCH_REQUIRES_INFO |
9 | Detailed table to store the pre-requisite codelevel information of a patch from patch_metadata.xml |
AD_PLANNED_RES_LOCKS |
12 | Stores locks to be required by an AD Utility |
AD_PM_MASTER |
8 | Master table for the Patch Metadata repository |
AD_PM_PATCHES |
31 | Lists all patches whose MetaData has been uploaded by Patch Advisor |
AD_PM_PREFERENCES |
6 | Stores the default user preferences for download/merge options, platforms and languages. |
AD_PM_PRODUCT_INFO |
13 | Contains information about Oracle Applications products and pseudo-products |
AD_PM_PROD_FAMILY_MAP |
7 | Contains information about Oracle Applications products and pseudo-products and their mapping to a product family |
AD_PREPMODE_CHECK_FILES |
20 | A "check-file" repository used in clone schema approach |
AD_PROGRAM_RUN_TASKS |
16 | This table stores the information of the various tasks executed during a particular run of ad utility. |
AD_PROGRAM_RUN_TASK_JOBS |
25 | History of timing information of jobs run in parallel |
AD_RELEASES |
14 | Oracle Applications releases |
AD_SEED_DATA_LOADED |
4 | Languages in a patch for which seed data loading has completed |
AD_SESSIONS |
27 | Stores information on all AD sessions for an Applications System |
AD_SESSIONS_HISTORY |
19 | Stores information on all AD sessions for an Applications System |
AD_SESSION_ATTRIBUTES |
7 | This table stores various attributes for a particular session of ad utility. |
AD_SESSION_TASKS |
8 | Stores the tasks for each concurrent AD utility session |
AD_SESSION_TASKS_HISTORY |
8 | Stores the tasks for each concurrent AD utility session |
AD_SNAPSHOTS |
14 | File-system snapshots |
AD_SNAPSHOT_BUGFIXES |
10 | Bug-fixes applied when the snapshot was taken |
AD_SNAPSHOT_BUGFIXES_TEMP |
5 | Temp table to store data to be inserted into AD_SNAPSHOT_BUGFIXES |
AD_SNAPSHOT_FILES |
23 | File-details in the snapshot |
AD_SNAPSHOT_FILES_TEMP |
12 | This is a temporary table used during updation of the snapshot of the Application System. |
AD_SUPPORTED_LANGUAGES |
6 | Oracle Supported langauges for download and/or merging. |
AD_SUPPORTED_PLATFORMS |
7 | Oracle Supported platforms for download and/or merging. |
AD_TASK_STATUS |
16 | This table stores the information about various tasks executed during the run of ad utility. |
AD_TASK_TIMING |
24 | Timing information of jobs run in parallel |
AD_TE_LEVEL_HISTORY |
5 | Holds the history information of trackable entity codelevels. Whenever a row is updated in AD_TRACKABLE_ENTITIES, the row before updating is |
AD_TIMESTAMPS |
13 | Holds the timestamp of when a particular operation took place |
AD_TRACKABLE_ENTITIES |
7 | Stores Oracle Applications Entities and their Code Levels |
AD_UMS_ENGINE_RESULTS |
8 | Stores the results of the UMS environment analysis |
AD_UMS_LDT_LOADS |
5 | Stores dataloader file names used in Patch Advisor |
AD_UPDATE_PREFERENCES |
9 | Not currently used - contains information on various preferences that can be set and referenced during an upgrade |
AD_UPDATE_PREF_VALUES |
8 | Not currently used - contains values specified for a preference at various levels. A value can be specified globally that is applicable for |
AD_UPDATE_WORK_PARAMS |
8 | Not currently used - contains name-value pairs that can be set and retrieved by upgrade scripts running at various stages during a patch app |
AD_WORKING_RES_LOCKS |
14 | Holds Active Locks held by AD Utilites |
FND_MODULE_INSTALLATIONS |
11 | Oracle Application modules installed at your site |
FND_PRODUCT_DEPENDENCIES |
9 | Dependencies of Oracle Applications products installed at your site |
FND_PRODUCT_GROUPS |
16 | Site specific information used by AD utilities |
FND_PRODUCT_INSTALLATIONS |
17 | Oracle Applications products installed at your site |