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_POR_BATCH_JOBS

Object Details

Object Name:	ICX_POR_BATCH_JOBS
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.ICX_POR_BATCH_JOBS
Subobject Name:
Status:	VALID

Holds information about submitted catalog batch processes. Each job submitted for either loading images, items, prices, schema or to download schema, items or prices or to publish or discard loaded items or to approve or reject prices stores information in this table. Each job is assigned a job number and the ip address of the server servicing the request is stored. Loaders and downloaders use the ip address as a means of determining which job to process since there is a loader/downloader running per server.
Jobs are also assigned a type depending on their function (uploading xml items or xml schema, etc).
The type determines which class within the loader/downloader will service the request. The mapping between the type and the class is done within the Loader/Downloader configuration file.
Some job types, such as image loading store specific data relative to their job in subtables.
This table will be purged at operator defined intervals.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_BATCH_JOBS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	JOB_NUMBER
ICX_POR_BATCH_JOBS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLIER_ID
ICX_POR_BATCH_JOBS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOB_STATUS JOB_TYPE JOB_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_NUMBER	NUMBER		Yes	Job Number which uniquely identifies a Catalog Batch Process
SUPPLIER_ID	NUMBER		Yes	Supplier ID
SUPPLIER_FILE_NAME	VARCHAR2	(500)		Supplier file name as supplied by the supplier at upload time
EXCHANGE_FILE_NAME	VARCHAR2	(500)		File name that Exchange uses to save the file
ITEMS_LOADED	NUMBER		Yes	Count of Items successfully loaded
ITEMS_FAILED	NUMBER		Yes	Count of Items that failed during a Loader batch process.
JOB_STATUS	VARCHAR2	(240)	Yes	Job Status. Valid Statuses are PENDING, RUNNING, COMPLETED, COMPLETED W/ERRORS, FAILED, PENDING PUBLICATION, FAILED PUBLICATION, PUBLISHED, PENDING DISCARD, FAILED DISCARD, DISCARDED
SUBMISSION_DATETIME	DATE		Yes	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
FAILURE_MESSAGE	VARCHAR2	(4000)		Failure message
HOST_IP_ADDRESS	VARCHAR2	(15)		IP Address of the Web Server from where the job was submitted. This helps us balance the load in a multi-loader setup.
EXCHANGE_OPERATOR_NAME	VARCHAR2	(255)		Exchange Operator Name
JOB_TYPE	VARCHAR2	(40)		Job Type. Valid values are defined in the Catalog Loader and Downloader Configuration File
SYSTEM_FAILURE_MESSAGE	VARCHAR2	(4000)		Operating System Failure message, if any.
LANGUAGE	VARCHAR2	(4)		Language in which the job is submitted
PRICES_LOADED	NUMBER			Count of Price Lines that were successfully loaded.
PRICES_FAILED	NUMBER			Count of Price Lines that failed the load.
EXCHANGE_OPERATOR_ID	NUMBER			Exchange Operator Internal Identification Number
MAX_FAILED_LINES	NUMBER			User defined maximum allowed failed lines in a load job before the job is terminated.
LOAD_SUPPLIER_ID	NUMBER			Supplier Internal Identifier for owner of items during an item loader job. The SUPPLIER_ID in this case represents the Third Party Catalog Author Internal Identifier if the job was submitted by a Third Party.
HEADERS_LOADED	NUMBER			Count of headers successfully loaded
HEADERS_FAILED	NUMBER			Count of headers that failed the load
TIMEZONE	VARCHAR2	(30)		Time zone
CREATED_BY	NUMBER			Standard WHO Columns
CREATION_DATE	DATE			Standard WHO Columns
LAST_UPDATED_BY	NUMBER			Standard WHO Columns
LAST_UPDATE_DATE	DATE			Standard WHO Columns
REQUEST_ID	NUMBER			Stores the concurrent request id
DESCRIPTION	VARCHAR2	(4000)		Stores the description of the load file
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Columns

Query Text

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


SELECT JOB_NUMBER
,      SUPPLIER_ID
,      SUPPLIER_FILE_NAME
,      EXCHANGE_FILE_NAME
,      ITEMS_LOADED
,      ITEMS_FAILED
,      JOB_STATUS
,      SUBMISSION_DATETIME
,      START_DATETIME
,      COMPLETION_DATETIME
,      FAILURE_MESSAGE
,      HOST_IP_ADDRESS
,      EXCHANGE_OPERATOR_NAME
,      JOB_TYPE
,      SYSTEM_FAILURE_MESSAGE
,      LANGUAGE
,      PRICES_LOADED
,      PRICES_FAILED
,      EXCHANGE_OPERATOR_ID
,      MAX_FAILED_LINES
,      LOAD_SUPPLIER_ID
,      HEADERS_LOADED
,      HEADERS_FAILED
,      TIMEZONE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      DESCRIPTION
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_POR_BATCH_JOBS;

Dependencies

[top of page]

ICX.ICX_POR_BATCH_JOBS does not reference any database object

ICX.ICX_POR_BATCH_JOBS is referenced by following:

APPS: ICX_POR_BATCH_JOBS