Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - AD Tables and Views

TABLE - APPLSYS.AD_APPLIED_PATCHES
TABLE - APPLSYS.AD_APPL_TOPS
TABLE - APPLSYS.AD_APPS_DEPENDENCIES
TABLE - APPLSYS.AD_BUGS
TABLE - APPLSYS.AD_CHECK_FILES
TABLE - APPLSYS.AD_CHECK_FILE_TEMP
TABLE - APPLSYS.AD_COMPRISING_PATCHES
TABLE - APPLSYS.AD_EVENTS
TABLE - APPLSYS.AD_EVENT_TRANSITIONS
TABLE - APPLSYS.AD_EVENT_VERSIONS
TABLE - APPLSYS.AD_FEATURE_VERSIONS
TABLE - APPLSYS.AD_FILES
TABLE - APPLSYS.AD_FILES_SRC_DEST_TEMP
TABLE - APPLSYS.AD_FILE_VERSIONS
TABLE - APPLSYS.AD_FIXED_ISSUES
TABLE - APPLSYS.AD_HIDDEN_PATCHES
TABLE - APPLSYS.AD_INSTALL_PROCESSES
TABLE - APPLSYS.AD_INVOKER_TASKS
TABLE - APPLSYS.AD_JOBS_DEFERRED
TABLE - APPLSYS.AD_LONG_COLUMN_CONVERSIONS
TABLE - APPLSYS.AD_MANUAL_STEP_HISTORY
TABLE - APPLSYS.AD_MERGED_TABLES
TABLE - APPLSYS.AD_OBSOLETE_OBJECTS
TABLE - APPLSYS.AD_PARALLEL_COMPILE
TABLE - APPLSYS.AD_PARALLEL_COMPILE_ERRORS
TABLE - APPLSYS.AD_PARALLEL_UPDATES
TABLE - APPLSYS.AD_PARALLEL_UPDATE_UNITS
TABLE - APPLSYS.AD_PARALLEL_WORKERS
TABLE - APPLSYS.AD_PATCH_COMMON_ACTIONS
TABLE - APPLSYS.AD_PATCH_COND_HISTORY
TABLE - APPLSYS.AD_PATCH_DRIVERS
TABLE - APPLSYS.AD_PATCH_DRIVER_LANGS
TABLE - APPLSYS.AD_PATCH_DRIVER_MINIPKS
TABLE - APPLSYS.AD_PATCH_HIST_SNAPS_TEMP
TABLE - APPLSYS.AD_PATCH_HIST_TEMP
TABLE - APPLSYS.AD_PATCH_RUNS
TABLE - APPLSYS.AD_PATCH_RUN_BUGS
TABLE - APPLSYS.AD_PATCH_RUN_BUG_ACTIONS
TABLE - APPLSYS.AD_PATCH_RUN_SESS_ATTRIBS
TABLE - APPLSYS.AD_PA_ANALYSIS_RUNS
TABLE - APPLSYS.AD_PA_ANALYSIS_RUN_BUGS
TABLE - APPLSYS.AD_PA_ANAL_BUG_DEPS
TABLE - APPLSYS.AD_PA_ANAL_RUN_BUG_CODELEVELS
TABLE - APPLSYS.AD_PA_ANAL_RUN_BUG_PREREQS
TABLE - APPLSYS.AD_PA_ANAL_RUN_PREFERENCES
TABLE - APPLSYS.AD_PA_CRITERIA
TABLE - APPLSYS.AD_PA_CRITERIA_PRODUCTS
TABLE - APPLSYS.AD_PA_CRITERIA_PROD_FAMS
TABLE - APPLSYS.AD_PA_ENTITY_INFO
TABLE - APPLSYS.AD_PA_PATCH_COND_REQUIRES_INFO
TABLE - APPLSYS.AD_PA_PATCH_ENTITY_INFO
TABLE - APPLSYS.AD_PA_PATCH_REQUIRES_INFO
TABLE - APPLSYS.AD_PLANNED_RES_LOCKS
TABLE - APPLSYS.AD_PM_MASTER
TABLE - APPLSYS.AD_PM_PATCHES
TABLE - APPLSYS.AD_PM_PREFERENCES
TABLE - APPLSYS.AD_PM_PRODUCT_INFO
TABLE - APPLSYS.AD_PM_PROD_FAMILY_MAP
TABLE - APPLSYS.AD_PREPMODE_CHECK_FILES
TABLE - APPLSYS.AD_PROGRAM_RUN_TASKS
TABLE - APPLSYS.AD_PROGRAM_RUN_TASK_JOBS
TABLE - APPLSYS.AD_RELEASES
TABLE - APPLSYS.AD_SEED_DATA_LOADED
TABLE - APPLSYS.AD_SESSIONS
TABLE - APPLSYS.AD_SESSIONS_HISTORY
TABLE - APPLSYS.AD_SESSION_ATTRIBUTES
TABLE - APPLSYS.AD_SESSION_TASKS
TABLE - APPLSYS.AD_SESSION_TASKS_HISTORY
TABLE - APPLSYS.AD_SNAPSHOTS
TABLE - APPLSYS.AD_SNAPSHOT_BUGFIXES
TABLE - APPLSYS.AD_SNAPSHOT_BUGFIXES_TEMP
TABLE - APPLSYS.AD_SNAPSHOT_FILES
TABLE - APPLSYS.AD_SNAPSHOT_FILES_TEMP
TABLE - APPLSYS.AD_SUPPORTED_LANGUAGES
TABLE - APPLSYS.AD_SUPPORTED_PLATFORMS
TABLE - APPLSYS.AD_TASK_STATUS
TABLE - APPLSYS.AD_TASK_TIMING
TABLE - APPLSYS.AD_TE_LEVEL_HISTORY
TABLE - APPLSYS.AD_TIMESTAMPS
TABLE - APPLSYS.AD_TRACKABLE_ENTITIES
TABLE - APPLSYS.AD_UMS_ENGINE_RESULTS
TABLE - APPLSYS.AD_UMS_LDT_LOADS
TABLE - APPLSYS.AD_UPDATE_PREFERENCES
TABLE - APPLSYS.AD_UPDATE_PREF_VALUES
TABLE - APPLSYS.AD_UPDATE_WORK_PARAMS
TABLE - APPLSYS.AD_WORKING_RES_LOCKS
TABLE - APPLSYS.FND_MODULE_INSTALLATIONS
TABLE - APPLSYS.FND_PRODUCT_DEPENDENCIES
TABLE - APPLSYS.FND_PRODUCT_GROUPS
TABLE - APPLSYS.FND_PRODUCT_INSTALLATIONS

Table: AD_APPLIED_PATCHES

Description: Oracle Applications patches
Primary Key: AD_APPLIED_PATCHES_PK
  1. APPLIED_PATCH_ID
Comments

AD_APPLIED_PATCHES holds information about the "distinct" Oracle Applications patches that have been applied. If 2 patches happen to have the same name but are different in content (eg. "merged" patches), then they are considered distinct and this table will therefore hold 2 records.
.
When populating PATCH_NAME, a name-transformation is done to help tie together the comprising drivers of a patch. The transformation essentially does the following:
- Removes any "D" or "DB" (or "d" or "db") appearing as a prefix or suffix in the original patch name
- Removes any "bug_" text appearing as a prefix in the original patch name
.

Indexes
Index Type Tablespace Column
AD_APPLIED_PATCHES_U1 UNIQUE APPS_TS_TX_IDX APPLIED_PATCH_ID
AD_APPLIED_PATCHES_N1 NONUNIQUE APPS_TS_TX_IDX PATCH_NAME
AD_APPLIED_PATCHES_N2 NONUNIQUE APPS_TS_TX_IDX MAINT_PACK_LEVEL
AD_APPLIED_PATCHES_N3 NONUNIQUE APPS_TS_TX_IDX IMPORTED_ID
IMPORTED_FROM_DB
Columns
Name Datatype Length Mandatory Comments
APPLIED_PATCH_ID NUMBER
Y Patch identifier
RAPID_INSTALLED_FLAG VARCHAR2 (1)
Y implies that this record was created at Oracle Corporation when building a Rapid Install database
PATCH_NAME VARCHAR2 (120) Y Patch name as obtained after a simple transformation. See table description
PATCH_TYPE VARCHAR2 (30) Y ONE-OFF, PATCH-SET or MAINTENANCE-PACK
MAINT_PACK_LEVEL VARCHAR2 (30)
Maintenance Pack Level. Left blank if the patch is not a Maintenance Pack
SOURCE_CODE VARCHAR2 (3) Y Data source (DRV=>Patch driver, TXT=>applptch.txt)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
IMPORTED_FLAG VARCHAR2 (1)
Y=>Imported from another database using patch-history export-import feature
IMPORTED_FROM_DB VARCHAR2 (30)
ORACLE_SID of the (source) database from which this row is imported
IMPORTED_ID NUMBER

APPLIED_PATCH_ID of the source row in the source database
MERGE_DATE DATE

Merger date, if its a merged patch
DATA_MODEL_DONE_FLAG VARCHAR2 (1)
Y=>Data model changes of this patch have been applied. Used for database/generate driver run coordination

[top of page]

APPLSYS.AD_APPLIED_PATCHES does not reference any database object

APPLSYS.AD_APPLIED_PATCHES is referenced by following:

APPLSYS
VIEW - AD_APPLIED_PATCHES#

[top of page]

Table: AD_APPL_TOPS

Description: APPL_TOP names
Primary Key: AD_APPL_TOPS_PK
  1. APPL_TOP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_PATCH_RUNS.APPL_TOP_ID AD_APPL_TOPS
AD_SNAPSHOTS.APPL_TOP_ID AD_APPL_TOPS
Comments

This table holds the various APPL-TOP's in the Oracle Applications installation that have ever been patched.

Indexes
Index Type Tablespace Column
AD_APPL_TOPS_U1 UNIQUE APPS_TS_TX_IDX APPL_TOP_ID
AD_APPL_TOPS_U2 UNIQUE APPS_TS_TX_IDX NAME
APPLICATIONS_SYSTEM_NAME
APPL_TOP_TYPE
Columns
Name Datatype Length Mandatory Comments
APPL_TOP_ID NUMBER
Y PK
NAME VARCHAR2 (50) Y Name of the APPL_TOP
DESCRIPTION VARCHAR2 (150)
Description of the APPL_TOP
SERVER_TYPE_ADMIN_FLAG VARCHAR2 (1)
Y => this APPL-TOP currently implements the "Admin" server
SERVER_TYPE_FORMS_FLAG VARCHAR2 (1)
Y => this APPL-TOP currently implements the "Forms" server
SERVER_TYPE_NODE_FLAG VARCHAR2 (1)
Y => this APPL-TOP currently implements the "Concurrent Processing" server
SERVER_TYPE_WEB_FLAG VARCHAR2 (1)
Y => this APPL-TOP currently implements the "Web" server
CREATION_DATE DATE
Y Standard who column - date when this row was created.
APPLICATIONS_SYSTEM_NAME VARCHAR2 (30) Y Name of the "Applications System" to which this APPL-TOP belongs
APPL_TOP_TYPE VARCHAR2 (1) Y R=>Real APPL-TOP, S=>Pre-seeded
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ACTIVE_FLAG VARCHAR2 (1)
N=>Inactive

[top of page]

APPLSYS.AD_APPL_TOPS does not reference any database object

APPLSYS.AD_APPL_TOPS is referenced by following:

APPLSYS
VIEW - AD_APPL_TOPS#

[top of page]

Table: AD_APPS_DEPENDENCIES

Description: dependencies in fresh install APPS schema
Comments

dependency information for fresh install APPS schema

Indexes
Index Type Tablespace Column
AD_APPS_DEPENDENCIES_N1 NONUNIQUE APPS_TS_SEED OBJ#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER

object number from sys.obj$
NAME VARCHAR2 (128) Y object name
TYPE VARCHAR2 (30) Y object type
DEPEND_LEVEL NUMBER
Y relative dependency level

[top of page]

APPLSYS.AD_APPS_DEPENDENCIES does not reference any database object

APPLSYS.AD_APPS_DEPENDENCIES is referenced by following:

APPLSYS
VIEW - AD_APPS_DEPENDENCIES#

[top of page]

Table: AD_BUGS

Description: Oracle Applications bugs fixed
Primary Key: AD_BUGS_PK
  1. BUG_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_COMPRISING_PATCHES.BUG_ID AD_BUGS
AD_PATCH_RUN_BUGS.BUG_ID AD_BUGS
AD_SNAPSHOT_BUGFIXES.BUGFIX_ID AD_BUGS
Comments

AD_BUGS holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation.

Indexes
Index Type Tablespace Column
AD_BUGS_U1 UNIQUE APPS_TS_TX_IDX BUG_ID
AD_BUGS_U2 UNIQUE APPS_TS_TX_IDX LANGUAGE
BUG_NUMBER
ARU_RELEASE_NAME
BASELINE_NAME
TRACKABLE_ENTITY_ABBR
AD_BUGS_N1 NONUNIQUE APPS_TS_TX_IDX BUG_NUMBER
TRACKABLE_ENTITY_ABBR
BASELINE_NAME
Columns
Name Datatype Length Mandatory Comments
BUG_ID NUMBER
Y PK
APPLICATION_SHORT_NAME VARCHAR2 (50)
BUG_NUMBER VARCHAR2 (30) Y Bug Number of the bug (fix)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
ARU_RELEASE_NAME VARCHAR2 (30) Y For internal use - Holds 11i for all 11.5.x releases
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
TRACKABLE_ENTITY_ABBR VARCHAR2 (8)
Product Abbreviation
BASELINE_NAME VARCHAR2 (150)
Holds the baseline name
GENERIC_PATCH VARCHAR2 (1)
Flag to indentify generic patch
LANGUAGE VARCHAR2 (4) Y Holds the language with which the bug is associated

[top of page]

APPLSYS.AD_BUGS does not reference any database object

APPLSYS.AD_BUGS is referenced by following:

APPLSYS
VIEW - AD_BUGS#

[top of page]

Table: AD_CHECK_FILES

Description: Checkfile-repository: Highest versions of sql/exec files ever executed
Primary Key: AD_CHECK_FILES_PK
  1. CHECK_FILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_CHECK_FILES.FILE_ID AD_FILES
AD_CHECK_FILES.FILE_VERSION_ID AD_FILE_VERSIONS
Comments

This table is the "checkfile-repository". It contains information about the highest versions of files that ever got executed in sql/exec commands when applying Oracle Applications patches. The information is limited however to data loader calls (FNDLOAD, WFLOAD and akload.class) and package creation calls.

Indexes
Index Type Tablespace Column
AD_CHECK_FILES_U1 UNIQUE APPS_TS_TX_IDX CHECK_FILE_ID
AD_CHECK_FILES_U2 UNIQUE APPS_TS_TX_IDX FILE_ID
DISTINGUISHER
Columns
Name Datatype Length Mandatory Comments
CHECK_FILE_ID NUMBER
Y PK
FILE_ID NUMBER
Y Identifies the file
FILE_VERSION_ID NUMBER
Y Identifies the version of the file
DISTINGUISHER VARCHAR2 (80)
"Distinguisher" information as stated in the patch driver
CREATION_DATE DATE
Y Standard who column - date when this row was created.

[top of page]

APPLSYS.AD_CHECK_FILES does not reference any database object

APPLSYS.AD_CHECK_FILES is referenced by following:

APPLSYS
VIEW - AD_CHECK_FILES#

[top of page]

Table: AD_CHECK_FILE_TEMP

Description: Interface table for loading the files, file versions, and/or checkfile repositories
Comments

AD_CHECK_FILE_TEMP is a temporary staging area used to efficiently mass-load files, file-versions and/or checkfile repositories and/or file-system-snapshots.
.
FILE_ID, FILE_VERSION_ID and CHECK_FILE_ID are initially inserted as nulls, and updated later after the respective file, file-version and checkfile-repository records are identified/created.
.
JUNK is a dummy field to help manage storage space efficiently. It is purposely populated with a lengthy value that is later wiped out when the succeeding columns are updated. This helps avoid row chaining by letting Oracle allocate more space upfront for the row.
.
APP_SHORT_NAME_1, SUBDIR_1, FILENAME_1, FILE_SIZE and CHECK_SUM are currently used only when maintaining file-system-snapshots of an APPL_TOP.

Columns
Name Datatype Length Mandatory Comments
APP_SHORT_NAME VARCHAR2 (50) Y Application short name of the product owning the file
SUBDIR VARCHAR2 (256) Y Directory where the file resides (relative to the product-top)
FILENAME VARCHAR2 (128) Y File name
MANIFEST_VERS VARCHAR2 (150) Y Version of the file (to use when populating the file-versions repository)
TRANSLATION_LEVEL NUMBER
Y Translation-level to use when populating the file-versions repository
EFFECTIVE_DATE DATE
Y Effective date. Used to populate the creation-date WHO columns in the target tables
DISTINGUISHER VARCHAR2 (80)
"Distinguisher" information to use when populating the checkfile-repository
JUNK VARCHAR2 (80)
For internal use. Designed to help use storage space efficiently
FILE_ID NUMBER

Identifies the file given by (APP_SHORT_NAME, SUBDIR, FILENAME)
FILE_VERSION_ID NUMBER

Identifies the file-version given by (MANIFEST_VERS, TRANSLATION_LEVEL)
CHECK_FILE_ID NUMBER

Identifies the "checkfile-repository" record for the given file and DISTINGUISHER
MANIFEST_VERS_HIGHER VARCHAR2 (1)
Y if the version in this table is higher than what is already in the "checkfile-repository"
ACTIVE_FLAG VARCHAR2 (1)
Y => enabled for processing
MANIFEST_VERS_2 VARCHAR2 (150)
Another kind of file-version (such as on-site version, as opposed to version in the patch), to use when populating the file-versions repository
FILE_VERSION_ID_2 NUMBER

Identifies the file-version given by MANIFEST_VERS_2
APP_SHORT_NAME_1 VARCHAR2 (50)
Application short name of the product owning the "containing" file (eg. the C archive library)
SUBDIR_1 VARCHAR2 (256)
Directory where the "containing" file resides (relative to the product-top)
FILENAME_1 VARCHAR2 (128)
Name of the "containing" file (eg. C archive library)
FILE_SIZE NUMBER

File size in bytes
CHECK_SUM NUMBER

For internal use only
INCONSISTENT_FLAG VARCHAR2 (1)
For internal use only
APPL_TOP_ID NUMBER

Appl_Top_Id
DEST_FILE_ID NUMBER

FILE_ID of a file in its copy location
DEST_APPS_SHORT_NAME VARCHAR2 (50)
Application Short Name of file copy destination location
DEST_SUBDIR VARCHAR2 (256)
subdirectory of file copy destination location
DEST_FILENAME VARCHAR2 (128)
Filename at copy destination location
FILE_TYPE_FLAG VARCHAR2 (1)
For internal use only
SERVER_TYPE_ADMIN_FLAG VARCHAR2 (1)
Indicates if the server is an admin server
SERVER_TYPE_FORMS_FLAG VARCHAR2 (1)
Indicates if the server is a forms server
SERVER_TYPE_NODE_FLAG VARCHAR2 (1)
Indicates if the server is a node server
SERVER_TYPE_WEB_FLAG VARCHAR2 (1)
Indicates if the server is a web server
LANGUAGE VARCHAR2 (4)

[top of page]

APPLSYS.AD_CHECK_FILE_TEMP does not reference any database object

APPLSYS.AD_CHECK_FILE_TEMP is referenced by following:

APPLSYS
VIEW - AD_CHECK_FILE_TEMP#

[top of page]

Table: AD_COMPRISING_PATCHES

Description: Comprising patches in a "merged" patch
Primary Key: AD_COMPRISING_PATCHES_PK
  1. COMPRISING_PATCH_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_COMPRISING_PATCHES.PATCH_DRIVER_ID AD_PATCH_DRIVERS
AD_COMPRISING_PATCHES.BUG_ID AD_BUGS
Comments

This table holds information about the comprising patches in case of "merged" patches.
.

Indexes
Index Type Tablespace Column
AD_COMPRISING_PATCHES_U1 UNIQUE APPS_TS_TX_IDX COMPRISING_PATCH_ID
AD_COMPRISING_PATCHES_U2 UNIQUE APPS_TS_TX_IDX PATCH_DRIVER_ID
BUG_ID
Columns
Name Datatype Length Mandatory Comments
COMPRISING_PATCH_ID NUMBER
Y PK
PATCH_DRIVER_ID NUMBER
Y Identifies the patch driver
BUG_ID NUMBER
Y Identifies the "comprising" bugfix
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
PATCH_ABSTRACT VARCHAR2 (240)
Patch Abstract

[top of page]

APPLSYS.AD_COMPRISING_PATCHES does not reference any database object

APPLSYS.AD_COMPRISING_PATCHES is referenced by following:

APPLSYS
VIEW - AD_COMPRISING_PATCHES#

[top of page]

Table: AD_EVENTS

Description: To store the events
Comments

Contains information on events. An event is something that can be tracked and is typically associated with a task whose execution status needs to be tracked. An event is associated with one or more state values and undergoes state changes during its life cycle.

Indexes
Index Type Tablespace Column
AD_EVENTS_U1 UNIQUE APPS_TS_TX_IDX EVENT_CONTEXT
EVENT_NAME
OWNER
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER
Y Unique id of event
OWNER VARCHAR2 (30) Y Owner of event
EVENT_NAME VARCHAR2 (50) Y Name of event
EVENT_CONTEXT VARCHAR2 (30) Y Context of event
EVENT_TYPE VARCHAR2 (30) Y Type of event
LAST_VERSION NUMBER
Y Latest version of event
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_EVENTS does not reference any database object

APPLSYS.AD_EVENTS is referenced by following:

APPLSYS
VIEW - AD_EVENTS#

[top of page]

Table: AD_EVENT_TRANSITIONS

Description: Contains the history information on various state changes that an event undergoes in its life cycle
Comments

Contains history information on various state changes that an event undergoes during its life cycle

Indexes
Index Type Tablespace Column
AD_EVENT_TRANSITIONS_U1 UNIQUE APPS_TS_TX_IDX TRANSITION_ID
AD_EVENT_TRANSITIONS_N1 NONUNIQUE APPS_TS_TX_IDX VERSION
EVENT_ID
Columns
Name Datatype Length Mandatory Comments
TRANSITION_ID NUMBER
Y Unique identifier for the event transition
EVENT_ID NUMBER
Y Unique id of event
VERSION NUMBER

Version of the event
NEW_STATUS VARCHAR2 (30)
State value of the event after the transition
PRIOR_STATUS VARCHAR2 (30)
State value of the event before the transition
TRANSITION_TIME DATE

Timestamp of the transition
MODULE_NAME VARCHAR2 (30)
Name of the module that caused the transition
WORKER_ID NUMBER

Identifier for the worker that caused the transition
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_EVENT_TRANSITIONS does not reference any database object

APPLSYS.AD_EVENT_TRANSITIONS is referenced by following:

APPLSYS
VIEW - AD_EVENT_TRANSITIONS#

[top of page]

Table: AD_EVENT_VERSIONS

Description: To store event versions
Comments

Contains revision information associated with an event. A single event can have one or more versions and are tracked independently of each other. The event with the highest version is considered if a specific version of the event is not specified

Indexes
Index Type Tablespace Column
AD_EVENT_VERSIONS_U1 UNIQUE APPS_TS_TX_IDX EVENT_ID
VERSION
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER
Y Unique id of event
VERSION NUMBER
Y Version of event
STATUS VARCHAR2 (30)
Event status
START_TIME DATE

Event start time
END_TIME DATE

Event end time
NUM_WORKERS NUMBER

Number of workers
WORKER_STATUS VARCHAR2 (1500)
Status of all workers
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_EVENT_VERSIONS does not reference any database object

APPLSYS.AD_EVENT_VERSIONS is referenced by following:

APPLSYS
VIEW - AD_EVENT_VERSIONS#

[top of page]

Table: AD_FEATURE_VERSIONS

Description: Current datamodel version and status of various AD features
Comments

This table holds the current datamodel version and status of various features in AD.
FILENAME and RCS_VERSION serve as a parallel checkfile repository, specifically limited to feature-uprevving indicator files (whose names are stored in FILENAME). Its purpose is to handle situations such as changes to a feature by a patch while that feature is still being used in that patch, etc.

Indexes
Index Type Tablespace Column
AD_FEATURE_VERSIONS_U1 UNIQUE APPS_TS_TX_IDX FEATURE_NAME
AD_FEATURE_VERSIONS_U2 UNIQUE APPS_TS_TX_IDX FILENAME
Columns
Name Datatype Length Mandatory Comments
FEATURE_NAME VARCHAR2 (30) Y Feature name
CURRENT_DB_VERSION NUMBER
Y Current data-model level
ENABLED_FLAG VARCHAR2 (1) Y Y=>Enabled in the database
FILENAME VARCHAR2 (60) Y Enabling SQL file
RCS_VERSION VARCHAR2 (150) Y RCS version of the last executed FILENAME
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_FEATURE_VERSIONS does not reference any database object

APPLSYS.AD_FEATURE_VERSIONS is referenced by following:

APPLSYS
VIEW - AD_FEATURE_VERSIONS#

[top of page]

Table: AD_FILES

Description: Files repository: Oracle Applications files
Primary Key: AD_FILES_PK
  1. FILE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_CHECK_FILES.FILE_ID AD_FILES
AD_FILE_VERSIONS.FILE_ID AD_FILES
AD_PATCH_COMMON_ACTIONS.LOADER_DATA_FILE_ID AD_FILES
AD_PATCH_RUN_BUG_ACTIONS.FILE_ID AD_FILES
AD_SNAPSHOT_FILES.FILE_ID AD_FILES
AD_SNAPSHOT_FILES.CONTAINING_FILE_ID AD_FILES
Comments

AD_FILES is the "files repository". It contains information about the various files that have been patched in the Oracle Applications installation.
.
Some entries are "pseudo-files" and not real files, (eg. directories) in which case some of the columns are not applicable and would then hold the value "DUMMY".
.

Indexes
Index Type Tablespace Column
AD_FILES_U1 UNIQUE APPS_TS_TX_IDX FILE_ID
AD_FILES_U2 UNIQUE APPS_TS_TX_IDX FILENAME
SUBDIR
APP_SHORT_NAME
AD_FILES_N1 NONUNIQUE APPS_TS_TX_IDX IS_FLAGGED_FILE
Columns
Name Datatype Length Mandatory Comments
FILE_ID NUMBER
Y PK
APP_SHORT_NAME VARCHAR2 (50) Y Oracle Applications product that owns the file
SUBDIR VARCHAR2 (256) Y Subdirectory where the file resides
FILENAME VARCHAR2 (250) Y File name (without path)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
IS_FLAGGED_FILE VARCHAR2 (1)
Boolean stating if this file is customized or not.
FLAGGED_FILE_COMMENTS VARCHAR2 (4000)
Comments added for a particular customized file.

[top of page]

APPLSYS.AD_FILES does not reference any database object

APPLSYS.AD_FILES is referenced by following:

APPLSYS
VIEW - AD_FILES#

[top of page]

Table: AD_FILES_SRC_DEST_TEMP

Description: A temporary table that stores the relation between a source file and its destination.
Comments

A temporary table that stores the relation between a source file and its destination.

Columns
Name Datatype Length Mandatory Comments
SRC_FILE_ID NUMBER

Source File Id
SRC_APPS_SHORT_NAME VARCHAR2 (50)
Applications Short Name of source file
SRC_SUBDIR VARCHAR2 (256)
Source file subdirectory
SRC_FILENAME VARCHAR2 (128)
Name of source file
DEST_FILE_ID NUMBER

File _id of file at destination
DEST_APPS_SHORT_NAME VARCHAR2 (50)
Applications Short Name of file at destination
DEST_SUBDIR VARCHAR2 (256)
Subdirectory of file copy destination
DEST_FILENAME VARCHAR2 (128)
Filename at copy destination
FILE_TYPE_FLAG VARCHAR2 (1)
Mirror or Nomirror file

[top of page]

APPLSYS.AD_FILES_SRC_DEST_TEMP does not reference any database object

APPLSYS.AD_FILES_SRC_DEST_TEMP is referenced by following:

APPLSYS
VIEW - AD_FILES_SRC_DEST_TEMP#

[top of page]

Table: AD_FILE_VERSIONS

Description: File Versions repository: Versions of Oracle Applications files
Primary Key: AD_FILE_VERSIONS_PK
  1. FILE_VERSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_FILE_VERSIONS.FILE_ID AD_FILES
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_CHECK_FILES.FILE_VERSION_ID AD_FILE_VERSIONS
AD_PATCH_RUN_BUG_ACTIONS.PATCH_FILE_VERSION_ID AD_FILE_VERSIONS
AD_PATCH_RUN_BUG_ACTIONS.ONSITE_FILE_VERSION_ID AD_FILE_VERSIONS
AD_PATCH_RUN_BUG_ACTIONS.ONSITE_PKG_VERSION_IN_DB_ID AD_FILE_VERSIONS
AD_SNAPSHOT_FILES.FILE_VERSION_ID AD_FILE_VERSIONS
Comments

This table holds the various versions of Oracle Applications files (real files, not "pseudo-files"), that have ever been patched or executed in the Oracle Applications installation.
.

Indexes
Index Type Tablespace Column
AD_FILE_VERSIONS_U1 UNIQUE APPS_TS_TX_IDX FILE_VERSION_ID
AD_FILE_VERSIONS_U2 UNIQUE APPS_TS_TX_IDX FILE_ID
VERSION
TRANSLATION_LEVEL
Columns
Name Datatype Length Mandatory Comments
FILE_VERSION_ID NUMBER
Y PK
FILE_ID NUMBER
Y Identifies the file
VERSION VARCHAR2 (150) Y Version
TRANSLATION_LEVEL NUMBER
Y Indicates the relative amount/correctness of the translation (can be negative, 0 or positive)
VERSION_SEGMENT1 NUMBER

Version Segment 1 (eg. will hold 115 if the version is 115.10.2.4)
VERSION_SEGMENT2 NUMBER

Version Segment 2 (eg. will hold 10 if the version is 115.10.2.4)
VERSION_SEGMENT3 NUMBER

Version Segment3
VERSION_SEGMENT4 NUMBER

Version Segment4
VERSION_SEGMENT5 NUMBER

Version Segment5
VERSION_SEGMENT6 NUMBER

Version Segment6
VERSION_SEGMENT7 NUMBER

Version Segment7
VERSION_SEGMENT8 NUMBER

Version Segment8
VERSION_SEGMENT9 NUMBER

Version Segment9
VERSION_SEGMENT10 NUMBER

Version Segment10
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_FILE_VERSIONS does not reference any database object

APPLSYS.AD_FILE_VERSIONS is referenced by following:

APPLSYS
VIEW - AD_FILE_VERSIONS#

[top of page]

Table: AD_FIXED_ISSUES

Description: This table holds information about the bugs fixed on top of a baseline
Primary Key: AD_FIXED_ISSUES_U1
  1. BUGFIX_ID
Comments

This table holds information about the bugs fixed on top of a baseline. The driver lines with - extension fixes _bug_ _entity_ _baseline_ - is stored in this table. This information is used to identify whether a particular bug is applied or not based on the given bugfix_id

Columns
Name Datatype Length Mandatory Comments
PATCH_RUN_ID NUMBER
Y Identifies the AD_PATCH_RUNS record
BUGFIX_ID NUMBER
Y Identifies the bug_id in ad_bugs

[top of page]

APPLSYS.AD_FIXED_ISSUES does not reference any database object

APPLSYS.AD_FIXED_ISSUES is referenced by following:

APPLSYS
VIEW - AD_FIXED_ISSUES#

[top of page]

Table: AD_HIDDEN_PATCHES

Description: Stores a list of patches selected by the user to not display in the Patch Advisor UI pages when displaying recommended patches.
Comments

Stores a list of patches selected by the user to not display in the Patch Advisor UI pages when displaying recommended patches.

Indexes
Index Type Tablespace Column
AD_HIDDEN_PATCHES_U1 UNIQUE APPS_TS_TX_IDX BUG_NUMBER
Columns
Name Datatype Length Mandatory Comments
BUG_NUMBER NUMBER
Y Bug number or patch to not display
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_HIDDEN_PATCHES does not reference any database object

APPLSYS.AD_HIDDEN_PATCHES is referenced by following:

APPLSYS
VIEW - AD_HIDDEN_PATCHES#

[top of page]

Table: AD_INSTALL_PROCESSES

Description: Concurrent-sessions worker/manager communications area
Comments

AD_INSTALL_PROCESSES holds information about the jobs assigned to each worker for all the parallely (concurrently) running sessions . This table is used for communication between the manager and the worker.The managerof a session (identified by session_id) loads the job information in this table and the workers belonging to that session (identified by session_id) reads the job information and executes it.

Indexes
Index Type Tablespace Column
AD_INSTALL_PROCESSES_U1 UNIQUE APPS_TS_INTERFACE SESSION_ID
WORKER_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y Foreign Key to AD_SESSIONS.SESSION_ID
OS_PROCESS_ID NUMBER
Y OS Process Id
OS_USER_NAME VARCHAR2 (30) Y OS User Name
WORKER_ID NUMBER
Y AD Worker ID
INSTALL_GROUP_NUM NUMBER
Y INSTALL_GROUP_NUMBER
PDI_USERNAME VARCHAR2 (32) Y PDI_USERNAME
STATUS VARCHAR2 (1) Y Worker Status
CONTROL_CODE VARCHAR2 (1) Y Worker Control Code
PDI_PRODUCT VARCHAR2 (10) Y Product Executing Command
PHASE NUMBER
Y Phase
FILE_PRODUCT VARCHAR2 (10) Y File Product Owner
CONTEXT VARCHAR2 (256) Y CONTEXT
COMMAND VARCHAR2 (30) Y Action Code
SUBDIRECTORY VARCHAR2 (256) Y Directory Containing File Being Executed
FILENAME VARCHAR2 (256) Y Name of File Being Executed
ARGUMENTS VARCHAR2 (1996)
Arguments Passed to File
PHASE_NAME VARCHAR2 (30)
Phase Name
ELAPSED_TIME NUMBER

Run Time Including Restarts
START_TIME DATE

Start Time of Job
END_TIME DATE

Completion Time of Job
RESTART_TIME DATE

Time Job Restarted
RESTART_COUNT NUMBER

Number of Times Job Restarted
SKIP_FLAG VARCHAR2 (1)
Flag if Job Skipped
SYMBOLIC_ARGUMENTS VARCHAR2 (1996)
SYMBOLIC_ARGUMENTS
DEFER_COUNT NUMBER

Number of times the job is deferred

[top of page]

APPLSYS.AD_INSTALL_PROCESSES does not reference any database object

APPLSYS.AD_INSTALL_PROCESSES is referenced by following:

APPLSYS
VIEW - AD_INSTALL_PROCESSES#

[top of page]

Table: AD_INVOKER_TASKS

Description: Used for Invoker Rights processing
Comments

This table is used by the AD feature that automatically converts packages that don't have explicit AUTHID clauses to use the PL/SQL Invoker Rights feature (AUTHID_CURRENT USER).

Indexes
Index Type Tablespace Column
AD_INVOKER_TASKS_U1 UNIQUE APPS_TS_INTERFACE PHASE
OWNER
NAME
TYPE
OTHER_SCHEMA
Columns
Name Datatype Length Mandatory Comments
PHASE NUMBER
Y The logical phase in which this row will be processed
OWNER VARCHAR2 (30) Y The schema that owns the package, procedure, or function to process
NAME VARCHAR2 (128) Y The name of the package, procedure, or function to process
TYPE VARCHAR2 (30) Y The type of this object
OTHER_SCHEMA VARCHAR2 (30) Y The name of a schema that needs a (physical or logical) copy of this object
WORKER NUMBER
Y The logical worker ID of the worker that will process this row
DONE_FLAG VARCHAR2 (1)
Has this row been processed already?
AUTHID_FLAG VARCHAR2 (1)
Does the object have an explicit AUTHID clause already?
INVOKER_FLAG VARCHAR2 (1)
Is this already an Invoker Rights object?
BOUNDARY_FLAG VARCHAR2 (1)
Used to implement phase boundaries between logical phases

[top of page]

APPLSYS.AD_INVOKER_TASKS does not reference any database object

APPLSYS.AD_INVOKER_TASKS is referenced by following:

APPLSYS
VIEW - AD_INVOKER_TASKS#
SYSTEM
SYNONYM - AD_INVOKER_TASKS

[top of page]

Table: AD_JOBS_DEFERRED

Description: Hold jobs which failed during a patching session and are being deferred until the end of the phase to run again
Comments

Hold jobs which failed during a patching session and are being deferred until the end of the phase to run again

Indexes
Index Type Tablespace Column
AD_JOBS_DEFERRED_U1 UNIQUE APPS_TS_INTERFACE SESSION_ID
PHASE
FILE_PRODUCT
SUBDIRECTORY
FILENAME
ARGUMENTS
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y Session_id of the session owning the deferred job
PHASE NUMBER
Y Phase the deferred Job resides in
FILE_PRODUCT VARCHAR2 (10) Y Product owner
SUBDIRECTORY VARCHAR2 (256) Y Directory the file resides in
FILENAME VARCHAR2 (256) Y Name of deferred job filename
ARGUMENTS VARCHAR2 (1996)
Arguments passed to file
START_TIME DATE

Time job started running (for first worker it ran on)
RESTART_TIME DATE

Time job started running (forlast worker it ran on)
ELAPSED_TIME NUMBER

Total runtime for job
RESTART_COUNT NUMBER

Numer of times job was (manually) restarted
DEFER_COUNT NUMBER

Number of times job was deferred

[top of page]

APPLSYS.AD_JOBS_DEFERRED does not reference any database object

APPLSYS.AD_JOBS_DEFERRED is referenced by following:

APPLSYS
VIEW - AD_JOBS_DEFERRED#

[top of page]

Table: AD_LONG_COLUMN_CONVERSIONS

Description: Table to store the registation details of tables and columns to be migrated and table level processing status
Comments

Table to store the registation details of tables and columns to be migrated and table level processing status

Indexes
Index Type Tablespace Column
AD_LONG_COLUMN_CONVERSIONS_N1 NONUNIQUE APPS_TS_TX_IDX SCHEMA_NAME
TABLE_NAME
OLD_COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
SCHEMA_NAME VARCHAR2 (30)
Name of the schema in which the table resides
TABLE_NAME VARCHAR2 (30)
Name of the product table to be migrated.
OLD_COLUMN_NAME VARCHAR2 (30)
Name of the LONG column to be migrated
OLD_DATA_TYPE VARCHAR2 (30)
Datatype of the old column (LONG or LONG RAW)
NEW_COLUMN_NAME VARCHAR2 (30)
New column name to which the data should be migrated
NEW_DATA_TYPE VARCHAR2 (30)
Data type (CLOB, BLOB or VARCHAR2) of the new column
ACTION VARCHAR2 (20)
Attribute to show the type of action to be performed on the table (Ex: with_data, without_data, drop_column, no_action)
STATUS VARCHAR2 (30)
Current status of the migration on the table

[top of page]

APPLSYS.AD_LONG_COLUMN_CONVERSIONS does not reference any database object

APPLSYS.AD_LONG_COLUMN_CONVERSIONS is referenced by following:

APPLSYS
VIEW - AD_LONG_COLUMN_CONVERSIONS#

[top of page]

Table: AD_MANUAL_STEP_HISTORY

Description: Stores history of manual steps applied to this instance. For each manual step applied into a customer instance, there will be one entry which is stored in this table
Primary Key: AD_MANUAL_STEP_HISTORY_PK
  1. HISTORY_ID
Comments

Stores history of manual steps applied to this instance. For each step applied on a customer instance, there will be one entry which is stored in this table

Indexes
Index Type Tablespace Column
AD_MANUAL_STEP_HISTORY_U1 NONUNIQUE APPS_TS_TX_IDX STEP_KEY
STEP_VERSION
Columns
Name Datatype Length Mandatory Comments
HISTORY_ID NUMBER
Y Primary key of the table
STEP_KEY VARCHAR2 (100) Y Stores Manual Step's unique key element
STEP_VERSION VARCHAR2 (100) Y RCS Version of Manual Step
STEP_TEXT VARCHAR2 (2000)
Manual Step text
COND_CODE VARCHAR2 (2000)
Conditional Code for Manual Step
PATCH_NUMBER VARCHAR2 (100) Y The patch number for which manual step is applied
STATUS VARCHAR2 (1) Y Manual step's current status, can take either D or Y
UPDATED_BY VARCHAR2 (100)
Apps User Name

[top of page]

APPLSYS.AD_MANUAL_STEP_HISTORY does not reference any database object

APPLSYS.AD_MANUAL_STEP_HISTORY is referenced by following:

APPLSYS
VIEW - AD_MANUAL_STEP_HISTORY#

[top of page]

Table: AD_MERGED_TABLES

Description: Tables which have been DataMerged
Primary Key: AD_MERGED_TABLES_PK
  1. APPLICATION_ID
  2. TABLE_NAME
  3. ORACLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_MERGED_TABLES.APPLICATION_ID FND_APPLICATION
AD_MERGED_TABLES.ORACLE_ID FND_ORACLE_USERID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
AD_MERGED_TABLES_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
TABLE_NAME
ORACLE_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier
TABLE_NAME VARCHAR2 (30) Y multi line text fileds
ORACLE_ID NUMBER (15) Y ORACLE account identifier

[top of page]

APPLSYS.AD_MERGED_TABLES does not reference any database object

APPLSYS.AD_MERGED_TABLES is referenced by following:

APPLSYS
VIEW - AD_MERGED_TABLES#

[top of page]

Table: AD_OBSOLETE_OBJECTS

Description: This table stores plsql objects to be dropped as part of the R12 upgrade
Comments

This table stores plsql objects to be dropped as part of the R12 upgrade

Indexes
Index Type Tablespace Column
AD_OBSOLETE_OBJECTS_N1 NONUNIQUE APPS_TS_TX_IDX OBJECT_TYPE
OBJECT_NAME
APPLICATION_ID
AD_OBSOLETE_OBJECTS_N2 NONUNIQUE APPS_TS_TX_IDX APPLICATION_ID
DROPPED
OBJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Y Owner Application ID, Foreign Key to FND_APPLICATION
OBJECT_NAME VARCHAR2 (128) Y Name of the object to be dropped
OBJECT_TYPE VARCHAR2 (128) Y Object Type
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
DROPPED VARCHAR2 (1)
Has the object been dropped?

[top of page]

APPLSYS.AD_OBSOLETE_OBJECTS does not reference any database object

APPLSYS.AD_OBSOLETE_OBJECTS is referenced by following:

APPLSYS
VIEW - AD_OBSOLETE_OBJECTS#

[top of page]

Table: AD_PARALLEL_COMPILE

Description: List of invalid objects to compile in a schema
Comments

Used by the AD Parallel Compile table to list the objects in a schema
that are invalid. Contains obj# and sys_stat columns so we can
process invalid objects directly against sys$ tables in the stored
procedures used by Parallel Compile. Otherwise, we would have to run
against the DBA views, which are much slower.

Indexes
Index Type Tablespace Column
AD_PARALLEL_COMPILE_U1 UNIQUE APPS_TS_INTERFACE OBJ#
AD_PARALLEL_COMPILE_N1 NONUNIQUE APPS_TS_INTERFACE DEPEND_LEVEL
OWNER
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Y Object number from sys.obj$ (or dba_objects)
OWNER VARCHAR2 (30) Y Name of schema that owns this object
NAME VARCHAR2 (128) Y Name of object
TYPE VARCHAR2 (30) Y What type of object this is
DEPEND_LEVEL NUMBER
Y How many levels of currently-invalid objects this object depends on
WORKER_NUMBER NUMBER
Y Logical worker number
STATUS VARCHAR2 (7) Y Status of object: VALID or INVALID
SYS_STAT NUMBER
Y Numeric representation of STATUS column; used to join with SYS$ tables

[top of page]

APPLSYS.AD_PARALLEL_COMPILE does not reference any database object

APPLSYS.AD_PARALLEL_COMPILE is referenced by following:

APPLSYS
VIEW - AD_PARALLEL_COMPILE#
SYSTEM
SYNONYM - AD_PARALLEL_COMPILE

[top of page]

Table: AD_PARALLEL_COMPILE_ERRORS

Description: Used to list non-fatal errors from parallel compile
Comments

Used to list non-fatal errors trapped by the stored procedure that
compiles the invalid objects in a schema. Includes the schema,
logical worker number, and timestamp for where and when the error
ocurred.

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Y Name of the schema in which the error occurred
WORKER_NUMBER NUMBER
Y Logical worker which encountered this error
TIMESTAMP VARCHAR2 (75) Y Time error occurred, in format 'YYYY-MM-DD:HH24:MI:SS'
TYPE VARCHAR2 (30) Y What type of information the TEXT column contains
TEXT VARCHAR2 (1996) Y Descriptive text, giving information according to the TYPE column

[top of page]

APPLSYS.AD_PARALLEL_COMPILE_ERRORS does not reference any database object

APPLSYS.AD_PARALLEL_COMPILE_ERRORS is referenced by following:

APPLSYS
VIEW - AD_PARALLEL_COMPILE_ERRORS#
SYSTEM
SYNONYM - AD_PARALLEL_COMPILE_ERRORS

[top of page]

Table: AD_PARALLEL_UPDATES

Description: Used by the Large Table Updates framework
Comments

One row per parallel script

Indexes
Index Type Tablespace Column
AD_PARALLEL_UPDATES_U1 UNIQUE APPS_TS_INTERFACE UPDATE_ID
AD_PARALLEL_UPDATES_U2 UNIQUE APPS_TS_INTERFACE OWNER
TABLE_NAME
SCRIPT_NAME
Columns
Name Datatype Length Mandatory Comments
UPDATE_ID NUMBER
Y Sequence-generated ID for this update
UPDATE_TYPE NUMBER
Y Type of parallel update
OWNER VARCHAR2 (30) Y Schema that owns the table to be updated
TABLE_NAME VARCHAR2 (30) Y Name of the table to be processed
SCRIPT_NAME VARCHAR2 (30) Y Name of the script that is performing the update
OBJECT_ID NUMBER
Y Object ID for the table, from sys.obj$
DB_BLOCK_SIZE NUMBER
Y Database block size in bytes
CREATION_DATE DATE
Y Standard who column - date when this row was created.
ID_COLUMN VARCHAR2 (30)
Name of the column holding unique IDs
AVG_ROW_LEN NUMBER

Average length of a row in the table
NUM_WORKERS NUMBER

Number of workers used for updates.
INITIALIZED_FLAG VARCHAR2 (1) Y Indicates whether table has been initialized.

[top of page]

APPLSYS.AD_PARALLEL_UPDATES does not reference any database object

APPLSYS.AD_PARALLEL_UPDATES is referenced by following:

APPLSYS
VIEW - AD_PARALLEL_UPDATES#

[top of page]

Table: AD_PARALLEL_UPDATE_UNITS

Description: Used by the Large Table Updates framework
Comments
Indexes
Index Type Tablespace Column
AD_PARALLEL_UPDATE_UNITS_U1 UNIQUE APPS_TS_TX_IDX UPDATE_ID
UNIT_ID
AD_PARALLEL_UPDATE_UNITS_N1 NONUNIQUE APPS_TS_TX_IDX UPDATE_ID
STATUS
UNIT_ID
Columns
Name Datatype Length Mandatory Comments
UNIT_ID NUMBER
Y
UPDATE_ID NUMBER
Y
STATUS VARCHAR2 (1) Y
RELATIVE_FNO NUMBER

START_BLOCK NUMBER

END_BLOCK NUMBER

START_ID NUMBER

END_ID NUMBER

WORKER_ID NUMBER

START_DATE DATE

END_DATE DATE

ROWS_PROCESSED NUMBER

DATA_OBJECT_ID NUMBER

[top of page]

APPLSYS.AD_PARALLEL_UPDATE_UNITS does not reference any database object

APPLSYS.AD_PARALLEL_UPDATE_UNITS is referenced by following:

APPLSYS
VIEW - AD_PARALLEL_UPDATE_UNITS#

[top of page]

Table: AD_PARALLEL_WORKERS

Description: Used by the Large Table Updates framework
Comments

Workers for a script?

Indexes
Index Type Tablespace Column
AD_PARALLEL_WORKERS_U1 UNIQUE APPS_TS_INTERFACE UPDATE_ID
WORKER_ID
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER
Y ID for the worker
UPDATE_ID NUMBER
Y ID for the parallel update
START_UNIT_ID NUMBER
Y ID of the first unit processed by the worker
END_UNIT_ID NUMBER
Y ID of the last unit processed by the worker
START_ROWID ROWID (10)
ROWID for the first row in the unit
END_ROWID ROWID (10)
ROWID for the last row in the unit
START_ID NUMBER

ID for the first row in the unit
END_ID NUMBER

ID for the last row in the unit
ROWS_PROCESSED NUMBER

Number of rows processed by the worker for the current update.
SESSION_ID NUMBER

Not used currently
SESSION_SERIAL_NO NUMBER

Not used currently

[top of page]

APPLSYS.AD_PARALLEL_WORKERS does not reference any database object

APPLSYS.AD_PARALLEL_WORKERS is referenced by following:

APPLSYS
VIEW - AD_PARALLEL_WORKERS#

[top of page]

Table: AD_PATCH_COMMON_ACTIONS

Description: Common Actions performed by Autopatch
Primary Key: AD_PATCH_COMMON_ACTIONS_PK
  1. COMMON_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_COMMON_ACTIONS.LOADER_DATA_FILE_ID AD_FILES
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_PATCH_RUN_BUG_ACTIONS.COMMON_ACTION_ID AD_PATCH_COMMON_ACTIONS
Comments

This table holds distinct information about the various actions that are (often repeatedly) performed by Autopatch as part of applying patches.
.

Indexes
Index Type Tablespace Column
AD_PATCH_COMMON_ACTIONS_U1 UNIQUE APPS_TS_TX_IDX COMMON_ACTION_ID
AD_PATCH_COMMON_ACTIONS_U2 UNIQUE APPS_TS_TX_IDX CONCAT_ATTRIBS
AD_PATCH_COMMON_ACTIONS_N1 NONUNIQUE APPS_TS_TX_IDX ACTION_CODE
Columns
Name Datatype Length Mandatory Comments
COMMON_ACTION_ID NUMBER
Y PK
ACTION_CODE VARCHAR2 (30) Y Action code, eg. sql, exec, etc
CONCAT_ATTRIBS VARCHAR2 (3000) Y For internal use - Condensed representation of the record
ACTION_PHASE VARCHAR2 (10)
Phase component of the action statement in the patch driver
NUMERIC_PHASE NUMBER

For internal use - Numeric representation of the major phase
NUMERIC_SUB_PHASE NUMBER

For internal use - Numeric representation of the minor phase
ACTION_ARGUMENTS VARCHAR2 (2000)
Arguments component of the action statement in the patch driver
CHECKFILE_ARGS VARCHAR2 (255)
"Check-file" component of the action statement in the patch driver
ACTION_CHECK_OBJ VARCHAR2 (255)
"Check object" component of the action statement in the patch driver
ACTION_CHECK_OBJ_USERNAME VARCHAR2 (30)
"Check object username" component of the action statement in the patch driver
ACTION_CHECK_OBJ_PASSWD VARCHAR2 (30)
"Check object password" component of the action statement in the patch driver. Holds "*" if the password was hardcoded
ACTION_WHAT_SQL_EXEC VARCHAR2 (30)
"what-exec" or "what-sql" component of the action statement in the patch driver, depending on the ACTION_CODE
ACTION_TIERLIST_IN_DRIVER VARCHAR2 (50)
Comma separated list of tiers (or "all" or "none") for the "exectier" action
ACTION_LANG_CODE VARCHAR2 (4)
Language code for "genmesg" and "genwfmsg" calls in the patch driver
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LOADER_DATA_FILE_ID NUMBER

Identifies the loader data file in case of FNDLOAD, WFLOAD and akload.class calls
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_PATCH_COMMON_ACTIONS does not reference any database object

APPLSYS.AD_PATCH_COMMON_ACTIONS is referenced by following:

APPLSYS
VIEW - AD_PATCH_COMMON_ACTIONS#

[top of page]

Table: AD_PATCH_COND_HISTORY

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
COND_TE_LEVEL VARCHAR2 (150)
COND_TE_NAME VARCHAR2 (8)
CONDITION VARCHAR2 (6)
REQUIRED_LEVEL VARCHAR2 (150)
REQUIRED_TE_ABBR VARCHAR2 (8)
TRACKABLE_ENTITY_ABBR VARCHAR2 (8)
PATCH_RUN_ID NUMBER

[top of page]

APPLSYS.AD_PATCH_COND_HISTORY does not reference any database object

APPLSYS.AD_PATCH_COND_HISTORY is referenced by following:

APPLSYS
VIEW - AD_PATCH_COND_HISTORY#

[top of page]

Table: AD_PATCH_DRIVERS

Description: Patch drivers in a patch
Primary Key: AD_PATCH_DRIVERS_PK
  1. PATCH_DRIVER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_DRIVERS.APPLIED_PATCH_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_COMPRISING_PATCHES.PATCH_DRIVER_ID AD_PATCH_DRIVERS
AD_PATCH_DRIVER_LANGS.PATCH_DRIVER_ID AD_PATCH_DRIVERS
AD_PATCH_DRIVER_MINIPKS.PATCH_DRIVER_ID AD_PATCH_DRIVERS
AD_PATCH_RUNS.PATCH_DRIVER_ID AD_PATCH_DRIVERS
Comments

This table holds information about the patch drivers that comprise a patch.
.

Indexes
Index Type Tablespace Column
AD_PATCH_DRIVERS_U1 UNIQUE APPS_TS_TX_IDX PATCH_DRIVER_ID
AD_PATCH_DRIVERS_U2 UNIQUE APPS_TS_TX_IDX FILE_CONTENTS_CHECKSUM
FILE_SIZE
DRIVER_FILE_NAME
APPLIED_PATCH_ID
AD_PATCH_DRIVERS_N1 NONUNIQUE APPS_TS_TX_IDX APPLIED_PATCH_ID
AD_PATCH_DRIVERS_N2 NONUNIQUE APPS_TS_TX_IDX IMPORTED_ID
IMPORTED_FROM_DB
Columns
Name Datatype Length Mandatory Comments
PATCH_DRIVER_ID NUMBER
Y PK
APPLIED_PATCH_ID NUMBER
Y Identifies the (distinct) patch
DRIVER_FILE_NAME VARCHAR2 (30) Y Driver file name (without path)
ORIG_PATCH_NAME VARCHAR2 (120) Y Untransformed Patch Name (ie. in "begin aru/release " command)
DRIVER_TYPE_C_FLAG VARCHAR2 (1)
Y => Copy driver
DRIVER_TYPE_D_FLAG VARCHAR2 (1)
Y => Database driver
DRIVER_TYPE_G_FLAG VARCHAR2 (1)
Y => Generate driver
PLATFORM VARCHAR2 (30) Y Platform to which the patch (driver) pertains
PLATFORM_VERSION VARCHAR2 (50) Y The specific platform-version to which the patch (driver) pertains, if at all
FILE_SIZE NUMBER
Y For internal use
FILE_CONTENTS_CHECKSUM NUMBER
Y For internal use
SOURCE_CODE VARCHAR2 (3) Y Indicates whether uploaded from applptch.txt (TXT) or whether created as a result of applying a patch driver (DRV)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
IMPORTED_FLAG VARCHAR2 (1)
Y=>Imported from another database using patch-history export-import feature
IMPORTED_FROM_DB VARCHAR2 (30)
ORACLE_SID of the (source) database from which this row is imported
IMPORTED_ID NUMBER

PATCH_DRIVER_ID of the source row in the source database
MERGED_DRIVER_FLAG VARCHAR2 (1)
Y=>This driver is a merged driver (ie. merged using the admrgpch utility)
MERGE_DATE DATE

Date when this merged driver was built (if it is a merged driver)
PATCH_ABSTRACT VARCHAR2 (240)
Patch Abstract

[top of page]

APPLSYS.AD_PATCH_DRIVERS does not reference any database object

APPLSYS.AD_PATCH_DRIVERS is referenced by following:

APPLSYS
VIEW - AD_PATCH_DRIVERS#

[top of page]

Table: AD_PATCH_DRIVER_LANGS

Description: Languages to which the patch driver pertains
Primary Key: AD_PATCH_DRIVER_LANGS_PK
  1. LANG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_DRIVER_LANGS.PATCH_DRIVER_ID AD_PATCH_DRIVERS
Comments

NLS patches (or more specifically, NLS patch drivers) pertain to a language or multiple languages. This table holds that language (or multiple languages).

Indexes
Index Type Tablespace Column
AD_PATCH_DRIVER_LANGS_U1 UNIQUE APPS_TS_TX_IDX LANG_ID
AD_PATCH_DRIVER_LANGS_U2 UNIQUE APPS_TS_TX_IDX PATCH_DRIVER_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
LANG_ID NUMBER
Y PK
PATCH_DRIVER_ID NUMBER
Y Identifies the patch driver
LANGUAGE VARCHAR2 (4) Y Language
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_PATCH_DRIVER_LANGS does not reference any database object

APPLSYS.AD_PATCH_DRIVER_LANGS is referenced by following:

APPLSYS
VIEW - AD_PATCH_DRIVER_LANGS#

[top of page]

Table: AD_PATCH_DRIVER_MINIPKS

Description: Mini Packs contained in a patch (driver)
Primary Key: AD_PATCH_DRIVER_MINIPKS_PK
  1. MINIPK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_DRIVER_MINIPKS.PATCH_DRIVER_ID AD_PATCH_DRIVERS
Comments

This table holds information about the various Mini Packs contained in a patch (driver)

Indexes
Index Type Tablespace Column
AD_PATCH_DRIVER_MINIPKS_U1 UNIQUE APPS_TS_TX_IDX MINIPK_ID
AD_PATCH_DRIVER_MINIPKS_U2 UNIQUE APPS_TS_TX_IDX PATCH_DRIVER_ID
APP_SHORT_NAME
AD_PATCH_DRIVER_MINIPKS_N1 NONUNIQUE APPS_TS_TX_IDX PATCH_LEVEL
Columns
Name Datatype Length Mandatory Comments
MINIPK_ID NUMBER
Y PK
PATCH_DRIVER_ID NUMBER
Y Identifies the patch driver
APP_SHORT_NAME VARCHAR2 (50) Y Identifies the Oracle Applications product
PATCH_LEVEL VARCHAR2 (30) Y Mini Pack level
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_PATCH_DRIVER_MINIPKS does not reference any database object

APPLSYS.AD_PATCH_DRIVER_MINIPKS is referenced by following:

APPLSYS
VIEW - AD_PATCH_DRIVER_MINIPKS#

[top of page]

Table: AD_PATCH_HIST_SNAPS_TEMP

Description: Temporary staging table for updating snapshots
Comments

AD_PATCH_HIST_SNAPS_TEMP is a temporary staging table for updating the "current-view" snapshot using information from the patch-history tables. It is used internally by Autopatch.
.
Autopatch does this by populating the PATCH_RUN_ID and ACTION_CODE columns, and then it calls the PL/SQL package AD_FILE_SYS_SNAPSHOTS_PKG.Update_Current_View.
.
The PL/SQL package in turn creates lots of intermediate rows as part of its processing, and the remaining columns of the table are relevant for that processing.

Indexes
Index Type Tablespace Column
AD_PATCH_HIST_SNAPS_TEMP_N1 NONUNIQUE APPS_TS_INTERFACE ACTION_CODE
AD_PATCH_HIST_SNAPS_TEMP_N2 NONUNIQUE APPS_TS_INTERFACE BUG_ID
AD_PATCH_HIST_SNAPS_TEMP_N3 NONUNIQUE APPS_TS_INTERFACE FILE_ID
Columns
Name Datatype Length Mandatory Comments
PATCH_RUN_ID NUMBER

Identifies the specific patch-run's history row, whose information is to be used to update the current-view snapshot
BUG_ID NUMBER

Bugfix identifier
ACTION_CODE NUMBER

Code indicating what kind of row this is
FILE_ID NUMBER

File identifier
APP_SHORT_NAME VARCHAR2 (50)
Application short name of the file's owning product. Helps in populating CLIB_ARCH_FILE_ID. Relevant only if any file was copied by the patch
FILENAME VARCHAR2 (250)
File name. Helps in populating CLIB_ARCH_FILE_ID. Relevant only if any file was copied by the patch
FILE_VERSION_ID NUMBER

File version identifier. Relevant only if any file was copied by the patch
VERSION_SEGMENT1 NUMBER

Version segment 1. Relevant only if any file was copied by the patch
VERSION_SEGMENT2 NUMBER

Version segment 2. Relevant only if any file was copied by the patch
VERSION_SEGMENT3 NUMBER

Version segment 3. Relevant only if any file was copied by the patch
VERSION_SEGMENT4 NUMBER

Version segment 4. Relevant only if any file was copied by the patch
VERSION_SEGMENT5 NUMBER

Version segment 5. Relevant only if any file was copied by the patch
VERSION_SEGMENT6 NUMBER

Version segment 6. Relevant only if any file was copied by the patch
VERSION_SEGMENT7 NUMBER

Version segment 7. Relevant only if any file was copied by the patch
VERSION_SEGMENT8 NUMBER

Version segment 8. Relevant only if any file was copied by the patch
VERSION_SEGMENT9 NUMBER

Version segment 9. Relevant only if any file was copied by the patch
VERSION_SEGMENT10 NUMBER

Version segment 10. Relevant only if any file was copied by the patch
TRANSLATION_LEVEL NUMBER

Translation level. Relevant only if any file was copied by the patch
CLIB_ARCH_FILE_ID NUMBER

File identifier of the C archive library that contains the file identified by FILE_ID. Helps in populating the CONTAINING_FILE_ID column in AD_SNAPSHOT_FILES. Relevant only if the file is a C object file copied by the patch
DEST_FILE_ID NUMBER

File_id for a file in its copy destination location
FILE_TYPE_FLAG VARCHAR2 (1)
Mirror or NoMirror Flag
IREP_GATHERED_FLAG VARCHAR2 (1)
Flag determining if the file has been processed by the Interface Repository

[top of page]

APPLSYS.AD_PATCH_HIST_SNAPS_TEMP does not reference any database object

APPLSYS.AD_PATCH_HIST_SNAPS_TEMP is referenced by following:

APPLSYS
VIEW - AD_PATCH_HIST_SNAPS_TEMP#

[top of page]

Table: AD_PATCH_HIST_TEMP

Description: Temporary staging table for recording patch-history
Comments

AD_PATCH_HIST_TEMP is a temporary staging table for recording information in the patch-history tables. It is used internally by Autopatch.
.
Autopatch populates this table and then calls the PL/SQL package AD_FILE_UTIL.Load_Patch_Hist_Action.
.

Indexes
Index Type Tablespace Column
AD_PATCH_HIST_TEMP_N1 NONUNIQUE APPS_TS_INTERFACE LOADER_DATA_FILE_ID
Columns
Name Datatype Length Mandatory Comments
PATCH_RUN_ID NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
BUG_NUMBER VARCHAR2 (30)
Temporary staging area for column values meant to be stored in AD patch history tables
ARU_RELEASE_NAME VARCHAR2 (30)
Temporary staging area for column values meant to be stored in AD patch history tables
ORIG_BUG_NUMBER VARCHAR2 (30)
Temporary staging area for column values meant to be stored in AD patch history tables
APPLIED_FLAG VARCHAR2 (1)
Temporary staging area for column values meant to be stored in AD patch history tables
REASON_NOT_APPLIED VARCHAR2 (250)
Temporary staging area for column values meant to be stored in AD patch history tables
BUG_APP_SHORT_NAME VARCHAR2 (50)
Temporary staging area for column values meant to be stored in AD patch history tables
SUCCESS_FLAG VARCHAR2 (1)
Temporary staging area for column values meant to be stored in AD patch history tables
BUG_ID NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_RUN_BUG_ID NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
FILENAME VARCHAR2 (250)
Temporary staging area for column values meant to be stored in AD patch history tables
FILE_ID NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
FILE_SUBDIR VARCHAR2 (256)
Temporary staging area for column values meant to be stored in AD patch history tables
FILE_APPS_SHORT_NAME VARCHAR2 (50)
Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_FILE_VERS_ID NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT1 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT2 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT3 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT4 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT5 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT6 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT7 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT8 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT9 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT10 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_FILE_VERS_ID NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT1 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT2 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT3 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT4 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT5 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT6 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT7 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT8 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT9 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT10 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_FILE_VERS_ID NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT1 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT2 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT3 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT4 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT5 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT6 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT7 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT8 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT9 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT10 NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_FILE_VERS VARCHAR2 (150)
Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_FILE_VERS VARCHAR2 (150)
Temporary staging area for column values meant to be stored in AD patch history tables
DB_FILE_VERS VARCHAR2 (150)
Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_TRANS_LEVEL NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_TRANS_LEVEL NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
DB_TRANS_LEVEL NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
COMMON_ACTION_ID NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_CODE VARCHAR2 (30)
Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_PHASE VARCHAR2 (10)
Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_ARGUMENTS VARCHAR2 (2000)
Temporary staging area for column values meant to be stored in AD patch history tables
CHECKFILE_ARGS VARCHAR2 (255)
Temporary staging area for column values meant to be stored in AD patch history tables
CHECKOBJ VARCHAR2 (255)
Temporary staging area for column values meant to be stored in AD patch history tables
CHECKOBJ_UN VARCHAR2 (30)
Temporary staging area for column values meant to be stored in AD patch history tables
CHECKOBJ_PW VARCHAR2 (30)
Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_MODIFIER VARCHAR2 (30)
Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_TIERLIST VARCHAR2 (50)
Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_LANG_CODE VARCHAR2 (4)
Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_EXECUTED_FLAG VARCHAR2 (1)
Temporary staging area for column values meant to be stored in AD patch history tables
CONCAT_ATTRIBS VARCHAR2 (3000)
Temporary staging area for column values meant to be stored in AD patch history tables
MAJOR_PHASE NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
MINOR_PHASE NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
LOADER_DATA_FILE_ID NUMBER

Temporary staging area for column values meant to be stored in AD patch history tables
LDR_FILENAME VARCHAR2 (250)
Temporary staging area for column values meant to be stored in AD patch history tables
LDR_SUBDIR VARCHAR2 (256)
Temporary staging area for column values meant to be stored in AD patch history tables
LDR_APP_SHORT_NAME VARCHAR2 (50)
Temporary staging area for column values meant to be stored in AD patch history tables
DEST_APPS_SHORT_NAME VARCHAR2 (50)
Applications Short Name of file at destination
DEST_FILE_ID NUMBER

File _id of file at destination
DEST_SUBDIR VARCHAR2 (256)
Subdirectory of file copy destination
DEST_FILENAME VARCHAR2 (250)
Filename at copy destination
FILE_TYPE_FLAG VARCHAR2 (1)
Mirror or Nomirror file
GENERIC_PATCH VARCHAR2 (1)
Flag to indentify generic patches
BASELINE_NAME VARCHAR2 (150)
Holds the baseline name of the patch
TRACKABLE_ENTITY_NAME VARCHAR2 (50)
LANGUAGE VARCHAR2 (4)

[top of page]

APPLSYS.AD_PATCH_HIST_TEMP does not reference any database object

APPLSYS.AD_PATCH_HIST_TEMP is referenced by following:

APPLSYS
VIEW - AD_PATCH_HIST_TEMP#

[top of page]

Table: AD_PATCH_RUNS

Description: High level Autopatch history, one row per driver applied
Primary Key: AD_PATCH_RUNS_PK
  1. PATCH_RUN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_RUNS.RELEASE_ID AD_RELEASES
AD_PATCH_RUNS.UPDATED_TO_RELEASE_ID AD_RELEASES
AD_PATCH_RUNS.APPL_TOP_ID AD_APPL_TOPS
AD_PATCH_RUNS.PATCH_DRIVER_ID AD_PATCH_DRIVERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_PATCH_RUN_BUGS.PATCH_RUN_ID AD_PATCH_RUNS
Comments

AD_PATCH_RUNS holds information about the various invocations of Autopatch for applying Oracle Applications patches to a specific release of an Oracle Applications installation.
If multiple drivers are run in one invocation of Autopatch, they result in multiple records in this table. These multiple records will all have the same SESSION_ID (because they arose from one Autopatch invocation), but different TASK_NUMBER's. The TASK_NUMBER's in this case will be numbered sequentially as 1, 2, 3, etc.
Note that when the database driver of a Maintenance Pack is applied, it bumps up the release version by creating a new record in AD_RELEASES, which is then pointed to by the UPDATED_TO_RELEASE_ID column of the old record.

Indexes
Index Type Tablespace Column
AD_PATCH_RUNS_U1 UNIQUE APPS_TS_TX_IDX PATCH_RUN_ID
AD_PATCH_RUNS_U2 UNIQUE APPS_TS_TX_IDX START_DATE
APPL_TOP_ID
PATCH_DRIVER_ID
AD_PATCH_RUNS_N1 NONUNIQUE APPS_TS_TX_IDX END_DATE
AD_PATCH_RUNS_N2 NONUNIQUE APPS_TS_TX_IDX PATCH_DRIVER_ID
AD_PATCH_RUNS_N3 NONUNIQUE APPS_TS_TX_IDX UPDATED_TO_RELEASE_ID
Columns
Name Datatype Length Mandatory Comments
PATCH_RUN_ID NUMBER
Y PK
RELEASE_ID NUMBER
Y Identifies the Oracle Applications Release on which this patch was applied
SESSION_ID NUMBER
Y Identifies the Autopatch session. See table description for details
RAPID_INSTALL_FLAG VARCHAR2 (1)
Y implies that this record was created at Oracle Corporation when building a Rapid Install database
UPDATED_TO_RELEASE_ID NUMBER

See table description
PATCH_TOP VARCHAR2 (250) Y Directory where patch was unloaded
START_DATE DATE
Y Date and time when Autopatch started applying the patch
END_DATE DATE

Date and time when Autopatch completed applying the patch
PATCH_DRIVER_ID NUMBER
Y Identifies the patch driver that was run in this invocation of Autopatch
PATCH_ACTION_OPTIONS VARCHAR2 (250)
Arguments of the "options" keyword when Autopatch was invoked
APPS_SYSTEM_NAME VARCHAR2 (8)
Obsoleted
APPL_TOP_ID NUMBER
Y Identifies the APPL_TOP on which the patch was applied
SERVER_TYPE_ADMIN_FLAG VARCHAR2 (1)
Y => The APPL-TOP implemented the "Admin" server when this patch was applied
SERVER_TYPE_FORMS_FLAG VARCHAR2 (1)
Y => The APPL-TOP implements the "Forms" server when this patch was applied
SERVER_TYPE_NODE_FLAG VARCHAR2 (1)
Y => The APPL-TOP implements the "Concurrent Processing" server when this patch was applied
SERVER_TYPE_WEB_FLAG VARCHAR2 (1)
Y => The APPL-TOP implements the "Web" server when this patch was applied
SOURCE_CODE VARCHAR2 (3) Y Indicates whether uploaded from applptch.txt (TXT) or whether created as a result of applying a patch driver (DRV)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
SUCCESS_FLAG VARCHAR2 (1) Y Y => the patch was successful
FAILURE_COMMENTS VARCHAR2 (255)
User entered comments when flagging a patch as unsuccessful
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
IMPORTED_FLAG VARCHAR2 (1)
Y=>Imported from another database using patch-history export-import feature
IMPORTED_FROM_DB VARCHAR2 (30)
ORACLE_SID of the (source) database from which this row is imported
IMPORTED_ID NUMBER

PATCH_RUN_ID of the source row in the source database
IMPORT_SESSION_ID NUMBER

Identifies the import session that was responsible for importing this row, if this is an imported row (which is also embedded in the import utility's log file name)
TASK_NUMBER NUMBER

Task number. See table description for details
PROGRAM_RUN_ID NUMBER

This column relates the information in this table to that present in AD_PROGRAM_RUN_TASKS, AD_PATCH_RUN_SESS_ATTRIBS & AD_PROGRAM_RUN_TASK_JOBS

[top of page]

APPLSYS.AD_PATCH_RUNS does not reference any database object

APPLSYS.AD_PATCH_RUNS is referenced by following:

APPLSYS
VIEW - AD_PATCH_RUNS#

[top of page]

Table: AD_PATCH_RUN_BUGS

Description: Bugs fixed in a specific run of Autopatch
Primary Key: AD_PATCH_RUN_BUGS_PK
  1. PATCH_RUN_BUG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_RUN_BUGS.PATCH_RUN_ID AD_PATCH_RUNS
AD_PATCH_RUN_BUGS.BUG_ID AD_BUGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_PATCH_RUN_BUG_ACTIONS.PATCH_RUN_BUG_ID AD_PATCH_RUN_BUGS
Comments

This table holds information about the bugs fixed in a specific run of Autopatch.
.
AD_PATCH_RUN_BUGS holds information about the various bugs fixed in a specific run of Autopatch.
.
Even though a patch may have been applied on an Oracle Applications installation, some bugs (fixes) contained in it may not get applied due to some reason. In such cases, the REASON_NOT_APPLIED column holds the reason.
.

Indexes
Index Type Tablespace Column
AD_PATCH_RUN_BUGS_U1 UNIQUE APPS_TS_TX_IDX PATCH_RUN_BUG_ID
AD_PATCH_RUN_BUGS_U2 UNIQUE APPS_TS_TX_IDX PATCH_RUN_ID
BUG_ID
ORIG_BUG_NUMBER
APPLICATION_SHORT_NAME
AD_PATCH_RUN_BUGS_N1 NONUNIQUE APPS_TS_TX_IDX BUG_ID
Columns
Name Datatype Length Mandatory Comments
PATCH_RUN_BUG_ID NUMBER
Y PK
PATCH_RUN_ID NUMBER
Y Identifies the AD_PATCH_RUNS record
BUG_ID NUMBER
Y Identifies the bug
ORIG_BUG_NUMBER VARCHAR2 (30) Y The bug number as stated in the "begin bug" line in the patch driver
APPLIED_FLAG VARCHAR2 (1) Y N => Autopatch did not attempt to apply this bug (fix)
REASON_NOT_APPLIED VARCHAR2 (250)
Reason why the bug (fix) was not applied. See table description
CREATION_DATE DATE
Y Standard who column - date when this row was created.
APPLICATION_SHORT_NAME VARCHAR2 (50) Y The application short name of the product whose development team created this bugfix
SUCCESS_FLAG VARCHAR2 (1) Y Y => the bug fix in this run of Autopatch was successfully applied
FAILURE_COMMENTS VARCHAR2 (255)
User entered comments when flagging a bug (fix) as unsuccessful
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_PATCH_RUN_BUGS does not reference any database object

APPLSYS.AD_PATCH_RUN_BUGS is referenced by following:

APPLSYS
VIEW - AD_PATCH_RUN_BUGS#

[top of page]

Table: AD_PATCH_RUN_BUG_ACTIONS

Description: Actions included in a bug (fix)
Primary Key: AD_PATCH_RUN_BUG_ACTIONS_PK
  1. ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_RUN_BUG_ACTIONS.PATCH_RUN_BUG_ID AD_PATCH_RUN_BUGS
AD_PATCH_RUN_BUG_ACTIONS.COMMON_ACTION_ID AD_PATCH_COMMON_ACTIONS
AD_PATCH_RUN_BUG_ACTIONS.FILE_ID AD_FILES
AD_PATCH_RUN_BUG_ACTIONS.PATCH_FILE_VERSION_ID AD_FILE_VERSIONS
AD_PATCH_RUN_BUG_ACTIONS.ONSITE_FILE_VERSION_ID AD_FILE_VERSIONS
AD_PATCH_RUN_BUG_ACTIONS.ONSITE_PKG_VERSION_IN_DB_ID AD_FILE_VERSIONS
Comments

AD_PATCH_RUN_BUG_ACTIONS holds the various actions present in "applied" bug (fix). If Autopatch determined not to apply a bug (fix), then this table will not hold any records for that "unapplied" bug fix.
.
Even though a patch may have been applied on an Oracle Applications installation, some actions in some of its included bugs (fixes) may not have got executed if the "Autopatch" utility determined that it was not necessary to execute those actions. In such cases, EXECUTED_FLAG is set to N.
.

Indexes
Index Type Tablespace Column
AD_PATCH_RUN_BUG_ACTIONS_U1 UNIQUE APPS_TS_TX_IDX ACTION_ID
AD_PATCH_RUN_BUG_ACTIONS_U2 UNIQUE APPS_TS_TX_IDX PATCH_RUN_BUG_ID
FILE_ID
COMMON_ACTION_ID
AD_PATCH_RUN_BUG_ACTIONS_N1 NONUNIQUE APPS_TS_TX_IDX COMMON_ACTION_ID
AD_PATCH_RUN_BUG_ACTIONS_N2 NONUNIQUE APPS_TS_TX_IDX FILE_ID
Columns
Name Datatype Length Mandatory Comments
ACTION_ID NUMBER
Y PK
PATCH_RUN_BUG_ID NUMBER
Y Identifies the AD_PATCH_RUN_BUGS record
FILE_ID NUMBER
Y Identifies the file
COMMON_ACTION_ID NUMBER
Y Identifies the action
PATCH_FILE_VERSION_ID NUMBER

Identifies the file version in the patch
ONSITE_FILE_VERSION_ID NUMBER

Identifies the onsite file version
ONSITE_PKG_VERSION_IN_DB_ID NUMBER

Applicable to package creation scripts. Identifies the version of the package in the database
EXECUTED_FLAG VARCHAR2 (1) Y See table description
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
DEST_FILE_ID NUMBER

FILE_ID of a file in its copy location
FILE_TYPE_FLAG VARCHAR2 (1)
Mirror or Nomirror Flag

[top of page]

APPLSYS.AD_PATCH_RUN_BUG_ACTIONS does not reference any database object

APPLSYS.AD_PATCH_RUN_BUG_ACTIONS is referenced by following:

APPLSYS
VIEW - AD_PATCH_RUN_BUG_ACTIONS#

[top of page]

Table: AD_PATCH_RUN_SESS_ATTRIBS

Description: This table stores values of different attributes, for different runs of ad utilities.
Comments

This table stores values of different attributes, for different runs of ad utilities.

Indexes
Index Type Tablespace Column
AD_PATCH_RUN_SESS_ATTRIBS_U1 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_NAME
PROGRAM_RUN_ID
SESSION_ID
AD_PATCH_RUN_SESS_ATTRIBS_N1 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
PROGRAM_RUN_ID NUMBER
Y A number that distinguishes the different runs of ad utilities, when the information is moved from in progress to history.
SESSION_ID NUMBER
Y The session_id of the particular run of ad utility.
ATTRIBUTE_NAME VARCHAR2 (50) Y Name of the attribute that corresponds to the run of ad utility.
ATTRIBUTE_VALUE VARCHAR2 (300) Y Value of the attribute that corresponds to the run of ad utility.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PATCH_RUN_SESS_ATTRIBS does not reference any database object

APPLSYS.AD_PATCH_RUN_SESS_ATTRIBS is referenced by following:

APPLSYS
VIEW - AD_PATCH_RUN_SESS_ATTRIBS#

[top of page]

Table: AD_PA_ANALYSIS_RUNS

Description: Stores the history of Requirement Set Analyis Runs
Comments

Stores the history of Requirement Set Analyis Runs

Indexes
Index Type Tablespace Column
AD_PA_ANALYSIS_RUNS_U1 UNIQUE APPS_TS_TX_IDX ANALYSIS_RUN_ID
AD_PA_ANALYSIS_RUNS_U2 NONUNIQUE APPS_TS_TX_IDX REQUEST_SET_ID
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_RUN_ID NUMBER
Y Request Id generated by Submitting Request Analysis
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
ADVISOR_CRITERIA_ID VARCHAR2 (80)
ID for filter used to narrow list of patches to consider in InfoBundle.
PATCH_LIST VARCHAR2 (240)
List of individual patches to analyze
ANALYSIS_RUN_PHASE NUMBER

Used internally by analysis program
REQUEST_SET_ID NUMBER

Concurrent Request set id for the particular run of request

[top of page]

APPLSYS.AD_PA_ANALYSIS_RUNS does not reference any database object

APPLSYS.AD_PA_ANALYSIS_RUNS is referenced by following:

APPLSYS
VIEW - AD_PA_ANALYSIS_RUNS#

[top of page]

Table: AD_PA_ANALYSIS_RUN_BUGS

Description: List of bugs resulting from criteria analysis run
Comments

List of bugs resulting from criteria analysis run

Indexes
Index Type Tablespace Column
AD_PA_ANALYSIS_RUN_BUGS_U1 UNIQUE APPS_TS_TX_IDX ANALYSIS_RUN_ID
BUG_NUMBER
BASELINE
AD_PA_ANALYSIS_RUN_BUGS_N1 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_RUN_ID NUMBER
Y Foreign Key to FND_CONCURRENT_REQUESTS.JOB_ID
APPL_TOP_ID NUMBER
Y Foreign Key to AD_APPL_TOPS
BUG_NUMBER NUMBER
Y Bug Number resulting from analysis run
IS_HIGH_PRIORITY VARCHAR2 (1) Y Is the patch resulting from the analysis a high priority
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
PRODUCT_ABBREVIATION VARCHAR2 (15)
Foreign Key to AD_PM_PRODUCT_INFO
ANALYSIS_STATUS VARCHAR2 (80)
APPLIED,READY,MISSING,OBSOLETE
RECOMMENDED_PATCH_TYPE VARCHAR2 (4)
Stores the type of the recommended patch.
REQUEST_SET_ID NUMBER

Request set id for a particluar request of patch analysis.
BASELINE VARCHAR2 (150)
Baseline of the patch
ANALYSIS_RUN_BUG_ID NUMBER

Primary Key (generated from sequence
HAS_MSI_STEPS VARCHAR2 (1)
Does the patch contain MSI steps?

[top of page]

APPLSYS.AD_PA_ANALYSIS_RUN_BUGS does not reference any database object

APPLSYS.AD_PA_ANALYSIS_RUN_BUGS is referenced by following:

APPLSYS
VIEW - AD_PA_ANALYSIS_RUN_BUGS#

[top of page]

Table: AD_PA_ANAL_BUG_DEPS

Description: Stores the dependencies for bugs resulting from Criteria Analysis run
Comments

Stores the dependencies for bugs resulting from Criteria Analysis run

Indexes
Index Type Tablespace Column
AD_PA_ANAL_BUG_DEPS_U1 UNIQUE APPS_TS_TX_IDX ANALYSIS_RUN_ID
BUG_NUMBER
APPL_TOP_ID
PREREQ_BUG_NUMBER
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_RUN_ID NUMBER
Y Foreign Key to FND_CONCURRENT_REQUESTS.JOB_ID
APPL_TOP_ID NUMBER
Y Foreign Key to AD_APPL_TOPS
BUG_NUMBER NUMBER
Y Primary Key
PREREQ_BUG_NUMBER NUMBER
Y Prereq Bug Number
PREREQ_BUG_ORDER NUMBER
Y Order in which dependencies need to be applied
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PA_ANAL_BUG_DEPS does not reference any database object

APPLSYS.AD_PA_ANAL_BUG_DEPS is referenced by following:

APPLSYS
VIEW - AD_PA_ANAL_BUG_DEPS#

[top of page]

Table: AD_PA_ANAL_RUN_BUG_CODELEVELS

Description: Detailed table for new Codelevels introduced by recommended patchsets or latest Codelevel patches for a particular run
Primary Key: AD_PA_ANAL_RUN_BUG_CODELEVELS_
  1. ANALYSIS_RUN_BUG_ID
  2. INTR_TE_ABBR
Comments

Detailed table for new Codelevels introduced by recommended patchsets or latest Codelevel patches for a particular run

Columns
Name Datatype Length Mandatory Comments
ANALYSIS_RUN_BUG_ID NUMBER
Y Foreign Key to AD_PA_ANALYSIS_RUN_BUGS
INTR_TE_ABBR VARCHAR2 (30) Y Abbreviation of the introducing entity
INTR_TE_BASELINE VARCHAR2 (150)
Baseline of the introducing entity
INTR_TE_LEVEL VARCHAR2 (150)
Codelevel of the introducing entity
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
INTR_TE_TYPE VARCHAR2 (30)
Type of the introducing entity (Product, Product Family, etc)
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PA_ANAL_RUN_BUG_CODELEVELS does not reference any database object

APPLSYS.AD_PA_ANAL_RUN_BUG_CODELEVELS is referenced by following:

APPLSYS
VIEW - AD_PA_ANAL_RUN_BUG_CODELEVELS#

[top of page]

Table: AD_PA_ANAL_RUN_BUG_PREREQS

Description: Detailed table for pre-requisite Codelevels for a particular patch by recommended patchsets or latest Codelevel patches for a particular run
Primary Key: AD_PA_ANAL_RUN_BUG_PREREQS_PK
  1. ANALYSIS_RUN_BUG_ID
  2. PREREQ_TE_ABBR
Comments

Detailed table for pre-requisite Codelevels for a particular patch by recommended patchsets or latest Codelevel patches for a particular run

Columns
Name Datatype Length Mandatory Comments
ANALYSIS_RUN_BUG_ID NUMBER
Y Foreign Key to AD_PA_ANALYSIS_RUN_BUGS
PREREQ_TE_ABBR VARCHAR2 (30) Y Abbreviation of the pre-requisite entity
PREREQ_TE_LEVEL VARCHAR2 (150) Y Minimum Codelevel of the pre-requisite entity
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PA_ANAL_RUN_BUG_PREREQS does not reference any database object

APPLSYS.AD_PA_ANAL_RUN_BUG_PREREQS is referenced by following:

APPLSYS
VIEW - AD_PA_ANAL_RUN_BUG_PREREQS#

[top of page]

Table: AD_PA_ANAL_RUN_PREFERENCES

Description: Stores the user preferences for download options, platforms and languages for a particular request..
Comments

Stores the user preferences for download options, platforms and languages for a particular request..

Indexes
Index Type Tablespace Column
AD_PA_ANAL_RUN_PREFERENCES_U1 UNIQUE APPS_TS_TX_IDX ANALYSIS_RUN_ID
OPTION_TYPE
OPTION_VALUE
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_RUN_ID NUMBER
Y Request id for a particular run of Download Patches.
OPTION_TYPE VARCHAR2 (30) Y Key of the option like patchlist, mergename, etc
OPTION_VALUE VARCHAR2 (240) Y Value of the option like patchlist, mergename, etc
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PA_ANAL_RUN_PREFERENCES does not reference any database object

APPLSYS.AD_PA_ANAL_RUN_PREFERENCES is referenced by following:

APPLSYS
VIEW - AD_PA_ANAL_RUN_PREFERENCES#

[top of page]

Table: AD_PA_CRITERIA

Description: Stores the requirement set from the Maintain Requirement Set page
Comments

Stores the requirement set from the Maintain Requirement Set page

Indexes
Index Type Tablespace Column
AD_PA_CRITERIA_U1 UNIQUE APPS_TS_TX_IDX ADVISOR_CRITERIA_ID
Columns
Name Datatype Length Mandatory Comments
ADVISOR_CRITERIA_ID VARCHAR2 (80) Y Primary Key
PRE_SEEDED_FLAG VARCHAR2 (1) Y Y for Oracle seeded criteria, N for User defined criteria
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
ADVISOR_CRITERIA_DESCRIPTION VARCHAR2 (80)
Description of Criteria Set

[top of page]

APPLSYS.AD_PA_CRITERIA does not reference any database object

APPLSYS.AD_PA_CRITERIA is referenced by following:

APPLSYS
VIEW - AD_PA_CRITERIA#

[top of page]

Table: AD_PA_CRITERIA_PRODUCTS

Description: Seeded values for criteria creation
Comments

Seeded values for criteria creation

Indexes
Index Type Tablespace Column
AD_PA_CRITERIA_PRODUCTS_U1 UNIQUE APPS_TS_TX_IDX ADVISOR_CRITERIA_ID
PRODUCT_ABBREVIATION
Columns
Name Datatype Length Mandatory Comments
ADVISOR_CRITERIA_ID VARCHAR2 (80) Y Foreign key to AD_PA_CRITERIA
PRODUCT_ABBREVIATION VARCHAR2 (15) Y Primary Key
REQUIRE_FAMILY_PACK VARCHAR2 (1) Y Flag for criteria to require Family Pack
REQUIRE_MINI_PACK VARCHAR2 (1) Y Flag for criteria to require Mini Pack
REQUIRE_HIGH_PRIORITY VARCHAR2 (1) Y Flag for criteria to require High Priority Patches
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
PRODUCT_FAMILY_ABBREVIATION VARCHAR2 (15)
Abbreviation for the Primary Product Family for the product

[top of page]

APPLSYS.AD_PA_CRITERIA_PRODUCTS does not reference any database object

APPLSYS.AD_PA_CRITERIA_PRODUCTS is referenced by following:

APPLSYS
VIEW - AD_PA_CRITERIA_PRODUCTS#

[top of page]

Table: AD_PA_CRITERIA_PROD_FAMS

Description: Stores criteria for Patch Advisor used when determining what types of patches should be applied for given products
Comments

Stores criteria for Patch Advisor used when determining what types of patches should be applied for given products

Indexes
Index Type Tablespace Column
AD_PA_CRITERIA_PROD_FAMS_U1 UNIQUE APPS_TS_TX_IDX ADVISOR_CRITERIA_ID
PRODUCT_FAMILY_ABBREVIATION
Columns
Name Datatype Length Mandatory Comments
ADVISOR_CRITERIA_ID VARCHAR2 (80) Y User defined Patch filter name
PRODUCT_FAMILY_ABBREVIATION VARCHAR2 (30) Y Product family abbreviation
RECOMMENDED_PATCH_FLAG VARCHAR2 (4) Y Flag to mark selection of Recommend Patches for a particular Product family
NEW_CODE_LEVEL_FLAG VARCHAR2 (4) Y Flag to mark selection of New Code level for a particular Product family
LICENSED_FLAG VARCHAR2 (4) Y Flag to mark the Licensed Products
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PA_CRITERIA_PROD_FAMS does not reference any database object

APPLSYS.AD_PA_CRITERIA_PROD_FAMS is referenced by following:

APPLSYS
VIEW - AD_PA_CRITERIA_PROD_FAMS#

[top of page]

Table: AD_PA_ENTITY_INFO

Description: Master table to store the entity information of all the entities in Patch Wizard
Primary Key: AD_PA_ENTITY_INFO_PK
  1. TE_ABBR
Comments

Master table to store the entity information of all the entities in Patch Wizard

Columns
Name Datatype Length Mandatory Comments
TE_ABBR VARCHAR2 (30) Y Abbreviation of the entity
TE_NAME VARCHAR2 (50)
Name of the entity
TE_TYPE VARCHAR2 (30)
Type of the entity (Product, Product Family, etc)
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PA_ENTITY_INFO does not reference any database object

APPLSYS.AD_PA_ENTITY_INFO is referenced by following:

APPLSYS
VIEW - AD_PA_ENTITY_INFO#

[top of page]

Table: AD_PA_PATCH_COND_REQUIRES_INFO

Description: Detailed table to store the conditional pre-requisite codelevel information of a patch from patch_metadata.xml
Primary Key: AD_PA_PATCH_COND_REQS_INFO_PK
  1. PATCH_COND_REQUIRES_ID
Comments

Detailed table to store the conditional pre-requisite codelevel information of a patch from patch_metadata.xml

Indexes
Index Type Tablespace Column
AD_PA_PATCH_COND_REQS_INFO_U1 NONUNIQUE APPS_TS_TX_IDX PATCH_REQUIRES_ID
CONDITION_TYPE
CONDITION_TE_ABBR
CONDITION_TE_LEVEL
Columns
Name Datatype Length Mandatory Comments
PATCH_COND_REQUIRES_ID NUMBER
Y Primary Key
PATCH_REQUIRES_ID NUMBER
Y Foreign Key to AD_PA_PATCH_REQUIRES_INFO
CONDITION_TYPE VARCHAR2 (30) Y Requires Condition type (IFUSED, IFLOAD)
CONDITION_TE_ABBR VARCHAR2 (30) Y Abbreviation of the conditional requires entity
CONDITION_TE_LEVEL VARCHAR2 (150) Y Minimum Codelevel of the conditional requires entity
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PA_PATCH_COND_REQUIRES_INFO does not reference any database object

APPLSYS.AD_PA_PATCH_COND_REQUIRES_INFO is referenced by following:

APPLSYS
VIEW - AD_PA_PATCH_COND_REQUIRES_INF#

[top of page]

Table: AD_PA_PATCH_ENTITY_INFO

Description: Master table to store the entity information of all the entities in Patch Wizard
Primary Key: AD_PA_PATCH_ENTITY_INFO_PK
  1. PATCH_ENTITY_ID
Comments

Detailed table to store the introducing information of a patch from patch_metadata.xml

Indexes
Index Type Tablespace Column
AD_PA_PATCH_ENTITY_INFO_U1 UNIQUE APPS_TS_TX_IDX PATCH_ID
TE_ABBR
Columns
Name Datatype Length Mandatory Comments
PATCH_ENTITY_ID NUMBER
Y Primary Key
PATCH_ID NUMBER
Y Foreign Key to AD_PM_MASTER
TE_ABBR VARCHAR2 (30) Y Abbreviation of the introducing entity
TE_LEVEL VARCHAR2 (150)
Codelevel of the introducing entity
BASELINE VARCHAR2 (150)
Baseline of the introducing entity
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PA_PATCH_ENTITY_INFO does not reference any database object

APPLSYS.AD_PA_PATCH_ENTITY_INFO is referenced by following:

APPLSYS
VIEW - AD_PA_PATCH_ENTITY_INFO#

[top of page]

Table: AD_PA_PATCH_REQUIRES_INFO

Description: Detailed table to store the pre-requisite codelevel information of a patch from patch_metadata.xml
Primary Key: AD_PA_PATCH_REQUIRES_INFO_PK
  1. PATCH_REQUIRES_ID
Comments

Detailed table to store the pre-requisite codelevel information of a patch from patch_metadata.xml

Indexes
Index Type Tablespace Column
AD_PA_PATCH_REQUIRES_INFO_U1 UNIQUE APPS_TS_TX_IDX PATCH_ID
TE_ABBR
REQUIRES_TE_ABBR
REQUIRES_TE_LEVEL
Columns
Name Datatype Length Mandatory Comments
PATCH_REQUIRES_ID NUMBER
Y Primary Key
PATCH_ID NUMBER
Y Foreign Key to AD_PM_MASTER
TE_ABBR VARCHAR2 (30) Y Entity for which pre-requisite is required
REQUIRES_TE_ABBR VARCHAR2 (30) Y Abbreviation of the requires entity
REQUIRES_TE_LEVEL VARCHAR2 (150) Y Minimum Codelevel of the requires entity
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PA_PATCH_REQUIRES_INFO does not reference any database object

APPLSYS.AD_PA_PATCH_REQUIRES_INFO is referenced by following:

APPLSYS
VIEW - AD_PA_PATCH_REQUIRES_INFO#

[top of page]

Table: AD_PLANNED_RES_LOCKS

Description: Stores locks to be required by an AD Utility
Comments

This table is used for storing the Resource Locks meant for different concurrently running AD Utilities. The Resource lock information are loaded into this table initially by the Ad Utility and the rows from this table are used for acquiring and releasing the Resource locks at different stages of the utilty. .

Indexes
Index Type Tablespace Column
AD_PLANNED_RES_LOCKS_U1 UNIQUE APPS_TS_INTERFACE SESSION_ID
STAGE_CODE
RESOURCE_CODE
CONTEXT
APPL_TOP_ID
LANGUAGE
EXTRA_CONTEXT1
EXTRA_CONTEXT2
EXTRA_CONTEXT3
ACTION_FLAG
Columns
Name Datatype Length Mandatory Comments
APPL_TOP_ID NUMBER
Y Foreign Key to AD_APPL_TOPs
SESSION_ID NUMBER
Y Foreign Key to AD_SESSIONS.SESSION_ID
STAGE_CODE VARCHAR2 (30) Y Identifies the stage the lock is required for
RESOURCE_CODE VARCHAR2 (30) Y Application System Resource
CONTEXT VARCHAR2 (30) Y Resource subset
LOCK_MODE VARCHAR2 (1) Y Shared or Exclusive Lock
LANGUAGE VARCHAR2 (8) Y Language subset for the Resource Lock
ACTION_FLAG VARCHAR2 (1) Y Specifies what is to be done with the resource lock and when
EXTRA_CONTEXT1 VARCHAR2 (30) Y Not currently used
EXTRA_CONTEXT2 VARCHAR2 (30) Y Not currently used
EXTRA_CONTEXT3 VARCHAR2 (30) Y Not currently used
DONE_FLAG VARCHAR2 (1)
For Restart Purposes

[top of page]

APPLSYS.AD_PLANNED_RES_LOCKS does not reference any database object

APPLSYS.AD_PLANNED_RES_LOCKS is referenced by following:

APPLSYS
VIEW - AD_PLANNED_RES_LOCKS#

[top of page]

Table: AD_PM_MASTER

Description: Master table for the Patch Metadata repository
Comments

This table has only one row. Each time PAUpload concurrent program is run, this row is updated again by comparing the date from the Infobundle.zip file against the INFOBUNDLE_CREATION_DATE. If the newly downloaded file is older than that currently loaded in the database, the upload procedure will not be run

Indexes
Index Type Tablespace Column
AD_PM_MASTER_U1 UNIQUE APPS_TS_TX_IDX PATCH_METADATA_KEY
Columns
Name Datatype Length Mandatory Comments
PATCH_METADATA_KEY VARCHAR2 (20) Y PRIMARY KEY
STAGING_DIRECTORY VARCHAR2 (255) Y Directory where patches and the InfoBundle are downloaded. Also used for temporary files used by Patch Advisor
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
INFOBUNDLE_UPLOAD_DATE DATE

The DATE when PAUPLOAD Concurrent Program was last run
INFOBUNDLE_CREATION_DATE DATE

The DATE when the last InfoBudle uploaded was created by the ARU system

[top of page]

APPLSYS.AD_PM_MASTER does not reference any database object

APPLSYS.AD_PM_MASTER is referenced by following:

APPLSYS
VIEW - AD_PM_MASTER#

[top of page]

Table: AD_PM_PATCHES

Description: Lists all patches whose MetaData has been uploaded by Patch Advisor
Comments

Lists all patches whose MetaData has been uploaded by Patch Advisor

Indexes
Index Type Tablespace Column
AD_PM_PATCHES_U1 UNIQUE APPS_TS_TX_IDX PATCH_METADATA_KEY
BUG_NUMBER
BASELINE
AD_PM_PATCHES_U2 UNIQUE APPS_TS_TX_IDX PATCH_ID
Columns
Name Datatype Length Mandatory Comments
PATCH_METADATA_KEY VARCHAR2 (20) Y Primary Key Column
BUG_NUMBER NUMBER
Y Primary Key Column
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
ARU_UPDATE_DATE DATE

Last time patch was updated by the ARU system
PRODUCT_ABBREVIATION VARCHAR2 (15)
Abbreviation for the product that owns this patch.
PATCH_NAME VARCHAR2 (80)
Patch Name
UPLOAD_RUN_ID NUMBER

Concurrent Request ID for the Patch Upload run that last updated this row
BUG_DESCRIPTION VARCHAR2 (240)
Description of Patch
IS_FAMILY_PACK VARCHAR2 (1)
Is the patch a Family Pack?
IS_MINI_PACK VARCHAR2 (1)
Is the patch a MiniPack?
IS_HIGH_PRIORITY VARCHAR2 (1)
Is this a high-priority patch?
IS_MAINT_PACK VARCHAR2 (1)
Is the patch a Maintenance Pack?
IN_REFERENCE_FAMILY_PACK VARCHAR2 (1)
Is the patch included in the referenced Family Pack?
REFERENCE_FAMILY_PACK NUMBER

Patch Number (Bug Number) for the Reference Family Pack (if any)
IN_REFERENCE_MINI_PACK VARCHAR2 (1)
Is the patch included in the referenced MiniPack?
REFERENCE_MINI_PACK NUMBER

Patch Number (Bug Number) of reference MiniPack (if any)
IN_REFERENCE_MAINT_PACK VARCHAR2 (1)
Is the patch included in the reference Maintenance Pack?
REFERENCE_MAINT_PACK NUMBER

Patch Number (Bug Number) of reference Maintenance Pack
INFOBUNDLE_UPLOAD_DATE DATE

If this row was ever updated as part of uploading the InfoBundle, this colum records the date that happened.
README_FILE_ID NUMBER

Foreign key to the row in FND_LOBS that contains the uploaded readme text for this patch
README_UPDATE_DATE DATE

Date of the last InfoBundle upload that uploaded readme text.
PRODUCT_FAMILY_ABBREVIATION VARCHAR2 (30)
Stores the abbreviation of the product.
IS_CODE_LEVEL VARCHAR2 (1)
Is Codelevel patch?
ENTITY_ABBR VARCHAR2 (30)
Abbreviation of entity for the patch
BASELINE VARCHAR2 (150)
Baseline of patch - default R12
PATCH_ID NUMBER
Y Primary Key for the patch
HAS_MSI_STEPS VARCHAR2 (1)
Does the patch contain any MSI steps?
PATCH_TYPE VARCHAR2 (50)
Patch type (Recommended, Minipack, Familypack, etc)

[top of page]

APPLSYS.AD_PM_PATCHES does not reference any database object

APPLSYS.AD_PM_PATCHES is referenced by following:

APPLSYS
VIEW - AD_PM_PATCHES#

[top of page]

Table: AD_PM_PREFERENCES

Description: Stores the default user preferences for download/merge options, platforms and languages.
Comments

Stores the default user preferences for download/merge options, platforms and languages.

Indexes
Index Type Tablespace Column
AD_PM_PREFERENCES_U1 UNIQUE APPS_TS_TX_IDX OPTION_TYPE
OPTION_VALUE
Columns
Name Datatype Length Mandatory Comments
OPTION_TYPE VARCHAR2 (30) Y Key of the option like platforms, languages, download options,etc
OPTION_VALUE VARCHAR2 (30) Y Value of the option like platforms, languages, download options,etc
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PM_PREFERENCES does not reference any database object

APPLSYS.AD_PM_PREFERENCES is referenced by following:

APPLSYS
VIEW - AD_PM_PREFERENCES#

[top of page]

Table: AD_PM_PRODUCT_INFO

Description: Contains information about Oracle Applications products and pseudo-products
Comments

Contains information about Oracle Applications products and pseudo-products

Indexes
Index Type Tablespace Column
AD_PM_PRODUCT_INFO_U1 UNIQUE APPS_TS_TX_IDX PRODUCT_ABBREVIATION
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
PRODUCT_ABBREVIATION VARCHAR2 (15) Y Product Abbreviation for this product
PSEUDO_PRODUCT_FLAG VARCHAR2 (1) Y Is this a pseudo-product?
PRODUCT_FAMILY_FLAG VARCHAR2 (1) Y Is this a product family?
PRODUCT_NAME VARCHAR2 (80) Y Name of this product in the ARU System
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
APPLICATION_SHORT_NAME VARCHAR2 (15)
The Application Short Name for this product
PRODUCT_FAMILY_ABBREVIATION VARCHAR2 (15)
The abbreviation for the pseudo-product that represents the product family that this product belongs to.
PRODUCT_FAMILY_NAME VARCHAR2 (80)
The name for the product family that this product belongs to, if any.
ARU_UPDATE_DATE DATE

Date the information for this product was last updated in the ARU System
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

APPLSYS.AD_PM_PRODUCT_INFO does not reference any database object

APPLSYS.AD_PM_PRODUCT_INFO is referenced by following:

APPLSYS
VIEW - AD_PM_PRODUCT_INFO#

[top of page]

Table: AD_PM_PROD_FAMILY_MAP

Description: Contains information about Oracle Applications products and pseudo-products and their mapping to a product family
Comments

Contains information about Oracle Applications products and pseudo-products and their mapping to a product family

Indexes
Index Type Tablespace Column
AD_PM_PROD_FAMILY_MAP_U1 UNIQUE APPS_TS_TX_IDX PRODUCT_ABBREVIATION
PRODUCT_FAMILY_ABBREVIATION
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
PRODUCT_ABBREVIATION VARCHAR2 (30) Y Product abbreviation
PRODUCT_FAMILY_ABBREVIATION VARCHAR2 (30) Y Product family abbreviation
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

APPLSYS.AD_PM_PROD_FAMILY_MAP does not reference any database object

APPLSYS.AD_PM_PROD_FAMILY_MAP is referenced by following:

APPLSYS
VIEW - AD_PM_PROD_FAMILY_MAP#

[top of page]

Table: AD_PREPMODE_CHECK_FILES

Description: A "check-file" repository used in clone schema approach
Comments

A "check-file" repository used in clone schema approach

Indexes
Index Type Tablespace Column
AD_PREPMODE_CHECK_FILES_U1 UNIQUE APPS_TS_TX_IDX APP_SHORT_NAME
SUBDIR
FILENAME
DISTINGUISHER
Columns
Name Datatype Length Mandatory Comments
APP_SHORT_NAME VARCHAR2 (50) Y Short name of the product to which the file belongs to.
SUBDIR VARCHAR2 (256) Y Subdirectory in the product where the file exists.
FILENAME VARCHAR2 (128) Y Name of the file.
DISTINGUISHER VARCHAR2 (80) Y "Distinguisher" information as stated in the patch driver
VERSION VARCHAR2 (150)
Version of the file
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
TRANSLATION_LEVEL NUMBER

Translation level of the file.
VERSION_SEGMENT1 NUMBER

Version Segment 1 (eg. will hold 115 if the version is 115.10.2.4)
VERSION_SEGMENT2 NUMBER

Version Segment 2 (eg. will hold 10 if the version is 115.10.2.4)
VERSION_SEGMENT3 NUMBER

Version Segment3
VERSION_SEGMENT4 NUMBER

Version Segment4
VERSION_SEGMENT5 NUMBER

Version Segment5
VERSION_SEGMENT6 NUMBER

Version Segment6
VERSION_SEGMENT7 NUMBER

Version Segment7
VERSION_SEGMENT8 NUMBER

Version Segment8
VERSION_SEGMENT9 NUMBER

Version Segment9
VERSION_SEGMENT10 NUMBER

Version Segment10

[top of page]

APPLSYS.AD_PREPMODE_CHECK_FILES does not reference any database object

APPLSYS.AD_PREPMODE_CHECK_FILES is referenced by following:

APPLSYS
VIEW - AD_PREPMODE_CHECK_FILES#

[top of page]

Table: AD_PROGRAM_RUN_TASKS

Description: This table stores the information of the various tasks executed during a particular run of ad utility.
Comments

This table stores the information of the various tasks executed during a particular run of ad utility.

Indexes
Index Type Tablespace Column
AD_PROGRAM_RUN_TASKS_U1 UNIQUE APPS_TS_TX_IDX TASK_STATUS_ID
PROGRAM_RUN_ID
AD_PROGRAM_RUN_TASKS_N1 NONUNIQUE APPS_TS_TX_IDX SESSION_ID
PROGRAM_RUN_ID
AD_PROGRAM_RUN_TASKS_N2 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
PROGRAM_RUN_ID NUMBER
Y A number that distinguishes the different runs of ad utilities, when the information is moved from in progress to history.
TASK_STATUS_ID NUMBER
Y Id for task that was executed.
SESSION_ID NUMBER
Y The session_id of the particular run of ad utility.
TASK_NAME VARCHAR2 (250) Y Name of the task that was executed.
START_TIME DATE
Y Starting time of the task.
ITEMS_IN_TASK NUMBER
Y Items in a particular task.
PHASE_NAME VARCHAR2 (150)
Phase name for the task if it has any.
END_TIME DATE

End time of the task.
ITEM_NAME VARCHAR2 (50)
The items that the task is comprised of.
JOB_SYSTEM_MASTER_TASK VARCHAR2 (1)
Flag to indicate whether this task starts a job system.
PARENT_TASK_STATUS_ID NUMBER

Task_status_id of the parent for the current task.
ITEMS_SKIPPED NUMBER

Number of items that were skipped .
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PROGRAM_RUN_TASKS does not reference any database object

APPLSYS.AD_PROGRAM_RUN_TASKS is referenced by following:

APPLSYS
VIEW - AD_PROGRAM_RUN_TASKS#

[top of page]

Table: AD_PROGRAM_RUN_TASK_JOBS

Description: History of timing information of jobs run in parallel
Comments

History of timing information of jobs run in parallel

Indexes
Index Type Tablespace Column
AD_PROGRAM_RUN_TASK_JOBS_N1 NONUNIQUE APPS_TS_TX_IDX TASK_STATUS_ID
PROGRAM_RUN_ID
Columns
Name Datatype Length Mandatory Comments
PROGRAM_RUN_ID NUMBER
Y A number that distinguishes the different runs of ad utilities, when the information is moved from in progress to history.
SESSION_ID NUMBER
Y Session ID for the AD program run which ran this parallel job.
TASK_STATUS_ID NUMBER
Y Id of the task to which this job corresponds. It is a foreign key to AD_PROGRAM_RUN_TASKS
JOB_NAME VARCHAR2 (60) Y Name of the file associated with this job
PRODUCT VARCHAR2 (30) Y Product that owns the file associated with this job
CURRENT_FLAG VARCHAR2 (1) Y Y for currently-running jobs; N for completed or skipped jobs
WORKER_ID NUMBER
Y The worker ID for the parallel worker that ran this job
INSTALL_GROUP_NUM NUMBER
Y The Installation Group Number for this job; 0 for SOA product jobs -- 1 for MOA product jobs
PROGRAM VARCHAR2 (30) Y The name of the AD program that ran this job
PHASE NUMBER
Y The numeric phase for this job
ARGUMENTS VARCHAR2 (1996)
The comand-line arguments for this job
PHASE_NAME VARCHAR2 (30)
User-friendly name of the phase for this job
START_TIME DATE

Time when job started
RESTART_TIME DATE

Time when job (last) restarted
END_TIME DATE

Time when job completed
ELAPSED_TIME NUMBER

Total run time for the job
RESTART_COUNT NUMBER

Number of times job failed and was restarted
SUBDIRECTORY VARCHAR2 (256)
Subdirectory where the acted-upon file resides
COMMAND VARCHAR2 (30)
Command code ("bin" for executables, "package" for packages, etc)
DEFER_COUNT NUMBER

Number of times this job was deferred (after a failure)
TASK_NUMBER NUMBER

Task number. See table description for details
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_PROGRAM_RUN_TASK_JOBS does not reference any database object

APPLSYS.AD_PROGRAM_RUN_TASK_JOBS is referenced by following:

APPLSYS
VIEW - AD_PROGRAM_RUN_TASK_JOBS#

[top of page]

Table: AD_RELEASES

Description: Oracle Applications releases
Primary Key: AD_RELEASES_PK
  1. RELEASE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_PATCH_RUNS.RELEASE_ID AD_RELEASES
AD_PATCH_RUNS.UPDATED_TO_RELEASE_ID AD_RELEASES
AD_SNAPSHOTS.RELEASE_ID AD_RELEASES
Comments

AD_RELEASES holds the various Oracle Applications releases that an installation of Oracle Applications has gone through in its entire life cycle.
.
It should be noted that START_DATE_ACTIVE, END_DATE_ACTIVE and BASE_RELEASE_FLAG are loosely-maintained informational columns and are not accurately maintained, and therefore should not be relied upon heavily.
.

Indexes
Index Type Tablespace Column
AD_RELEASES_U1 UNIQUE APPS_TS_TX_IDX RELEASE_ID
AD_RELEASES_U2 UNIQUE APPS_TS_TX_IDX MAJOR_VERSION
MINOR_VERSION
TAPE_VERSION
Columns
Name Datatype Length Mandatory Comments
RELEASE_ID NUMBER
Y Release identifier
MAJOR_VERSION NUMBER
Y Major version, eg. 11 (for Release 11.5.3)
MINOR_VERSION NUMBER
Y Minor version, eg. 5 (for Release 11.5.3)
TAPE_VERSION NUMBER
Y Tape version, eg. 3 (for Release 11.5.3)
ARU_RELEASE_NAME VARCHAR2 (30) Y For internal use - Holds 11i for all 11.5.x releases
BASE_RELEASE_FLAG VARCHAR2 (1)
Y for a base release
START_DATE_ACTIVE DATE
Y Start of "active" period
END_DATE_ACTIVE DATE

End of "active" period
APPROXIMATED_DATES_FLAG VARCHAR2 (1)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
ROW_SOURCE_COMMENTS VARCHAR2 (256)
General comments about how this row came to be created
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_RELEASES does not reference any database object

APPLSYS.AD_RELEASES is referenced by following:

APPLSYS
VIEW - AD_RELEASES#

[top of page]

Table: AD_SEED_DATA_LOADED

Description: Languages in a patch for which seed data loading has completed
Comments

This table is used for the database actions/generate actions coordination in patches, to ensure, for instance, that in a patch, the generation of message files for a given language should not begin until the messages for that language have been loaded into the database in that patch.

Columns
Name Datatype Length Mandatory Comments
APPLIED_PATCH_ID NUMBER
Y FK to AD_APPLIED_PATCHES
LANGUAGE_CODE VARCHAR2 (4) Y Language, for which seed data has finished loading in this patch
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_SEED_DATA_LOADED does not reference any database object

APPLSYS.AD_SEED_DATA_LOADED is referenced by following:

APPLSYS
VIEW - AD_SEED_DATA_LOADED#

[top of page]

Table: AD_SESSIONS

Description: Stores information on all AD sessions for an Applications System
Comments

Stores information on all concurrently running AD sessions for an Applications System.

Indexes
Index Type Tablespace Column
AD_SESSIONS_U1 UNIQUE APPS_TS_INTERFACE SESSION_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y Primary Key
UTILITY_NAME VARCHAR2 (8) Y Name of AD Utility
APPL_TOP_ID NUMBER
Y Foreign Key to AD_APPL_TOPS
INVOKDIR VARCHAR2 (256) Y Directory AD Utility was invoked from
STATUS VARCHAR2 (30) Y Active or Inactive
PRIORITY NUMBER
Y Priority of Session
OS_PROCESS_ID NUMBER
Y OS Process Id of the AD Utility
OS_USER_NAME VARCHAR2 (30) Y OS User Name Executing the AD Utility
START_DATE DATE
Y Time AD Utility was Started
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
APPL_TOP_PATH VARCHAR2 (256) Y APPL_TOP path
CONTEXT_INFO VARCHAR2 (256)
Information related to the AD Utility being executed
WAIT_LOOP_TIME NUMBER

Time the session is waiting to acquire a lock
CONTROL_CODE VARCHAR2 (1)
ADCTRL Control Code
ANY_CHANGE_WHILE_INACTIVE_FLAG VARCHAR2 (1)
Resources Needed by this session have changed while session was inactive
JS_TOTAL_JOBS NUMBER

Total number of jobs in Job System
JS_COMPLETED_JOBS NUMBER

Number of Completed Jobs
JS_REMAINING_JOBS NUMBER

Number of Jobs Remaining in Job System
JS_CURR_PHASE VARCHAR2 (30)
Current Phase of Job System
JS_JOBS_REM_IN_CURR_PHASE NUMBER

Number of Jobs Remaining in Current Phase
JS_JOBS_ASS_IN_CURR_PHASE NUMBER

Number of Jobs Assigned in Current Phase
JS_JOBS_READY_IN_CURR_PHASE NUMBER

Number of Jobs Ready to be run in Current Phase
JS_JOBS_WAITING_IN_CURR_PHASE NUMBER

Number of Jobs Waiting in the Current Phase
RUN_ON_NODE VARCHAR2 (30) Y Node (machine) on which this session is running
LOCKS_OVERRIDDEN_BY NUMBER

Stores the session Id of the first session that updated the column ANY_CHANGE_WHILE_INACTIVE_FLAG to Y.
TOPDIR VARCHAR2 (256) Y Stores the directory location of the logs.

[top of page]

APPLSYS.AD_SESSIONS does not reference any database object

APPLSYS.AD_SESSIONS is referenced by following:

APPLSYS
VIEW - AD_SESSIONS#

[top of page]

Table: AD_SESSIONS_HISTORY

Description: Stores information on all AD sessions for an Applications System
Comments

Stores information on all AD sessions for an Applications System. After an AD_UTILTY session which is running concurrently has completed successfully the rows belonging to that session are copied from AD_SESSIONS table to this table.

Indexes
Index Type Tablespace Column
SESSION_ID NONUNIQUE APPS_TS_TX_IDX SESSION_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y Primary Key
UTILITY_NAME VARCHAR2 (8) Y Name of AD Utility
APPL_TOP_PATH VARCHAR2 (256) Y APPL_TOP Path
INVOKDIR VARCHAR2 (256) Y Directory AD Utility was invoked from
STATUS VARCHAR2 (30) Y Active or Inactive
PRIORITY NUMBER
Y Priority of Session
START_DATE DATE
Y Time AD Utility was Started
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
END_DATE DATE
Y Time session completed
COMPLETION_STATUS VARCHAR2 (30) Y Completion status. Valid values are ABANDONED and COMPLETED
RUN_ON_NODE VARCHAR2 (30) Y Node (machine) on which this session ran
CONTEXT_INFO VARCHAR2 (256)
Information related to the AD Utility being executed
ANY_CHANGE_WHILE_INACTIVE_FLAG VARCHAR2 (1)
Resources Needed by this session have changed while session was inactive
JS_TOTAL_JOBS NUMBER

Total number of jobs in Job System
JS_COMPLETED_JOBS NUMBER

Number of Completed Jobs
JS_REMAINING_JOBS NUMBER

Number of Jobs Remaining in Job System
LOCKS_OVERRIDDEN_BY NUMBER

Stores the session Id of the first session that updated the column ANY_CHANGE_WHILE_INACTIVE_FLAG to Y.
TOPDIR VARCHAR2 (256) Y Stores the directory location of the logs.

[top of page]

APPLSYS.AD_SESSIONS_HISTORY does not reference any database object

APPLSYS.AD_SESSIONS_HISTORY is referenced by following:

APPLSYS
VIEW - AD_SESSIONS_HISTORY#

[top of page]

Table: AD_SESSION_ATTRIBUTES

Description: This table stores various attributes for a particular session of ad utility.
Comments

This table stores various attributes for a particular session of ad utility.

Indexes
Index Type Tablespace Column
AD_SESSION_ATTRIBUTES_U1 UNIQUE APPS_TS_INTERFACE ATTRIBUTE_NAME
SESSION_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y The session_id of the particular run of ad utility.
ATTRIBUTE_NAME VARCHAR2 (50) Y Name of the attribute that corresponds to the run of ad utility.
ATTRIBUTE_VALUE VARCHAR2 (300) Y Value of the attribute that corresponds to the run of ad utility.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_SESSION_ATTRIBUTES does not reference any database object

APPLSYS.AD_SESSION_ATTRIBUTES is referenced by following:

APPLSYS
VIEW - AD_SESSION_ATTRIBUTES#

[top of page]

Table: AD_SESSION_TASKS

Description: Stores the tasks for each concurrent AD utility session
Comments

Stores the tasks for each concurrent AD utility session.

Indexes
Index Type Tablespace Column
AD_SESSION_TASKS_U1 UNIQUE APPS_TS_INTERFACE SESSION_ID
TASK_NUMBER
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y FORIEGN KEY TO AD_SESSIONS
TASK_NUMBER NUMBER
Y Task number in a particular session
COMPLETION_STATUS VARCHAR2 (30) Y INPROGRESS,ABANDON,SUCCESS etc
START_DATE DATE
Y date and time when the task started
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
END_DATE DATE

WHO column
CONTEXT VARCHAR2 (256)
Driver name in case of adpatch and task like "Compile APPS Schema" in case of adadmin

[top of page]

APPLSYS.AD_SESSION_TASKS does not reference any database object

APPLSYS.AD_SESSION_TASKS is referenced by following:

APPLSYS
VIEW - AD_SESSION_TASKS#

[top of page]

Table: AD_SESSION_TASKS_HISTORY

Description: Stores the tasks for each concurrent AD utility session
Comments

Stores the tasks for each concurrent AD utility session. After the successful completion of an AD_UTILITY session the task information from the AD_SESSION_TASKS are archived into this table.

Indexes
Index Type Tablespace Column
AD_SESSION_TASK_HISTORY_U1 UNIQUE APPS_TS_TX_IDX SESSION_ID
TASK_NUMBER
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y FORIEGN KEY TO AD_SESSIONS
TASK_NUMBER NUMBER
Y Task number for that concurrently running session
COMPLETION_STATUS VARCHAR2 (30) Y INPROGRESS,ABANDON,SUCCESS etc
START_DATE DATE
Y Start date and time
END_DATE DATE
Y End date and time
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
CONTEXT VARCHAR2 (256)
Driver name in adapatch and task name in adadmin

[top of page]

APPLSYS.AD_SESSION_TASKS_HISTORY does not reference any database object

APPLSYS.AD_SESSION_TASKS_HISTORY is referenced by following:

APPLSYS
VIEW - AD_SESSION_TASKS_HISTORY#

[top of page]

Table: AD_SNAPSHOTS

Description: File-system snapshots
Primary Key: AD_SNAPSHOTS_PK
  1. SNAPSHOT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_SNAPSHOTS.APPL_TOP_ID AD_APPL_TOPS
AD_SNAPSHOTS.RELEASE_ID AD_RELEASES
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_SNAPSHOT_BUGFIXES.SNAPSHOT_ID AD_SNAPSHOTS
AD_SNAPSHOT_FILES.SNAPSHOT_ID AD_SNAPSHOTS
Comments

AD_SNAPSHOTS holds information about file-system snapshots.

Indexes
Index Type Tablespace Column
AD_SNAPSHOTS_U1 UNIQUE APPS_TS_TX_IDX SNAPSHOT_ID
AD_SNAPSHOTS_U2 UNIQUE APPS_TS_TX_IDX SNAPSHOT_NAME
APPL_TOP_ID
SNAPSHOT_TYPE
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER
Y PK
RELEASE_ID NUMBER
Y Identifies the release to which this snapshot pertains
APPL_TOP_ID NUMBER
Y Identifies the APPL_TOP to which this snapshot pertains
SNAPSHOT_NAME VARCHAR2 (80) Y Name of the snapshot. "CURRENT_VIEW"=>current-view. "*PRESEEDED*..."=>preseeded baseline info
SNAPSHOT_CREATION_DATE DATE
Y Date when snapshot was first taken
SNAPSHOT_UPDATE_DATE DATE
Y Date when snapshot was updated
SNAPSHOT_TYPE VARCHAR2 (1) Y C=>current-view. S=>named snapshot. B=>preseeded baseline info
COMMENTS VARCHAR2 (1996)
Comments
RAN_SNAPSHOT_FLAG VARCHAR2 (1) Y Y=>adadmin's snapshot utility has been run atleast once to take a complete snapshot
IMPORTED_FLAG VARCHAR2 (1)
Not currently used
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_SNAPSHOTS does not reference any database object

APPLSYS.AD_SNAPSHOTS is referenced by following:

APPLSYS
VIEW - AD_SNAPSHOTS#

[top of page]

Table: AD_SNAPSHOT_BUGFIXES

Description: Bug-fixes applied when the snapshot was taken
Primary Key: AD_SNAPSHOT_BUGFIXES_PK
  1. SNAPSHOT_BUG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_SNAPSHOT_BUGFIXES.SNAPSHOT_ID AD_SNAPSHOTS
AD_SNAPSHOT_BUGFIXES.BUGFIX_ID AD_BUGS
Comments

AD_SNAPSHOT_BUGFIXES holds information about the various bug-fixes that may have been applied till the time the snapshot was taken.

Indexes
Index Type Tablespace Column
AD_SNAPSHOT_BUGFIXES_U1 UNIQUE APPS_TS_TX_IDX SNAPSHOT_BUG_ID
AD_SNAPSHOT_BUGFIXES_U2 UNIQUE APPS_TS_TX_IDX BUGFIX_ID
SNAPSHOT_ID
AD_SNAPSHOT_BUGFIXES_N1 NONUNIQUE APPS_TS_TX_IDX SNAPSHOT_ID
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_BUG_ID NUMBER
Y PK
SNAPSHOT_ID NUMBER
Y Identifies the snapshot which has this bug fixed
BUGFIX_ID NUMBER
Y Identifies the bugfix
BUG_STATUS VARCHAR2 (30) Y Status (whether explicitely/implicitely applied (EXPLICIT/IMPLICIT), etc)
SUCCESS_FLAG VARCHAR2 (1) Y Y => the bug fix was successfully applied
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
INCONSISTENT_FLAG VARCHAR2 (1)
Whether data is inconsistent across APPL_TOPS

[top of page]

APPLSYS.AD_SNAPSHOT_BUGFIXES does not reference any database object

APPLSYS.AD_SNAPSHOT_BUGFIXES is referenced by following:

APPLSYS
VIEW - AD_SNAPSHOT_BUGFIXES#

[top of page]

Table: AD_SNAPSHOT_BUGFIXES_TEMP

Description: Temp table to store data to be inserted into AD_SNAPSHOT_BUGFIXES
Comments

Temp table to store data to be inserted into AD_SNAPSHOT_BUGFIXES

Columns
Name Datatype Length Mandatory Comments
BUGFIX_ID NUMBER
Y Same as the bugfix_id in AD_SNAPSHOT_BUGFIXES, identifies the bugfix
BUG_STATUS VARCHAR2 (30) Y Same as the BUG_STATUS in AD_SNAPSHOT_BUGFIXES, (EXPLICIT/IMPLICIT)
SUCCESS_FLAG VARCHAR2 (1) Y Same as the SUCCESS_FLAG of AD_SNAPSHOT_BUGFIXES , Y=> the bug was successfully applied.
INCONSISTENT_FLAG VARCHAR2 (1)
Signifies whether data is consistent across APPL_TOPS.
ACTION_FLAG VARCHAR2 (1)
U/I => Signifies whether we update or insert into AD_SNAPSHOT_BUGFIXES.

[top of page]

APPLSYS.AD_SNAPSHOT_BUGFIXES_TEMP does not reference any database object

APPLSYS.AD_SNAPSHOT_BUGFIXES_TEMP is referenced by following:

APPLSYS
VIEW - AD_SNAPSHOT_BUGFIXES_TEMP#

[top of page]

Table: AD_SNAPSHOT_FILES

Description: File-details in the snapshot
Primary Key: AD_SNAPSHOT_FILES_PK
  1. SNAPSHOT_FILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_SNAPSHOT_FILES.SNAPSHOT_ID AD_SNAPSHOTS
AD_SNAPSHOT_FILES.FILE_ID AD_FILES
AD_SNAPSHOT_FILES.CONTAINING_FILE_ID AD_FILES
AD_SNAPSHOT_FILES.FILE_VERSION_ID AD_FILE_VERSIONS
Comments

AD_SNAPSHOT_FILES holds information about various files and their versions (if applicable) in the APPL-TOP when the snapshot was taken.

Indexes
Index Type Tablespace Column
AD_SNAPSHOT_FILES_U1 UNIQUE APPS_TS_TX_IDX SNAPSHOT_FILE_ID
AD_SNAPSHOT_FILES_U2 UNIQUE APPS_TS_TX_IDX FILE_ID
SNAPSHOT_ID
CONTAINING_FILE_ID
AD_SNAPSHOT_FILES_N1 NONUNIQUE APPS_TS_TX_IDX SNAPSHOT_ID
FILE_ID
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_FILE_ID NUMBER
Y PK
SNAPSHOT_ID NUMBER
Y Identifies the snapshot that contains this (version of this) file
FILE_ID NUMBER
Y Identifies the file thats contained in this snapshot
CONTAINING_FILE_ID NUMBER

Identifies the aggregate file, if this file is contained in an aggregate (eg. if this is a C object file, then this column identifies the C archive library file; if this file is a Java class file, then this column could identify the apps.zip file, for instance)
FILE_SIZE NUMBER

File size in bytes
CHECKSUM NUMBER

Checksum: for internal use
FILE_VERSION_ID NUMBER

Identifies the version of the file
UPDATE_SOURCE_ID NUMBER
Y If the version of this file is ever updated in this snapshot (by a patch, for instance), then this column identifies the source transaction row responsible for the update
UPDATE_TYPE VARCHAR2 (1) Y P=>A patch was applied that was last responsible for updating this row. S=>adadmin's snapshot utility was last responsible for updating this row. In the former case, UPDATE_SOURCE_ID holds the patch's PATCH_RUN_ID, and in the latter case it holds the SNAPSHOT_ID of the named snapshot.
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
APPL_TOP_ID NUMBER

The APPL_TOP to which this file corresponds to.
INCONSISTENT_FLAG VARCHAR2 (1)
Flag that indicates whether the file version is different across different APPL_TOPS.
SERVER_TYPE_ADMIN_FLAG VARCHAR2 (1)
Flag that indicates whether this file belongs to admin node.
SERVER_TYPE_FORMS_FLAG VARCHAR2 (1)
Flag that indicates whether this file belongs to forms node.
SERVER_TYPE_NODE_FLAG VARCHAR2 (1)
Flag that indicates whether this file belongs to CP node.
SERVER_TYPE_WEB_FLAG VARCHAR2 (1)
Flag that indicates whether this file belongs to web node.
DEST_FILE_ID NUMBER

FILE_ID of a file in its copy location
FILE_TYPE_FLAG VARCHAR2 (1)
Mirror or Nomirror Flag
IREP_GATHERED_FLAG VARCHAR2 (1)
Flag determing if the file has been processed into the Interface Repository
LAST_PATCHED_DATE DATE

Date the file was last patched

[top of page]

APPLSYS.AD_SNAPSHOT_FILES does not reference any database object

APPLSYS.AD_SNAPSHOT_FILES is referenced by following:

APPLSYS
VIEW - AD_SNAPSHOT_FILES#

[top of page]

Table: AD_SNAPSHOT_FILES_TEMP

Description: This is a temporary table used during updation of the snapshot of the Application System.
Comments

This is a temporary table used during updation of the snapshot of the Application System.

Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_FILE_ID NUMBER
Y This column stores the snapshot_file_id for the specific file(corresponds to ad_snapshot_files).
FILE_ID NUMBER
Y This column stores the file_id for the specific file(corresponds to ad_files)
UPDATE_SOURCE_ID NUMBER
Y Source file_id that needs to be updated.
UPDATE_TYPE VARCHAR2 (1) Y The update text.
INCONSISTENT_FLAG VARCHAR2 (1) Y Flag to indicate whether the file is not at the same level in all the APPL_TOPS.
CONTAINING_FILE_ID NUMBER

The file id of the file (e.g. library modules), that contain this file.
FILE_SIZE NUMBER

Size of the file.
CHECKSUM NUMBER

Checksum computed for the file.
FILE_VERSION_ID NUMBER

This column stores the file_version_id for the specific file(corresponds to ad_file_versions).
APPL_TOP_ID NUMBER

The id of the APPL_TOP, to which this information corresponds to.
DEST_FILE_ID NUMBER

FILE_ID of a file in its copy location
FILE_TYPE_FLAG VARCHAR2 (1)
Mirror or Nomirror Flag

[top of page]

APPLSYS.AD_SNAPSHOT_FILES_TEMP does not reference any database object

APPLSYS.AD_SNAPSHOT_FILES_TEMP is referenced by following:

APPLSYS
VIEW - AD_SNAPSHOT_FILES_TEMP#

[top of page]

Table: AD_SUPPORTED_LANGUAGES

Description: Oracle Supported langauges for download and/or merging.
Comments

Oracle Supported langauges for download and/or merging.

Indexes
Index Type Tablespace Column
AD_SUPPORTED_LANGUAGES_U1 UNIQUE APPS_TS_TX_IDX LANGUAGE_ID
Columns
Name Datatype Length Mandatory Comments
LANGUAGE_ID NUMBER
Y FK to FND_LANGUAGES
LANGUAGE_NAME VARCHAR2 (30)
FK to FND_LANGUAGES
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_SUPPORTED_LANGUAGES does not reference any database object

APPLSYS.AD_SUPPORTED_LANGUAGES is referenced by following:

APPLSYS
VIEW - AD_SUPPORTED_LANGUAGES#

[top of page]

Table: AD_SUPPORTED_PLATFORMS

Description: Oracle Supported platforms for download and/or merging.
Comments

Oracle Supported platforms for download and/or merging.

Indexes
Index Type Tablespace Column
AD_SUPPORTED_PLATFORMS_U1 UNIQUE APPS_TS_TX_IDX PLATFORM_ID
Columns
Name Datatype Length Mandatory Comments
PLATFORM_ID NUMBER
Y Platform id
PLATFORM_CODE VARCHAR2 (15)
Platform code
PLATFORM_NAME VARCHAR2 (40)
Pltaform name
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_SUPPORTED_PLATFORMS does not reference any database object

APPLSYS.AD_SUPPORTED_PLATFORMS is referenced by following:

APPLSYS
VIEW - AD_SUPPORTED_PLATFORMS#

[top of page]

Table: AD_TASK_STATUS

Description: This table stores the information about various tasks executed during the run of ad utility.
Comments

This table stores the information about various tasks executed during the run of ad utility.

Indexes
Index Type Tablespace Column
AD_TASK_STATUS_U1 UNIQUE APPS_TS_INTERFACE PHASE_NAME
TASK_NAME
SESSION_ID
AD_TASK_STATUS_U2 UNIQUE APPS_TS_INTERFACE TASK_STATUS_ID
AD_TASK_STATUS_N1 NONUNIQUE APPS_TS_INTERFACE SESSION_ID
AD_TASK_STATUS_N2 NONUNIQUE APPS_TS_INTERFACE LAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
TASK_STATUS_ID NUMBER
Y Id for task that was executed.
SESSION_ID NUMBER
Y The session_id of the particular run of ad utility.
TASK_NAME VARCHAR2 (250) Y Name of the task that was executed.
START_TIME DATE
Y Starting time of the task.
ITEMS_IN_TASK NUMBER
Y Items in a particular task.
ITEMS_PROCESSED NUMBER
Y Number of items processed till now.
PHASE_NAME VARCHAR2 (150)
Phase name for the task if it has any.
END_TIME DATE

End time of the task.
ITEM_NAME VARCHAR2 (50)
The items that the task is comprised of.
JOB_SYSTEM_MASTER_TASK VARCHAR2 (1)
Flag to indicate whether this task starts a job system.
PARENT_TASK_STATUS_ID NUMBER

Task_status_id of the parent for the current task.
ITEMS_SKIPPED NUMBER

Number of items that were skipped .
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_TASK_STATUS does not reference any database object

APPLSYS.AD_TASK_STATUS is referenced by following:

APPLSYS
VIEW - AD_TASK_STATUS#

[top of page]

Table: AD_TASK_TIMING

Description: Timing information of jobs run in parallel
Comments

This table is used to track how long each parallel job takes to run.
Session versus task:
A session consists of one or more tasks. For instance:
- In one adadmin invocation, each menu choice is a separate task in the same session
- In one adpatch invocation of multiple drivers, the timing history of each driver has a unique TASK_NUMBER but they all share the same SESSION_ID.

Indexes
Index Type Tablespace Column
AD_TASK_TIMING_N1 NONUNIQUE APPS_TS_INTERFACE SESSION_ID
JOB_NAME
PRODUCT
CURRENT_FLAG
WORKER_ID
INSTALL_GROUP_NUM
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y Session ID for the AD program run which ran this parallel job. See table description for details
JOB_NAME VARCHAR2 (60) Y Name of the file associated with this job
PRODUCT VARCHAR2 (30) Y Product that owns the file associated with this job
CURRENT_FLAG VARCHAR2 (1) Y Y for currently-running jobs; N for completed or skipped jobs
WORKER_ID NUMBER
Y The worker ID for the parallel worker that ran this job
INSTALL_GROUP_NUM NUMBER
Y The Installation Group Number for this job; 0 for SOA product jobs -- 1 for MOA product jobs
PROGRAM VARCHAR2 (30) Y The name of the AD program that ran this job
PHASE NUMBER
Y The numeric phase for this job
ARGUMENTS VARCHAR2 (1996)
The comand-line arguments for this job
PHASE_NAME VARCHAR2 (30)
User-friendly name of the phase for this job
START_TIME DATE

Time when job started
RESTART_TIME DATE

Time when job (last) restarted
END_TIME DATE

Time when job completed
ELAPSED_TIME NUMBER

Total run time for the job
RESTART_COUNT NUMBER

Number of times job failed and was restarted
DEFER_COUNT NUMBER

Number of times this job was deferred (after a failure)
COMMAND VARCHAR2 (30)
Command code ("bin" for executables, "package" for packages, etc)
SUBDIRECTORY VARCHAR2 (256)
Subdirectory where the acted-upon file resides
TASK_NUMBER NUMBER

Task number. See table description for details
TASK_STATUS_ID NUMBER
Y Id of the task to which this job corresponds. It is a foreign key to AD_TASK_STATUS
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_TASK_TIMING does not reference any database object

APPLSYS.AD_TASK_TIMING is referenced by following:

APPLSYS
VIEW - AD_TASK_TIMING#

[top of page]

Table: AD_TE_LEVEL_HISTORY

Description: Holds the history information of trackable entity codelevels. Whenever a row is updated in AD_TRACKABLE_ENTITIES, the row before updating is inserted in this table for history purposes
Primary Key: AD_TE_LEVEL_HISTORY_U1
  1. ABBREVIATION
  2. CODELEVEL
Comments

Holds the history information of trackable entity codelevels. Whenever a row is updated in AD_TRACKABLE_ENTITIES, the row before updating is inserted in this table for history purposes

Columns
Name Datatype Length Mandatory Comments
ABBREVIATION VARCHAR2 (8) Y Product Abbreviation
NAME VARCHAR2 (50) Y trackable entity name
CODELEVEL VARCHAR2 (150) Y Holds the codelevel of the trackable entity
BASELINE VARCHAR2 (150) Y Holds the baseline of the trackable entity
PATCH_RUN_ID NUMBER
Y Identifies the AD_PATCH_RUNS record

[top of page]

APPLSYS.AD_TE_LEVEL_HISTORY does not reference any database object

APPLSYS.AD_TE_LEVEL_HISTORY is referenced by following:

APPLSYS
VIEW - AD_TE_LEVEL_HISTORY#

[top of page]

Table: AD_TIMESTAMPS

Description: Holds the timestamp of when a particular operation took place
Comments

In some cases this table is used for incremental functionality: a given feature only processes objects that have changed since the last time indicated by the timestamp for the relevant row in this table. In other cases this table is just used to track that a given operation has taken place, and the timestamp is not important.

Indexes
Index Type Tablespace Column
AD_TIMESTAMPS_U1 UNIQUE APPS_TS_TX_IDX TYPE
ATTRIBUTE
Columns
Name Datatype Length Mandatory Comments
TYPE VARCHAR2 (50) Y The general category for this row
ATTRIBUTE VARCHAR2 (50) Y The sub-category for this row
TIMESTAMP DATE
Y When was this row inserted or last updated
ATTRIBUTE1 VARCHAR2 (255)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (255)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (255)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (255)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (255)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (255)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (255)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (255)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (255)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (255)
Descriptive flexfield segment

[top of page]

APPLSYS.AD_TIMESTAMPS does not reference any database object

APPLSYS.AD_TIMESTAMPS is referenced by following:

APPLSYS
VIEW - AD_TIMESTAMPS#
SYSTEM
SYNONYM - AD_TIMESTAMPS

[top of page]

Table: AD_TRACKABLE_ENTITIES

Description: Stores Oracle Applications Entities and their Code Levels
Primary Key: AD_TRACKABLE_ENTITIES_PK
  1. ABBREVIATION
Comments

Stores Oracle Applications Entities and their Code Levels

Indexes
Index Type Tablespace Column
AD_TRACKABLE_ENTITIES_U1 UNIQUE APPS_TS_TX_IDX ABBREVIATION
Columns
Name Datatype Length Mandatory Comments
ABBREVIATION VARCHAR2 (8) Y Product Abbreviation
NAME VARCHAR2 (50) Y Holds the name of the trackable entity
TYPE VARCHAR2 (30) Y Holds the type of the trackable entity
USED_FLAG VARCHAR2 (1)
Flag to indicate whether the trackable entity is used
LOAD_FLAG VARCHAR2 (1)
Flag to identify whether to load the trackable entity
CODELEVEL VARCHAR2 (150) Y Holds the codelevel of the trackable entity
BASELINE VARCHAR2 (150) Y Holds the baseline of the trackable entity

[top of page]

APPLSYS.AD_TRACKABLE_ENTITIES does not reference any database object

APPLSYS.AD_TRACKABLE_ENTITIES is referenced by following:

APPLSYS
VIEW - AD_TRACKABLE_ENTITIES#

[top of page]

Table: AD_UMS_ENGINE_RESULTS

Description: Stores the results of the UMS environment analysis
Comments

Stores the results of the UMS environment analysis

Indexes
Index Type Tablespace Column
AD_UMS_ENGINE_RESULTS_U1 UNIQUE APPS_TS_TX_IDX BUG_LIST
APPL_TOP_ID
RELEASE_NAME
Columns
Name Datatype Length Mandatory Comments
APPL_TOP_ID NUMBER
Y Primary Key, Foreign Key to AD_APPL_TOPS
RELEASE_NAME VARCHAR2 (15) Y Primary Key, Applications Release Version
BUG_LIST VARCHAR2 (1996) Y Primary Key, PATCH_ID concatenated with language
STATUS VARCHAR2 (15) Y Status for this patch the last time the UMS Engine was run to analyze it
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_UMS_ENGINE_RESULTS does not reference any database object

APPLSYS.AD_UMS_ENGINE_RESULTS is referenced by following:

APPLSYS
VIEW - AD_UMS_ENGINE_RESULTS#

[top of page]

Table: AD_UMS_LDT_LOADS

Description: Stores dataloader file names used in Patch Advisor
Comments

Stores dataloader file names used in Patch Advisor

Indexes
Index Type Tablespace Column
AD_UMS_LDT_LOADS_U1 UNIQUE APPS_TS_TX_IDX LDT_FILE_NAME
Columns
Name Datatype Length Mandatory Comments
LDT_FILE_NAME VARCHAR2 (50) Y Data File Name
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_UMS_LDT_LOADS does not reference any database object

APPLSYS.AD_UMS_LDT_LOADS is referenced by following:

APPLSYS
VIEW - AD_UMS_LDT_LOADS#

[top of page]

Table: AD_UPDATE_PREFERENCES

Description: Not currently used - contains information on various preferences that can be set and referenced during an upgrade
Comments

Not currently used - Contains information on various preferences that can be set and referenced during an upgrade

Columns
Name Datatype Length Mandatory Comments
PREFERENCE_ID NUMBER (15) Y Unique id of preference
OWNER VARCHAR2 (30) Y owner of preference
NAME VARCHAR2 (50) Y Preference name
DESCRIPTION VARCHAR2 (250)
Description preference
DEFAULT_VALUE VARCHAR2 (250)
Default value of pref
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_UPDATE_PREFERENCES does not reference any database object

APPLSYS.AD_UPDATE_PREFERENCES is referenced by following:

APPLSYS
VIEW - AD_UPDATE_PREFERENCES#

[top of page]

Table: AD_UPDATE_PREF_VALUES

Description: Not currently used - contains values specified for a preference at various levels. A value can be specified globally that is applicable for all patch sessions or individually for a specific patch session
Comments

Not currently used - Contains values specified for a preference at various levels. A value can be specified globally that is applicable for all patch sessions or individually for a specific patch session

Columns
Name Datatype Length Mandatory Comments
PREFERENCE_ID NUMBER (15) Y Unique id of preference
PREF_LEVEL VARCHAR2 (10)
preference level
PREF_LEVEL_VALUE VARCHAR2 (30)
Session id
VALUE VARCHAR2 (250)
preference value
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPLSYS.AD_UPDATE_PREF_VALUES does not reference any database object

APPLSYS.AD_UPDATE_PREF_VALUES is referenced by following:

APPLSYS
VIEW - AD_UPDATE_PREF_VALUES#

[top of page]

Table: AD_UPDATE_WORK_PARAMS

Description: Not currently used - contains name-value pairs that can be set and retrieved by upgrade scripts running at various stages during a patch application
Comments

Not currently used - Contains name-value pairs that can be set and retrieved by upgrade scripts running at various stages during a patch application

Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER (5)
session value
OWNER VARCHAR2 (30) Y Product owner
NAME VARCHAR2 (50) Y Name of parameter
VALUE VARCHAR2 (250)
value of the parameter
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.

[top of page]

APPLSYS.AD_UPDATE_WORK_PARAMS does not reference any database object

APPLSYS.AD_UPDATE_WORK_PARAMS is referenced by following:

APPLSYS
VIEW - AD_UPDATE_WORK_PARAMS#

[top of page]

Table: AD_WORKING_RES_LOCKS

Description: Holds Active Locks held by AD Utilites
Comments

Holds Active Locks held by AD Utilites

Indexes
Index Type Tablespace Column
AD_WORKING_RES_LOCKS_U1 UNIQUE APPS_TS_INTERFACE SESSION_ID
RESOURCE_CODE
CONTEXT
APPL_TOP_ID
LANGUAGE
EXTRA_CONTEXT1
EXTRA_CONTEXT2
EXTRA_CONTEXT3
IN_PROCESS_FLAG
Columns
Name Datatype Length Mandatory Comments
APPL_TOP_ID NUMBER
Y Foreign Key to AD_APPL_TOPS
SESSION_ID NUMBER
Y Foreign Key to AD Sessions
RESOURCE_CODE VARCHAR2 (30) Y Application System Resource
CONTEXT VARCHAR2 (30) Y Resource subset
LOCK_MODE VARCHAR2 (1) Y Shared or Exclusive
LANGUAGE VARCHAR2 (8) Y Language for the resource. US, or F, or D, etc.
IN_PROCESS_FLAG VARCHAR2 (1) Y Processing requiring this lock in progress
SESSION_STATUS VARCHAR2 (30) Y Foreign Key to AD_SESSIONS.STATUS
SESSION_PRIORITY NUMBER
Y Foreign Key to AD_SESSIONS.PRIORITY
DATE_REQUESTED DATE
Y Date the Lock was Requested
EXTRA_CONTEXT1 VARCHAR2 (30) Y Currently not used. Holds a value ALL
EXTRA_CONTEXT2 VARCHAR2 (30) Y Currently not used. Holds a value ALL
EXTRA_CONTEXT3 VARCHAR2 (30) Y Currently not used. Holds a value ALL
DATE_ACQUIRED DATE

Date and Time when the lock is acquired

[top of page]

APPLSYS.AD_WORKING_RES_LOCKS does not reference any database object

APPLSYS.AD_WORKING_RES_LOCKS is referenced by following:

APPLSYS
VIEW - AD_WORKING_RES_LOCKS#

[top of page]

Table: FND_MODULE_INSTALLATIONS

Description: Oracle Application modules installed at your site
Primary Key: FND_MODULE_INSTALLATIONS_PK
  1. APPLICATION_ID
  2. ORACLE_ID
  3. MODULE_SHORT_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
FND_MODULE_INSTALLATIONS.APPLICATION_ID FND_APPLICATION
FND_MODULE_INSTALLATIONS.ORACLE_ID FND_ORACLE_USERID
Comments

Oracle Application modules installed at your site

Indexes
Index Type Tablespace Column
FND_MODULE_INSTALLATIONS_PK UNIQUE APPS_TS_TX_IDX APPLICATION_ID
ORACLE_ID
MODULE_SHORT_NAME
FND_MODULE_INSTALLATIONS_N1 NONUNIQUE APPS_TS_TX_IDX MODULE_SHORT_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Identifies the product (application)
ORACLE_ID NUMBER (15) Y Identifies the Oracle user id
MODULE_SHORT_NAME VARCHAR2 (30) Y Module short name
STATUS VARCHAR2 (1) Y Installation status
MODULE_VERSION VARCHAR2 (30) Y Module version
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DB_STATUS VARCHAR2 (1) Y Y => Module's database objects are installed in the database

[top of page]

APPLSYS.FND_MODULE_INSTALLATIONS does not reference any database object

APPLSYS.FND_MODULE_INSTALLATIONS is referenced by following:

APPLSYS
VIEW - FND_MODULE_INSTALLATIONS#

[top of page]

Table: FND_PRODUCT_DEPENDENCIES

Description: Dependencies of Oracle Applications products installed at your site
Primary Key: FND_PRODUCT_DEPENDENCIES_PK
  1. APPLICATION_ID
  2. ORACLE_ID
  3. REQUIRED_APPLICATION_ID
  4. REQUIRED_ORACLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FND_PRODUCT_DEPENDENCIES.APPLICATION_ID
FND_PRODUCT_DEPENDENCIES.ORACLE_ID 		FND_PRODUCT_INSTALLATIONS
FND_PRODUCT_DEPENDENCIES.REQUIRED_APPLICATION_ID
FND_PRODUCT_DEPENDENCIES.REQUIRED_ORACLE_ID 		FND_PRODUCT_INSTALLATIONS
Comments

FND_PRODUCT_DEPENDENCIES stores information about each Oracle
Applications product at your site. Each row includes values that
identify the product installation (APPLICATION_ID, ORACLE_ID).
Each row also includes values that identify the installation of the
dependent or "shared" product (REQUIRED_APPLICATION_ID,
REQUIRED_ORACLE_ID). For example, if your application requires two
other products, Oracle Application Object Library and Oracle General
Leddger, then you should have two rows for your application.
Oracle Applications uses this information for installing and upgrading
the database and for other purposes.

Indexes
Index Type Tablespace Column
FND_PRODUCT_DEPENDENCIES_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
ORACLE_ID
REQUIRED_APPLICATION_ID
REQUIRED_ORACLE_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier
ORACLE_ID NUMBER (15) Y ORACLE account in which the application is installed
REQUIRED_APPLICATION_ID NUMBER (15) Y Identifier of application that the application depends on
REQUIRED_ORACLE_ID NUMBER (15) Y ORACLE account in which the dependent application is installed
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

[top of page]

APPLSYS.FND_PRODUCT_DEPENDENCIES does not reference any database object

APPLSYS.FND_PRODUCT_DEPENDENCIES is referenced by following:

APPLSYS
VIEW - FND_PRODUCT_DEPENDENCIES#

[top of page]

Table: FND_PRODUCT_GROUPS

Description: Site specific information used by AD utilities
Primary Key: FND_PRODUCT_GROUPS_PK
  1. PRODUCT_GROUP_ID
Primary Key: FND_PRODUCT_GROUPS_UK1
  1. PRODUCT_GROUP_NAME
Comments

FND_PRODUCT_GROUPS stores information about what release, language and type of product group (for example, Standard or Demonstration) you have installed at your site. FND_PRODUCT_GROUPS also stores supplementary information about the product group type in the ARGUMENT1 column. FND_PRODUCT_GROUPS is used mainly by AutoInstall. Oracle Application Object Library uses this information to provide you with release information when you do \ Help Version. You should never modify this table. The CODESET column is no longer used and may contain the value 'Not Used'.

Columns
Name Datatype Length Mandatory Comments
PRODUCT_GROUP_ID NUMBER (15) Y Product group identifier
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PRODUCT_GROUP_NAME VARCHAR2 (60) Y Product group name
RELEASE_NAME VARCHAR2 (50) Y Release name
PRODUCT_GROUP_TYPE VARCHAR2 (30) Y Product group type (for example, Standard)
ARGUMENT1 VARCHAR2 (30)
Supplementary information for product group type
MULTI_ORG_FLAG VARCHAR2 (1)
Y => the Oracle Applications installation is a multi-org installation
MULTI_LINGUAL_FLAG VARCHAR2 (1)
Y => the Oracle Applications installation is a multi-lingual installation
MULTI_CURRENCY_FLAG VARCHAR2 (1)
Is Multi-Currency installed in this database
APPLICATIONS_SYSTEM_NAME VARCHAR2 (30) Y Name of the "Applications System"
IS_NEW_TS_MODE VARCHAR2 (1)
Y => The Oracle Applications installation has embraced the new tablespace model (the one based on I/O characteristics)
ARU_RELEASE_NAME VARCHAR2 (50)
Aru Release Name

[top of page]

APPLSYS.FND_PRODUCT_GROUPS does not reference any database object

APPLSYS.FND_PRODUCT_GROUPS is referenced by following:

APPLSYS
VIEW - FND_PRODUCT_GROUPS#

[top of page]

Table: FND_PRODUCT_INSTALLATIONS

Description: Oracle Applications products installed at your site
Primary Key: FND_PRODUCT_INSTALLATIONS_PK
  1. APPLICATION_ID
  2. ORACLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FND_PRODUCT_INSTALLATIONS.APPLICATION_ID FND_APPLICATION
FND_PRODUCT_INSTALLATIONS.ORACLE_ID FND_ORACLE_USERID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTION_SET_CHECKS.APPLICATION_ID
ALR_ACTION_SET_CHECKS.ORACLE_ID 		FND_PRODUCT_INSTALLATIONS
FND_PRODUCT_DEPENDENCIES.APPLICATION_ID
FND_PRODUCT_DEPENDENCIES.ORACLE_ID 		FND_PRODUCT_INSTALLATIONS
FND_PRODUCT_DEPENDENCIES.REQUIRED_APPLICATION_ID
FND_PRODUCT_DEPENDENCIES.REQUIRED_ORACLE_ID 		FND_PRODUCT_INSTALLATIONS
Comments

FND_PRODUCT_INSTALLATIONS stores information about Oracle Applications products at your site. Each row includes a value identifying the application (APPLICATION_ID), a value identifying the database account (ORACLE_ID), the product's version number (PRODUCT_VERSION), the product's status at your site (STATUS, where I means installed, L means custom, N means not installed, and S means installed as shared product), and the product's industry (INDUSTRY, where C means for commercial or for-profit use, G means for educational or not-for-profit use, B means Project Billing, and P means Project Costing). Each row also includes the names of the tablespace in which the application tables, indexes, and temporary objects reside (TABLESPACE, INDEX_TABLESPACE, and TEMPORARY_TABLESPACE), and the sizing factor for the product (SIZING_FACTOR). Oracle Applications uses this information to display product version numbers when you choose \ Help Version, when installing and upgrading your database, and for other purposes.
.
INSTALL_GROUP_NUM is 0 for SOA products and 1 for MOA products.
.
MOA (Multiple Oracle account) products are products that needed multiple Oracle accounts to support multiple sets of books.
.
SOA (Single Oracle account) products are those that need only 1 Oracle account, either because they are able to handle multiple sets of books with one Oracle account, or they have nothing to do with sets of books.

Indexes
Index Type Tablespace Column
FND_PRODUCT_INSTALLATIONS_PK UNIQUE APPS_TS_TX_IDX APPLICATION_ID
ORACLE_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier
ORACLE_ID NUMBER (15) Y ORACLE account in which the application is installed
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PRODUCT_VERSION VARCHAR2 (30)
Version number for the application
STATUS VARCHAR2 (1)
The status of the application
INDUSTRY VARCHAR2 (1)
The industry of the application
TABLESPACE VARCHAR2 (30)
Name of tablespace for the application's tables
INDEX_TABLESPACE VARCHAR2 (30)
Name of tablespace for the application's indexes
TEMPORARY_TABLESPACE VARCHAR2 (30)
Name of tablespace for temporary objects
SIZING_FACTOR NUMBER

The sizing factor for the application
INSTALL_GROUP_NUM NUMBER (15)
0 for SOA products; 1 for MOA products
DB_STATUS VARCHAR2 (1)
Y => Product's database objects are installed in the database
PATCH_LEVEL VARCHAR2 (30)
Current Mini-pack level of the product (eg. 11i.AD.B, etc)

[top of page]

APPLSYS.FND_PRODUCT_INSTALLATIONS does not reference any database object

APPLSYS.FND_PRODUCT_INSTALLATIONS is referenced by following:

APPLSYS
VIEW - FND_PRODUCT_INSTALLATIONS#

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract