[Home] [Help] [Dependency Information]
Object Name: | OKC_ART_INT_BATPROCS_ALL |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_ART_INT_BATPROCS_ALL |
Subobject Name: | |
Status: | VALID |
An internal system table that stores the batch process parameters and statistics for each import run.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_ART_INT_BATPROCS_ALL_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
BATCH_PROCESS_ID
ENTITY |
OKC_ART_INT_BATPROCS_ALL_U2 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
BATCH_NUMBER
START_DATE ORG_ID ENTITY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_PROCESS_ID | NUMBER | Yes | Primary key to identify the batch process run. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. | |
BATCH_NUMBER | VARCHAR2 | (50) | Yes | Value for Batch process parameter for the run. |
ORG_ID | NUMBER | The organization that ran the batch import. | ||
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 | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Concurrent Program column | ||
PROGRAM_LOGIN_ID | NUMBER | Standard Concurrent Program column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Concurrent Program column | ||
REQUEST_ID | NUMBER | Standard Concurrent Program column | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_PROCESS_ID
, OBJECT_VERSION_NUMBER
, BATCH_NUMBER
, ORG_ID
, VALIDATE_ONLY_YN
, FETCH_SIZE
, START_DATE
, END_DATE
, TOTAL_ROWS_PROCESSED
, TOTAL_ROWS_FAILED
, TOTAL_ROWS_WARNED
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, IMPORT_SOURCE
, GLOBAL_FLAG
, CLAUSE_STATUS
, ENTITY
, SOURCE_FILE_NAME
FROM OKC.OKC_ART_INT_BATPROCS_ALL;
OKC.OKC_ART_INT_BATPROCS_ALL does not reference any database object
OKC.OKC_ART_INT_BATPROCS_ALL is referenced by following:
|
|
|