ZCA_BATCH_DETAILS
The ZCA_BATCH_DETAILS is a transactional table that holds details about each batch that is submitted via a job.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
ZCA_BATCH_DETAILS_PK |
BATCH_DETAIL_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
BATCH_DETAIL_ID | NUMBER | 18 | Yes | Sequence generated primary key. | |
JOB_DEFINITION | VARCHAR2 | 800 | ESS job definition. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
PARENT_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the parent request ID of the job that created or last updated the row. | ||
BATCH_MODE | VARCHAR2 | 250 | Mode of batch. For example 'FULL','INCREMENTAL', 'RECOVER', etc. | ||
SOURCE_OBJECT_CODE | VARCHAR2 | 250 | The source object to import. Example - IB Asset, OSS Asset. | ||
NUMBER_OF_BATCHES | NUMBER | 10 | Number of batches per source object code. | ||
BATCH_ID | NUMBER | 18 | Batch Identifier. | ||
BATCH_STATUS | VARCHAR2 | 100 | Execution status of the batch. Valid values are 'QUEUED', 'PROCESSING', 'COMPLETE','ERROR'. | ||
PROCESSED_ROW_COUNT | NUMBER | 18 | Number of rows processed with the batch. | ||
ERROR_MESSAGE | VARCHAR2 | 4000 | Error message for the batch. | ||
RECOVERABLE_FLAG | VARCHAR2 | 1 | Indicator to show if the batch is 'RECOVERABLE or 'NON-RECOVERABLE'. | ||
RETRIES_LEFT | NUMBER | 2 | Number of re-tries left for the batch. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ZCA_BATCH_DETAILS_N1 | Non Unique | Default | PARENT_REQUEST_ID, BATCH_ID, SOURCE_OBJECT_CODE |
ZCA_BATCH_DETAILS_N2 | Non Unique | Default | PARENT_REQUEST_ID, BATCH_STATUS, RECOVERABLE_FLAG |
ZCA_BATCH_DETAILS_N3 | Non Unique | Default | JOB_DEFINITION, BATCH_STATUS |
ZCA_BATCH_DETAILS_PK | Unique | Default | BATCH_DETAIL_ID |