[Home] [Help]
[Dependency Information]
Object Name: | JTF_FM_CONTENT_FAILURES |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Table that holds details on Failed Requests
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_FM_CONTENT_FAILURES_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
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 |
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;
JTF.JTF_FM_CONTENT_FAILURES does not reference any database object
JTF.JTF_FM_CONTENT_FAILURES is referenced by following:
|
|
|