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

TABLE: JTF.JTF_FM_CONTENT_FAILURES

Object Details
Object Name: JTF_FM_CONTENT_FAILURES
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_FM_CONTENT_FAILURES
Subobject Name:
Status: VALID


Table that holds details on Failed Requests


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_FM_CONTENT_FAILURES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Unique Request Identifier (as of 11.5.9)
CONTENT_NUMBER NUMBER
Yes Order in which the document should be displayed within the request
JOB NUMBER
Yes Job Number of Batch
MEDIA_TYPE VARCHAR2 (30)
Media type can be Email, Fax, Printer
ADDRESS VARCHAR2 (400)
Holds the address for the media type
FAILURE VARCHAR2 (30) Yes Holds the Failure code
CREATED_BY NUMBER
Yes Created by
CREATION_DATE DATE
Yes Creation Date
LAST_UPDATED_BY NUMBER
Yes Last updated by userId
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last updated by userId.
CORRECTED_ADDRESS VARCHAR2 (400)
Column to hold the corrected email address. If a request failed due to malformed email address, the user could correct the address by updating this field with the corrected email address and then resubmitting the original request.
CORRECTED_FLAG VARCHAR2 (1)
Column to indicate if the address information was corrected
Query Text

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


SELECT REQUEST_ID
,      CONTENT_NUMBER
,      JOB
,      MEDIA_TYPE
,      ADDRESS
,      FAILURE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CORRECTED_ADDRESS
,      CORRECTED_FLAG
FROM JTF.JTF_FM_CONTENT_FAILURES;

Dependencies

[top of page]

JTF.JTF_FM_CONTENT_FAILURES does not reference any database object

JTF.JTF_FM_CONTENT_FAILURES is referenced by following:

SchemaAPPS
SynonymJTF_FM_CONTENT_FAILURES