[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XLA_TB_WORK_UNITS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARENT_REQUEST_ID
FROM_HEADER_ID |
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 |
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;
XLA.XLA_TB_WORK_UNITS does not reference any database object
XLA.XLA_TB_WORK_UNITS is referenced by following:
|
|
|