[Home] [Help] [Dependency Information]
Object Name: | AD_PATCH_COMMON_ACTIONS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | AD.AD_PATCH_COMMON_ACTIONS |
Subobject Name: | |
Status: | VALID |
This table holds distinct information about the various actions that are (often repeatedly) performed by Autopatch as part of applying patches.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AD_PATCH_COMMON_ACTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | COMMON_ACTION_ID |
AD_PATCH_COMMON_ACTIONS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CONCAT_ATTRIBS |
AD_PATCH_COMMON_ACTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMMON_ACTION_ID | NUMBER | Yes | PK | |
ACTION_CODE | VARCHAR2 | (30) | Yes | Action code, eg. sql, exec, etc |
CONCAT_ATTRIBS | VARCHAR2 | (3000) | Yes | 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 | Yes | 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 | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT COMMON_ACTION_ID
, ACTION_CODE
, CONCAT_ATTRIBS
, ACTION_PHASE
, NUMERIC_PHASE
, NUMERIC_SUB_PHASE
, ACTION_ARGUMENTS
, CHECKFILE_ARGS
, ACTION_CHECK_OBJ
, ACTION_CHECK_OBJ_USERNAME
, ACTION_CHECK_OBJ_PASSWD
, ACTION_WHAT_SQL_EXEC
, ACTION_TIERLIST_IN_DRIVER
, ACTION_LANG_CODE
, CREATION_DATE
, LOADER_DATA_FILE_ID
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPLSYS.AD_PATCH_COMMON_ACTIONS;
APPLSYS.AD_PATCH_COMMON_ACTIONS does not reference any database object
APPLSYS.AD_PATCH_COMMON_ACTIONS is referenced by following:
|
|
|