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_TB_WORK_UNITS

Object Details

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

This table serves as a work unit table to process open account balances data in parallel. Accounting entries are split into multiple units based on ledger setups. For any new record, the STATUS_CODE column is initialized to UNPROCESSED. (Disabled definitions remain UNPROCESSED until that definition is enabled). After being processed, work unit records are deleted.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLA_TB_WORK_UNITS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_REQUEST_ID FROM_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PARENT_REQUEST_ID	NUMBER	(15)	Yes	Parent request id
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
GROUP_ID	NUMBER	(15)		Group idenitifier
DEFINITION_CODE	VARCHAR2	(30)		Definition code for the Open Account Balances Listing definition.
JE_SOURCE_NAME	VARCHAR2	(30)		Journal source name
UPG_BATCH_ID	NUMBER	(15)		Upgrade batch identifier
FROM_HEADER_ID	NUMBER	(15)	Yes	Low value of Accounting entry header id for the work unit
TO_HEADER_ID	NUMBER	(15)	Yes	High value of Accounting entry header id for the work unit
STATUS_CODE	VARCHAR2	(30)	Yes	Status of the group id and definition code being processed

Query Text

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


SELECT PARENT_REQUEST_ID
,      REQUEST_ID
,      GROUP_ID
,      DEFINITION_CODE
,      JE_SOURCE_NAME
,      UPG_BATCH_ID
,      FROM_HEADER_ID
,      TO_HEADER_ID
,      STATUS_CODE
FROM XLA.XLA_TB_WORK_UNITS;

Dependencies

[top of page]

XLA.XLA_TB_WORK_UNITS does not reference any database object

XLA.XLA_TB_WORK_UNITS is referenced by following:

APPS: XLA_TB_WORK_UNITS