OSS_SUB_BATCHES

This table is used to capture information on the sub batches run for the async action ess job.

Details

• Schema: FUSION

• Object owner: OSS

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
OSS_SUB_BATCHES_PK	SUB_BATCH_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SUB_BATCH_ID	NUMBER		18	Yes	Indicates the sub batch identifier for the table.
FLOW_SEQUENCE	NUMBER		18		Identifies the flow sequence of a given flow type.
BATCH_ID	NUMBER		18	Yes	Identifies the batch identifier from the OSS_BATCHES table.
BATCH_REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
SUB_BATCH_REQUEST_ID	NUMBER		18		Identifies the request id for the sub batch.
SUB_BATCH_STATUS	VARCHAR2	30			Identifies the status of the sub batch. Can have values 0 (New), 1 (Success) and 2 (Error).
JOB_ITEM_COUNT	NUMBER		18		Identifies the number of items being processed in the batch.
START_DATE	TIMESTAMP				Identifies the start date of the sub batch.
END_DATE	TIMESTAMP				Identifies the end date of the sub batch.
ACTION	VARCHAR2	30			Identifies the action being executed for this sub batch.
PHASE	NUMBER		18		Identifies the phase of the sub batch job.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
OSS_SUB_BATCHES	oss_batches	BATCH_ID
oss_batch_items	oss_sub_batches	SUB_BATCH_ID

Indexes

Index	Uniqueness	Tablespace	Columns
OSS_SUB_BATCHES_N1	Non Unique	Default	BATCH_ID, PHASE, SUB_BATCH_REQUEST_ID
OSS_SUB_BATCHES_N2	Non Unique	Default	BATCH_ID, PHASE, SUB_BATCH_STATUS
OSS_SUB_BATCHES_PK	Unique	Default	SUB_BATCH_ID