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: XDP.XDP_FA_RESUBMISSION_LOG

Object Details

Object Name:	XDP_FA_RESUBMISSION_LOG
Object Type:	TABLE
Owner:	XDP
FND Design Data:	XDP.XDP_FA_RESUBMISSION_LOG
Subobject Name:
Status:	VALID

XDP_FA_RESUBMISSION_LOG records the resubmission jobs for Oracle SFM. The Fulfillment Elements may be restarted in Order Resubmission mode to resubmit orders to the provisioning workflow.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XDP_FA_RESUBMISSION_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESUBMISSION_JOB_ID
XDP_FA_RESUBMISSION_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBMITTED_BY
XDP_FA_RESUBMISSION_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FE_ID STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
RESUBMISSION_JOB_ID	NUMBER		Yes	System generated unique identifier for the resubmission log
FULFILLMENT_ELEMENT_NAME	VARCHAR2	(40)	Yes	Name of the fulfillment element
FE_ID	NUMBER		Yes	Unique identifier for the fulfillment element
SUBMITTED_BY	VARCHAR2	(80)	Yes	Identification of the order resubmission requestor
TIMESTAMP	DATE		Yes	Date and time for the Order Resubmission request
STATUS_CODE	VARCHAR2	(40)	Yes	Status of the resubmission process
START_DATE	DATE		Yes	Start date for the resubmission process
END_DATE	DATE		Yes	Requested end date for the resubmission process
COMPLETION_DATE	DATE			Actual completion date of the resubmission process
CREATION_DATE	DATE		Yes	Standard who cloumn
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who cloumn
LAST_UPDATE_DATE	DATE		Yes	Standard who cloumn
CREATED_BY	NUMBER	(15)	Yes	Standard who cloumn
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who cloumn
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT RESUBMISSION_JOB_ID
,      FULFILLMENT_ELEMENT_NAME
,      FE_ID
,      SUBMITTED_BY
,      TIMESTAMP
,      STATUS_CODE
,      START_DATE
,      END_DATE
,      COMPLETION_DATE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XDP.XDP_FA_RESUBMISSION_LOG;

Dependencies

[top of page]

XDP.XDP_FA_RESUBMISSION_LOG does not reference any database object

XDP.XDP_FA_RESUBMISSION_LOG is referenced by following:

APPS: XDP_FA_RESUBMISSION_LOG