[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_ALLOC_BATCHES |
|---|---|
| Object Type: | TABLE |
| Owner: | GL |
| FND Design Data: |  SQLGL.GL_ALLOC_BATCHES
|
| Subobject Name: | |
| Status: | VALID |
GL_ALLOC_BATCHES stores information about MassAllocation and MassBudget batches. Each row includes a batch's unique ID, name, status, and description. This table corresponds to the Define MassAllocations and Define MassBudget windows.
You need one row for each MassAllocation or MassBudget batch. ACTUAL_FLAG values are "A" or "E" for MassAllocation batches and "B" for MassBudget batches, denoting the balance type associated with your allocation entries.
VALIDATION_STATUS is 'N' when you first define, or have recently changed but not validated a MassAllocation or MassBudget batch, and 'V' after your batch has been successfully validated. If you submit your batch for validation, and it completes with errors, your VALIDATION_STATUS column contains the value 'E'. VALIDATION_REQUEST_ID is the concurrent request id associated with the MassAllocation Validation Program run that validated your batch.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_ALLOC_BATCHES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ALLOCATION_BATCH_ID
|
| GL_ALLOC_BATCHES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
NAME
CHART_OF_ACCOUNTS_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ALLOCATION_BATCH_ID | NUMBER | (15) | Yes | Mass allocation batch defining column |
| NAME | VARCHAR2 | (39) | Yes | Mass allocation batch name |
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Yes | Key flexfield structure defining column |
| VALIDATION_STATUS | VARCHAR2 | (1) | Yes | Batch validation result, valid or error |
| ACTUAL_FLAG | VARCHAR2 | (1) | Yes | Balance type (Actual, Budget, or Encumbrance) |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| VALIDATION_REQUEST_ID | NUMBER | (15) | Batch validation request id | |
| DESCRIPTION | VARCHAR2 | (240) | Mass allocation batch description | |
| SECURITY_FLAG | VARCHAR2 | (1) | Yes | Enable definition access set security flag |
Cut, paste (and edit) the following text to query this object:
SELECT ALLOCATION_BATCH_ID
, NAME
, CHART_OF_ACCOUNTS_ID
, VALIDATION_STATUS
, ACTUAL_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, VALIDATION_REQUEST_ID
, DESCRIPTION
, SECURITY_FLAG
FROM GL.GL_ALLOC_BATCHES;
GL.GL_ALLOC_BATCHES does not reference any database object
GL.GL_ALLOC_BATCHES is referenced by following:
GL
GL_ALLOC_BATCHES#
|
|
|
|