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

TABLE: ICX.ICX_CAT_R12_UPGRADE_JOBS

Object Details
Object Name: ICX_CAT_R12_UPGRADE_JOBS
Object Type: TABLE
Owner: ICX
Subobject Name:
Status: VALID


This table is used in R12 upgrade to keep track of the upgrade jobs submitted by the user. The user can submit pre-upgrade, data exception and upgrade jobs.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
JOB_TYPE VARCHAR2 (20) Yes Job Type Values are: Pre-upgrade, data-exception and upgrade.
JOB_NUMBER NUMBER
Yes Job number
STATUS VARCHAR2 (1)
Status of the job. Values: P - PENDINGR - RUNNINGC - COMPLETEDF - FAILED
RUN_DATE DATE

Run date
AUDSID NUMBER

Current session id
PREUPG_COMPLETE_DATE DATE

The pre-upgrade completion date
PREUPG_PDOI_UPDATE_DATE DATE

The pre-upgrade po call back successful date
PREUPG_PDOI_COMPLETE_DATE DATE

The data migration to po schema complete date
PREUPG_BPA_COMPLETE_DATE DATE

The intermedia index populate complete date for Blankets.
PREUPG_QUOTE_COMPLETE_DATE DATE

The intermedia index populate complete date for Quotations.
PREUPG_REQTMPLT_COMPLETE_DATE DATE

The intermedia index populate complete date for Requisition Templates.
PREUPG_MI_COMPLETE_DATE DATE

The intermedia index populate complete date for Master Items.
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER
Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
REQUEST_ID NUMBER

Standard Concurrent Request Column
INTERNAL_REQUEST_ID NUMBER

Internal_request_id to track the changes done in a job. Different from request_id, because source of the items may not always be concurrent jobs.
PROGRAM_APPLICATION_ID NUMBER

Standard Concurrent Request Column
PROGRAM_ID NUMBER

Standard Concurrent Request Column
PROGRAM_LOGIN_ID NUMBER

Standard Concurrent Request Column
PDOI_BATCH_ID NUMBER

The batch_id used for the current job in po interface header
AUDSID2 NUMBER

When the current job is run as a parent, the audsid2 stores the session_id in which the parent was restarted after all the child jobs are processed.
Query Text

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


SELECT JOB_TYPE
,      JOB_NUMBER
,      STATUS
,      RUN_DATE
,      AUDSID
,      PREUPG_COMPLETE_DATE
,      PREUPG_PDOI_UPDATE_DATE
,      PREUPG_PDOI_COMPLETE_DATE
,      PREUPG_BPA_COMPLETE_DATE
,      PREUPG_QUOTE_COMPLETE_DATE
,      PREUPG_REQTMPLT_COMPLETE_DATE
,      PREUPG_MI_COMPLETE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      INTERNAL_REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PDOI_BATCH_ID
,      AUDSID2
FROM ICX.ICX_CAT_R12_UPGRADE_JOBS;

Dependencies

[top of page]

ICX.ICX_CAT_R12_UPGRADE_JOBS does not reference any database object

ICX.ICX_CAT_R12_UPGRADE_JOBS is referenced by following:

SchemaAPPS
SynonymICX_CAT_R12_UPGRADE_JOBS