POR_DOC_UPLOAD_JOBS
This table is used to store the details of the Jobs submitted for uploading lines to an agreement. These details are stored locally and not retrieved from the ESS framework.
Details
-
Schema: FUSION
-
Object owner: POR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
POR_DOC_UPLOAD_JOBS_PK |
JOB_NUMBER |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
JOB_NUMBER | NUMBER | 18 | Yes | Job Number which uniquely identifies a Catalog Batch Process. When the job is submitted, ESS will return the Job Number. This Column stores the Job Number returned by ESS. | |
PDOI_INVOKED_FLAG | VARCHAR2 | 1 | Y if invokePDOI method called in the last run, this will be used to restart loader from last point of failure i.e. failed after committing the data to po interface tables. | ||
LOAD_MODE | VARCHAR2 | 1 | This will be used only in case of cif upload, value will be I for Incremental or F for Full | ||
JOB_TYPE | VARCHAR2 | 40 | Yes | Job Type. Valid Values are CATALOG_DATA_CIF_UPLOAD, CATALOG_DATA_CXML_CHECK, CATALOG_DATA_TXT_UPLOAD, CATALOG_DATA_XML_CHECK | |
JOB_STATUS | VARCHAR2 | 20 | Yes | Job Status. Valid Statuses are PENDING, RUNNING, COMPLETED, ERROR | |
USER_FILE_NAME | VARCHAR2 | 1000 | Yes | User file name as supplied by the user at upload time. | |
FILE_CONTENT | BLOB | The column stores the file content as a blob. | |||
ROLE | VARCHAR2 | 10 | Yes | Role of the user submitting the job. It can be one of the following: BUYER, SUPPLIER or CAT_ADMIN | |
PUNCHOUT_CATALOG_ID | NUMBER | 18 | Id of the punchout catalog to which this upload job belongs. | ||
PO_HEADER_ID | NUMBER | 18 | Yes | Header Id of the document. | |
INTERFACE_HEADER_ID | NUMBER | 18 | Interface Header Id from the PO_HEADERS_INTERFACE. | ||
LINES_PROCESSED | NUMBER | 9 | The number of lines processed. | ||
LINES_FAILED | NUMBER | 9 | The number of lines failed. | ||
FAILURE_MESSAGE | VARCHAR2 | 30 | Failure message. | ||
ERROR_STACK | CLOB | Java Error Stack, if any. Exception stack trace is stored here. | |||
SUBMISSION_DATE | TIMESTAMP | Date and Time of job submission | |||
START_DATE | TIMESTAMP | Date and Time of the job started processing. | |||
COMPLETION_DATE | TIMESTAMP | Date and Time of the job completed. | |||
LATEST_JOB_FLAG | VARCHAR2 | 1 | Flag field to specifiy the Latest Agreement Job. | ||
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. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
POR_DOC_UPLOAD_JOBS | po_headers_all | PO_HEADER_ID |
POR_DOC_UPLOAD_JOBS | po_headers_interface | INTERFACE_HEADER_ID |
por_doc_parse_errors | por_doc_upload_jobs | JOB_NUMBER |
por_punchout_item_errors | por_doc_upload_jobs | JOB_NUMBER |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
POR_DOC_UPLOAD_JOBS_N1 | Non Unique | Default | PO_HEADER_ID |
POR_DOC_UPLOAD_JOBS_N2 | Non Unique | Default | PUNCHOUT_CATALOG_ID |
POR_DOC_UPLOAD_JOBS_U1 | Unique | Default | JOB_NUMBER |