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: OKC.OKC_AQERRORS

Object Details

Object Name:	OKC_AQERRORS
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_AQERRORS
Subobject Name:
Status:	VALID

This holds a list of Advanced Queuing (AQ) errors reported by the process(es) subscribing to an AQ
Due to the asynchronous nature of AQ - there is no 'calling module' to report any errors encountered by the process subscribing to the AQ. If the subscribing process (or any other processes it calls) encounters any errors - it will write the details of the error to this table, including the name of the queue, the source name (name of API which reported the error), and msgid (unique identifier for that particular message on the queue - this can be used to query the queue exceptions table).
Details of the message stack associated with the error are in OKC_AQMSGSTACKS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_AQERRORS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
SYS_IL0000085523C00012$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	System generated Unique Identifier.
SOURCE_NAME	VARCHAR2	(30)	Yes	The source which triggered off the queue.
DATETIME	DATE			Date and Time of Occurrence
Q_NAME	VARCHAR2	(30)		Name of the Queue which had the error.
MSGID	RAW	(16)		Message ID.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
RETRY_COUNT	NUMBER	(4)		No of times the message has been put back on the AQ after error for retry .
QUEUE_CONTENTS	CLOB	(4000)		Message contents of the message on the queue .
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT ID
,      SOURCE_NAME
,      DATETIME
,      Q_NAME
,      MSGID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RETRY_COUNT
,      QUEUE_CONTENTS
,      SECURITY_GROUP_ID
FROM OKC.OKC_AQERRORS;

Dependencies

[top of page]

OKC.OKC_AQERRORS does not reference any database object

OKC.OKC_AQERRORS is referenced by following:

APPS: OKC_AQERRORS