eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IBC.IBC_AUDIT_LOGS

Object Details

Object Name:	IBC_AUDIT_LOGS
Object Type:	TABLE
Owner:	IBC
FND Design Data:	IBC.IBC_AUDIT_LOGS
Subobject Name:
Status:	VALID

IBC_AUDIT_LOGS stores all the actions performed on any OCM object. It catches activity name, user who performed the activity, date and time, OCM object type and value the activity is performed against.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBC_AUDIT_LOGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AUDIT_LOG_ID
IBC_AUDIT_LOGS_N01	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_VALUE1 OBJECT_VALUE2

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_LOG_ID	NUMBER		Yes	Audit log unique identifier
ACTIVITY	VARCHAR2	(100)	Yes	Activity name
USER_ID	NUMBER	(15)	Yes	User who performed the activity
TIME_STAMP	DATE		Yes	Date and time the activity is performed
OBJECT_TYPE	VARCHAR2	(30)	Yes	OCM object type the activity is performed on
PARENT_VALUE	VARCHAR2	(254)		Parent Value
OBJECT_VALUE1	VARCHAR2	(254)	Yes	Object value 1 to identify the OCM object
OBJECT_VALUE2	VARCHAR2	(254)		Object value 2 to identify the OCM object
OBJECT_VALUE3	VARCHAR2	(254)		Object value 3 to identify the OCM object
OBJECT_VALUE4	VARCHAR2	(254)		Object value 4 to identify the OCM object
OBJECT_VALUE5	VARCHAR2	(254)		Object value 5 to identify the OCM object
DESCRIPTION	VARCHAR2	(2000)		Description of Audit Log
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated 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_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number for locking.
SECURITY_GROUP_ID	NUMBER			Security Group Identifier.
INTERNAL_FLAG	VARCHAR2	(1)		Internal Flag
APPLICATION_ID	NUMBER			Application id
MESSAGE_NAME	VARCHAR2	(80)		Message Name
EXTRA_INFO1_TYPE	VARCHAR2	(30)		Type Extra Information for Audit
EXTRA_INFO1_REF_TYPE	VARCHAR2	(30)		Extra Information reference type
EXTRA_INFO1_VALUE	VARCHAR2	(256)		Extra Informations value for Audit
EXTRA_INFO2_TYPE	VARCHAR2	(30)		Type Extra Information for Audit
EXTRA_INFO2_REF_TYPE	VARCHAR2	(30)		Extra Information reference type
EXTRA_INFO2_VALUE	VARCHAR2	(256)		Extra Informations value for Audit
EXTRA_INFO3_TYPE	VARCHAR2	(30)		Type Extra Information for Audit
EXTRA_INFO3_REF_TYPE	VARCHAR2	(30)		Extra Information reference type
EXTRA_INFO3_VALUE	VARCHAR2	(256)		Extra Informations value for Audit
EXTRA_INFO4_TYPE	VARCHAR2	(30)		Type Extra Information for Audit
EXTRA_INFO4_REF_TYPE	VARCHAR2	(30)		Extra Information reference type
EXTRA_INFO4_VALUE	VARCHAR2	(256)		Extra Informations value for Audit
EXTRA_INFO5_TYPE	VARCHAR2	(30)		Type Extra Information for Audit
EXTRA_INFO5_REF_TYPE	VARCHAR2	(30)		Extra Information reference type
EXTRA_INFO5_VALUE	VARCHAR2	(256)		Extra Informations value for Audit
OBJECT_STATUS	VARCHAR2	(30)		Object Status
MESSAGE_APPLICATION	VARCHAR2	(50)		Application Message

Query Text

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


SELECT AUDIT_LOG_ID
,      ACTIVITY
,      USER_ID
,      TIME_STAMP
,      OBJECT_TYPE
,      PARENT_VALUE
,      OBJECT_VALUE1
,      OBJECT_VALUE2
,      OBJECT_VALUE3
,      OBJECT_VALUE4
,      OBJECT_VALUE5
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      INTERNAL_FLAG
,      APPLICATION_ID
,      MESSAGE_NAME
,      EXTRA_INFO1_TYPE
,      EXTRA_INFO1_REF_TYPE
,      EXTRA_INFO1_VALUE
,      EXTRA_INFO2_TYPE
,      EXTRA_INFO2_REF_TYPE
,      EXTRA_INFO2_VALUE
,      EXTRA_INFO3_TYPE
,      EXTRA_INFO3_REF_TYPE
,      EXTRA_INFO3_VALUE
,      EXTRA_INFO4_TYPE
,      EXTRA_INFO4_REF_TYPE
,      EXTRA_INFO4_VALUE
,      EXTRA_INFO5_TYPE
,      EXTRA_INFO5_REF_TYPE
,      EXTRA_INFO5_VALUE
,      OBJECT_STATUS
,      MESSAGE_APPLICATION
FROM IBC.IBC_AUDIT_LOGS;

Dependencies

[top of page]

IBC.IBC_AUDIT_LOGS does not reference any database object

IBC.IBC_AUDIT_LOGS is referenced by following:

APPS: IBC_AUDIT_LOGS