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: AX.AX_EVENTS

Object Details

Object Name:	AX_EVENTS
Object Type:	TABLE
Owner:	AX
FND Design Data:	AX.AX_EVENTS
Subobject Name:
Status:	VALID

This table stores information about the events that occurred in the
system and that need to be translated into a subledger entry. It
includes a row for each event.
Each row includes the type of the event, the identifier of the
document (invoice, payment or other) to which the event is related
and the status of the event; the following statuses are possible:
N: not translated
P: document not ready for translation
T: successfully translated
E: recoverable error during translation
U: unrecoverable error during translation; a manual operation is
required
W: warning; translation is successful but an abnormal status has been
met
If the type is 'E', 'U', or 'W', then the message text contains an
explanation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: AX_EVENTS_PK

EVENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_EVENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_ID
AX_EVENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID TRANSLATION_STATUS EVENT_DATE EVENT_ID
AX_EVENTS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID EVENT_FIELD1 EVENT_TYPE TRANSLATION_STATUS
AX_EVENTS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID EVENT_FIELD2 EVENT_TYPE TRANSLATION_STATUS
AX_EVENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID TRANSLATION_STATUS

Foreign Keys

Table		Foreign Table	Foreign Key Column
AX_SLE_HEADERS		AX_EVENTS	AX_SLE_HEADERS EVENT_ID
AX_SLE_HEADERS_ARCH		AX_EVENTS	AX_SLE_HEADERS_ARCH EVENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	NUMBER		Yes	Event identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
SET_OF_BOOKS_ID	NUMBER		Yes	Set of books identifier
APPLICATION_ID	NUMBER		Yes	Application identifier
EVENT_TYPE	VARCHAR2	(30)	Yes	Event type
EVENT_FIELD1	NUMBER			Numeric document identifier
EVENT_FIELD2	NUMBER			Numeric document identifier
EVENT_FIELD3	NUMBER			Numeric document identifier
EVENT_FIELD4	NUMBER			Numeric document identifier
EVENT_FIELD5	NUMBER			Numeric document identifier
EVENT_FIELD6	VARCHAR2	(255)		Character Document identifier
EVENT_FIELD7	VARCHAR2	(255)		Character Document identifier
EVENT_FIELD8	VARCHAR2	(255)		Character Document identifier
EVENT_FIELD9	VARCHAR2	(255)		Character Document identifier
EVENT_FIELD10	VARCHAR2	(255)		Character Document identifier
EVENT_DATE	DATE		Yes	Event accounting date
TRANSLATION_STATUS	VARCHAR2	(1)	Yes	Status
TRANSLATED_DATE	DATE			Date of translation
DOC_SEQUENCE_ID	NUMBER			Sequence identifier of the document
ADDITIONAL_DATE	DATE			Additional data
ADDITIONAL_NUMBER	NUMBER			Additional data
ADDITIONAL_VARCHAR2	VARCHAR2	(255)		Additional data
MESSAGE_TEXT	VARCHAR2	(2000)		Error or warning message
DOC_SEQUENCE_VALUE	NUMBER			Value of the document sequence
ORG_ID	NUMBER			Organization identifier
EVENT_FIELD11	DATE			Date document identifier
EVENT_FIELD12	DATE			Numeric document identifier
EVENT_FIELD13	DATE			Numeric document identifier
EVENT_FIELD14	DATE			Numeric document identifier
EVENT_FIELD15	DATE			Numeric document identifier
EVENT_FIELD16	NUMBER			Numeric document identifier
EVENT_FIELD17	NUMBER			Numeric document identifier
EVENT_FIELD18	NUMBER			Numeric document identifier
EVENT_FIELD19	NUMBER			Numeric document identifier
EVENT_FIELD20	NUMBER			Numeric document identifier
EVENT_FIELD21	VARCHAR2	(255)		Character Document identifier
EVENT_FIELD22	VARCHAR2	(255)		Character Document identifier
EVENT_FIELD23	VARCHAR2	(255)		Character Document identifier
EVENT_FIELD24	VARCHAR2	(255)		Character Document identifier
EVENT_FIELD25	VARCHAR2	(255)		Character Document identifier

Query Text

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


SELECT EVENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SET_OF_BOOKS_ID
,      APPLICATION_ID
,      EVENT_TYPE
,      EVENT_FIELD1
,      EVENT_FIELD2
,      EVENT_FIELD3
,      EVENT_FIELD4
,      EVENT_FIELD5
,      EVENT_FIELD6
,      EVENT_FIELD7
,      EVENT_FIELD8
,      EVENT_FIELD9
,      EVENT_FIELD10
,      EVENT_DATE
,      TRANSLATION_STATUS
,      TRANSLATED_DATE
,      DOC_SEQUENCE_ID
,      ADDITIONAL_DATE
,      ADDITIONAL_NUMBER
,      ADDITIONAL_VARCHAR2
,      MESSAGE_TEXT
,      DOC_SEQUENCE_VALUE
,      ORG_ID
,      EVENT_FIELD11
,      EVENT_FIELD12
,      EVENT_FIELD13
,      EVENT_FIELD14
,      EVENT_FIELD15
,      EVENT_FIELD16
,      EVENT_FIELD17
,      EVENT_FIELD18
,      EVENT_FIELD19
,      EVENT_FIELD20
,      EVENT_FIELD21
,      EVENT_FIELD22
,      EVENT_FIELD23
,      EVENT_FIELD24
,      EVENT_FIELD25
FROM AX.AX_EVENTS;

Dependencies

[top of page]

AX.AX_EVENTS does not reference any database object

AX.AX_EVENTS is referenced by following:

APPS: AX_EVENTS