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: GL.GL_AUTO_ALLOC_BATCH_HISTORY

Object Details

Object Name:	GL_AUTO_ALLOC_BATCH_HISTORY
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_AUTO_ALLOC_BATCH_HISTORY
Subobject Name:
Status:	VALID

GL_AUTO_ALLOC_BATCH_HISTORY stores, for every run of an allocation set, one row for each batch in the allocation set. Each row includes a unique auto_alloc_batch_id, as well as a batch_name, a batch_type, owner, and allocation method. This table is required as batches included in the allocation set can be modified after the request submission and before the request is executed.
For step-down allocation set, the STEP NUMBER specifies the sequence in which the batch should be generated and posted. BATCH_TYPE_CODE is either 'A', 'B', 'E', 'R' or 'P' for MassAllocation, MassBudgets, Encumbrances, Recurring, or Projects batch respectively.
ALLOCATION_METHOD_CODE is 'I' for incremental allocation or 'F' for full allocation method. Owner represents the role name, defined in WF_ROLES table, who will receive the notification, for this particular batch, when any error occurs in step-down allocation run.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_AUTO_ALLOC_BATCH_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_ID BATCH_ID BATCH_TYPE_CODE GENERATED_JE_BATCH_ID
GL_AUTO_ALLOC_BATCH_HISTORY_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_ID STEP_NUMBER GENERATED_JE_BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER		Yes	Auto allocation concurrent request id
BATCH_ID	NUMBER	(15)	Yes	Defining column for Massalocation batch, Recurring Journal batch, MassBudget batch, or Project batch.
BATCH_TYPE_CODE	VARCHAR2	(1)	Yes	Batch Type (Massallocations, MassBudgets, MassEncumbrances, Recurring Journals, or Project Allocations)
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
STEP_NUMBER	NUMBER			Sequence in which batch is to be generated for step-down set.
OWNER	VARCHAR2	(100)		The owner/role specified for an Allocation batch who will receive notifications when any errors occur in Allocations
ALLOCATION_METHOD_CODE	VARCHAR2	(1)		Allocation method used for batch generation.
GENERATED_JE_BATCH_ID	NUMBER	(15)		Defining column for generated journal batch
PA_ALLOCATION_RUN_ID	NUMBER	(15)		Defining column for generated project rule id
STATUS_CODE	VARCHAR2	(150)		Run status of each step in the allocation set
COMPLETE_FLAG	VARCHAR2	(1)		Flag to indicate that step is generated and posted
ALL_HEADERS_REVERSED	VARCHAR2	(1)		Flag to indicate that all headers for the generated batch are reversed during rollback

Query Text

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


SELECT REQUEST_ID
,      BATCH_ID
,      BATCH_TYPE_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      STEP_NUMBER
,      OWNER
,      ALLOCATION_METHOD_CODE
,      GENERATED_JE_BATCH_ID
,      PA_ALLOCATION_RUN_ID
,      STATUS_CODE
,      COMPLETE_FLAG
,      ALL_HEADERS_REVERSED
FROM GL.GL_AUTO_ALLOC_BATCH_HISTORY;

Dependencies

[top of page]

GL.GL_AUTO_ALLOC_BATCH_HISTORY does not reference any database object

GL.GL_AUTO_ALLOC_BATCH_HISTORY is referenced by following:

APPS: GL_AUTO_ALLOC_BATCH_HISTORY