DBA Data[Home] [Help] [Dependency Information]

TABLE: ICX.ICX_AUDIT

Object Details
Object Name: ICX_AUDIT
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_AUDIT
Subobject Name:
Status: VALID


ICX_AUDIT is available to developers to store audit information about
any web transaction.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_AUDIT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUDIT_ID
ICX_AUDIT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWEB_USER_ID
ICX_AUDIT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
Columns
Name Datatype Length Mandatory Comments
AUDIT_ID NUMBER
Yes Identifier of audit record
SESSION_ID NUMBER
Yes Identifier of session in which audit record created
WEB_USER_ID NUMBER
Yes Identifier of user when audit record created
SERVER_NAME VARCHAR2 (80)
Server name
SERVER_PORT VARCHAR2 (80)
Server port
SCRIPT_NAME VARCHAR2 (80)
What was being run
PATH_INFO VARCHAR2 (80)
What URL was being accessed
PARAMETER_NAME_1 VARCHAR2 (80)
First parameter name
PARAMETER_1 VARCHAR2 (80)
First parameter value
PARAMETER_NAME_2 VARCHAR2 (80)
Second parameter name
PARAMETER_2 VARCHAR2 (80)
Second parameter value
PARAMETER_NAME_3 VARCHAR2 (80)
Third parameter name
PARAMETER_3 VARCHAR2 (80)
Third parameter value
PARAMETER_NAME_4 VARCHAR2 (80)
Fourth parameter name
PARAMETER_4 VARCHAR2 (80)
Fourth parameter value
PARAMETER_NAME_5 VARCHAR2 (80)
Fifth parameter name
PARAMETER_5 VARCHAR2 (80)
Fifth parameter value
PARAMETER_NAME_6 VARCHAR2 (80)
Sixth parameter name
PARAMETER_6 VARCHAR2 (80)
Sixth parameter value
PARAMETER_NAME_7 VARCHAR2 (80)
Seventh parameter name
PARAMETER_7 VARCHAR2 (80)
Seventh parameter value
PARAMETER_NAME_8 VARCHAR2 (80)
Eighth parameter name
PARAMETER_8 VARCHAR2 (80)
Eighth parameter value
PARAMETER_NAME_9 VARCHAR2 (80)
Nineth parameter name
PARAMETER_9 VARCHAR2 (80)
Nineth parameter value
CONNECT_DATE DATE
Yes Audit record creation date and time
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUDIT_ID
,      SESSION_ID
,      WEB_USER_ID
,      SERVER_NAME
,      SERVER_PORT
,      SCRIPT_NAME
,      PATH_INFO
,      PARAMETER_NAME_1
,      PARAMETER_1
,      PARAMETER_NAME_2
,      PARAMETER_2
,      PARAMETER_NAME_3
,      PARAMETER_3
,      PARAMETER_NAME_4
,      PARAMETER_4
,      PARAMETER_NAME_5
,      PARAMETER_5
,      PARAMETER_NAME_6
,      PARAMETER_6
,      PARAMETER_NAME_7
,      PARAMETER_7
,      PARAMETER_NAME_8
,      PARAMETER_8
,      PARAMETER_NAME_9
,      PARAMETER_9
,      CONNECT_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_AUDIT;

Dependencies

[top of page]

ICX.ICX_AUDIT does not reference any database object

ICX.ICX_AUDIT is referenced by following:

SchemaICX
ViewICX_AUDIT#