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: ITG.ITG_BATCH_CLASS

Object Details

Object Name:	ITG_BATCH_CLASS
Object Type:	TABLE
Owner:	ITG
Subobject Name:
Status:	VALID

Batch class implementing a 1-1 mapping to batched client API. A row in this table must exist for every client API, to register it with the batch engine. Some fields, specifically 'limit_count' and 'timeout' can be altered by knowledgeable users (or managed by a screen).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_CLASS_ID	NUMBER		Yes	Primary key of table. Assigned as seed data (no sequence)
IMP_PKG_NAME	VARCHAR2	(80)	Yes	The implementing batched API package name (normally stored with mixed case, looked up case insensitive).
LIMIT_CNT	NUMBER		Yes	Maximum number of items per OPEN batch. If a gets this large, it is immediately closed by being switched into the PENDING state. The next time the current batch's process set id is requested, a new batch will be allocated. Can be set as low as 1 to implement a completely serialized processing mode (very inefficient, but good for testing); or can be set high for mass loading. (The default value for Sync Item is 100 items.)
TIMEOUT	NUMBER		Yes	Maximum number of idle seconds for a batch to be OPEN before being switched to PENDIND. This value depends partly on the tempo of data entry on the SAP side, as it is affected by the amount of time it takes to enter the particular transaction being batched. (The default value for Sync Item is 60 seconds.)
REPORTING_PROC	VARCHAR2	(200)		Full reporting procdure name (including package). It takes two arguments: the transaction ID (CLN ID) and a 1/0 flag indicating callback invocation.

Query Text

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


SELECT BATCH_CLASS_ID
,      IMP_PKG_NAME
,      LIMIT_CNT
,      TIMEOUT
,      REPORTING_PROC
FROM ITG.ITG_BATCH_CLASS;

Dependencies

[top of page]

ITG.ITG_BATCH_CLASS does not reference any database object

ITG.ITG_BATCH_CLASS is referenced by following:

APPS: ITG_BATCH_CLASS