eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ICX.ICX_CAT_BATCH_JOBS_ALL

Object Details

Object Name:	ICX_CAT_BATCH_JOBS_ALL
Object Type:	TABLE
Owner:	ICX
Subobject Name:
Status:	VALID

This table holds information regarding jobs submitted for loading data,changing schema, or converting files. Certain columns (ROLE , PO_HEADER_ID,DOCUMENT_TYPE_CODE, DOCUMENT_NUMBER, ORG_ID , INTERFACE_HEADER_ID) are onlyapplicable for loading data. This table will be purged periodically based onthe profile POR: Purge Jobs Older Than (days).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000401953C00005$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_NUMBER	NUMBER		Yes	Job Number which uniquely identifies a Catalog Batch Process
JOB_TYPE	VARCHAR2	(40)	Yes	Job Type. Valid values are defined in the Catalog Loader and Downloader Configuration File
JOB_STATUS	VARCHAR2	(240)	Yes	Job Status. Valid Statuses are PENDING, RUNNING, COMPLETED, ERROR.
USER_FILE_NAME	VARCHAR2	(500)		User file name as supplied by the user at upload time
FILE_CONTENT	BLOB	(4000)		This column stores the file content as a blob.
ROLE	VARCHAR2	(10)		Role of the user submitting the job. It can be one of the following: BUYER, SUPPLIER, or CAT_ADMIN.
PO_HEADER_ID	NUMBER			Header Id of the document
DOCUMENT_TYPE_CODE	VARCHAR2	(25)		Lookup code for document type (GBPA, BPA, QUOTATION)
DOCUMENT_NUMBER	VARCHAR2	(20)		Document Number
ORG_ID	NUMBER			Owning Org Id of the document
INTERFACE_HEADER_ID	NUMBER			Interface Header Id from the PO_HEADERS_INTERFACE
LINES_PROCESSED	NUMBER			The number of lines processed
LINES_FAILED	NUMBER			The number of lines failed
FAILURE_MESSAGE	VARCHAR2	(4000)		Failure Message
SYSTEM_FAILURE_MESSAGE	VARCHAR2	(4000)		Operating System Failure message, if any. Exception stack trace is stored here.
SUBMISSION_DATETIME	DATE			Date and Time of job submission
START_DATETIME	DATE			Date and Time the job started processing
COMPLETION_DATETIME	DATE			Date and Time the job completed
CREATED_BY	NUMBER		Yes	Standard WHO Columns
CREATION_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard WHO Columns
SESSION_ID	NUMBER			Session id to retrieve the log file

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT JOB_NUMBER
,      JOB_TYPE
,      JOB_STATUS
,      USER_FILE_NAME
,      FILE_CONTENT
,      ROLE
,      PO_HEADER_ID
,      DOCUMENT_TYPE_CODE
,      DOCUMENT_NUMBER
,      ORG_ID
,      INTERFACE_HEADER_ID
,      LINES_PROCESSED
,      LINES_FAILED
,      FAILURE_MESSAGE
,      SYSTEM_FAILURE_MESSAGE
,      SUBMISSION_DATETIME
,      START_DATETIME
,      COMPLETION_DATETIME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SESSION_ID
FROM ICX.ICX_CAT_BATCH_JOBS_ALL;

Dependencies

[top of page]

ICX.ICX_CAT_BATCH_JOBS_ALL does not reference any database object

ICX.ICX_CAT_BATCH_JOBS_ALL is referenced by following:

ICX: ICX_CAT_BATCH_JOBS_ALL#