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: XLA.XLA_REVERSE_EVENTS_INTERFACE

Object Details

Object Name:	XLA_REVERSE_EVENTS_INTERFACE
Object Type:	TABLE
Owner:	XLA
FND Design Data:	XLA.XLA_REVERSE_EVENTS_INTERFACE
Subobject Name:
Status:	VALID

The XLA_REVERSE_EVENTS_INTERFACE table stores records for accounting events that are to be reversed in bulk. The Bulk Reversal Event API reverses all these events in one run.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLA_REVERSE_EVENTS_INTF_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_CODE APPLICATION_ID LEDGER_ID EVENT_ID
XLA_REVERSE_EVENTS_INTF_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	REVERSAL_EVENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Internal identifier of the application associated with the event.
BATCH_CODE	VARCHAR2	(30)	Yes	The unique code for each event batch that needs to be reversed in one run.
LEDGER_ID	NUMBER	(15)	Yes	Internal identifier of the ledger associated with the event.
ENTITY_CODE	VARCHAR2	(30)	Yes	The code of the transaction entity associated with the event.
EVENT_ID	NUMBER	(15)	Yes
PROCESS_STATUS_CODE	VARCHAR2	(1)	Yes	The code of the event process status to indicate an event is reversed or not.The available process status codes are: P(Processed), U(Unprocessed)and E(Error).
REVERSAL_GL_DATE	DATE		Yes	The accounting date on which the event is to be reversed.
REVERSAL_ENTITY_ID	NUMBER	(15)		Internal identifier of the reversed entity.The Bulk Reversal Event API populates this column.
REVERSAL_EVENT_ID	NUMBER	(15)		Internal identifier of the reversed event.The Bulk Reversal Event API populates this column.
ACCOUNTING_BATCH_ID	NUMBER	(15)		Internal identifier of the reversed accounting batch.The Bulk Reversal Event API populates this column.

Query Text

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


SELECT APPLICATION_ID
,      BATCH_CODE
,      LEDGER_ID
,      ENTITY_CODE
,      EVENT_ID
,      PROCESS_STATUS_CODE
,      REVERSAL_GL_DATE
,      REVERSAL_ENTITY_ID
,      REVERSAL_EVENT_ID
,      ACCOUNTING_BATCH_ID
FROM XLA.XLA_REVERSE_EVENTS_INTERFACE;

Dependencies

[top of page]

XLA.XLA_REVERSE_EVENTS_INTERFACE does not reference any database object

XLA.XLA_REVERSE_EVENTS_INTERFACE is referenced by following:

XLA: XLA_REVERSE_EVENTS_INTERFACE#