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: INV.ORG_GL_BATCHES

Object Details

Object Name:	ORG_GL_BATCHES
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.ORG_GL_BATCHES
Subobject Name:
Status:	VALID

ORG_GL_BATCHES holds history rows for every batch of transactions that
have been interfaced to the GL_INTERFACE table. When you run the GL
Transfer or Period Close function, a new row will be inserted into
this table, using the next GL_BATCH_ID number. This row contains the
transfer date and the ACCT_PERIOD_ID from ORG_ACCT_PERIODS. The
GL_BATCH_ID column in the accounting transaction tables is updated
with this GL_BATCH_ID, and this id prevents the accounting transaction
from being interfaced twice to the GL_INTERFACE table. Upon launching
the GL Transfer function, the GL_BATCH_ID is set to 0 which
represents "Processing" status. The GL_BATCH_ID is set to a positive
number when successfully completed and to a negative number when
failure occurs. For Oracle Inventory, the accounting table is
MTL_TRANSACTION_ACCOUNTS; for Oracle Work In Process, the accounting
table is WIP_TRANSACTION_ACCOUNTS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORG_GL_BATCHES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID GL_BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCT_PERIOD_ID	NUMBER		Yes	Current accounting period id when GL batch is created
GL_BATCH_DATE	DATE		Yes	Scheduled close date of the current accounting period
DESCRIPTION	VARCHAR2	(50)		Description
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
GL_BATCH_ID	NUMBER		Yes	GL batch download identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column

Query Text

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


SELECT ACCT_PERIOD_ID
,      GL_BATCH_DATE
,      DESCRIPTION
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      GL_BATCH_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM INV.ORG_GL_BATCHES;

Dependencies

[top of page]

INV.ORG_GL_BATCHES does not reference any database object

INV.ORG_GL_BATCHES is referenced by following:

INV: ORG_GL_BATCHES#