OKC_ART_INT_BATPROCS_ALL
An internal system table that stores the batch process parameters and statistics for each import run.
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
OKC_ART_INT_BATPROCS_ALL_PK |
BATCH_PROCESS_ID, ENTITY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_PROCESS_ID | NUMBER | 18 | Yes | Primary key to identify the batch process run. | |
| 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. | |
| BATCH_NUMBER | VARCHAR2 | 100 | Yes | Value for Batch process parameter for the run. | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| VALIDATE_ONLY_YN | VARCHAR2 | 1 | Yes | Yes/No flag to indicate the value for 'Validate Only' parameter for this run. If 'Y', then it has been run in validation mode. If 'N', then it has been run in import mode. | |
| FETCH_SIZE | NUMBER | Yes | Value for the parameter "Commit Size" for this run. | ||
| START_DATE | DATE | Yes | Time stamp for the beginning of the run | ||
| END_DATE | DATE | Time stamp for the end of the run | |||
| TOTAL_ROWS_PROCESSED | NUMBER | The total number of rows processed for this run. | |||
| TOTAL_ROWS_FAILED | NUMBER | The number of rows failed in the run. | |||
| TOTAL_ROWS_WARNED | NUMBER | The number of rows processed with warnings. | |||
| 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_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. | ||
| IMPORT_SOURCE | VARCHAR2 | 1 | Source of the Import | ||
| GLOBAL_FLAG | VARCHAR2 | 1 | Value of the Global Flag that will be defaulted in case of it is not provided in the XML Based Clause Import | ||
| CLAUSE_STATUS | VARCHAR2 | 30 | Value of the Clause Status that will be defaulted in case of it is not provided in the XML Based Clause Import | ||
| ENTITY | VARCHAR2 | 30 | Yes | Entity to which, batch number created for Import corresponds. It includes CLAUSES,VARIABLES,VALUESETS,VSVALUES,RELATIONSHIPS | |
| SOURCE_FILE_NAME | VARCHAR2 | 4000 | Source File name from where the data is imported | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the Application name spawning the Concurrent Request |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_ART_INT_BATPROCS_ALL_U1 | Unique | Default | BATCH_PROCESS_ID, ENTITY |
| OKC_ART_INT_BATPROCS_ALL_U2 | Unique | Default | BATCH_NUMBER, START_DATE, ORG_ID, ENTITY |