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

TABLE: ICX.ICX_POR_FAILED_ATTACHMENTS

Object Details
Object Name: ICX_POR_FAILED_ATTACHMENTS
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_POR_FAILED_ATTACHMENTS
Subobject Name:
Status: VALID


Stores information relative to rejections that may occur during loading of attachments. SOme failure conditions leading to rejection while loading attachments include: the attachment does not comply to file specifications such is the case with images which must be of type .gif or .jpeg, the file size being uploaded exceeds the operator defined limit for the user or in the case of a deletion, the file requested for deletion does not exist in the system.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_POR_FAILED_ATTACHMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPPLIER_ID
ColumnJOB_NUMBER
Columns
Name Datatype Length Mandatory Comments
JOB_NUMBER NUMBER
Yes Internally generated job identifier for the batch process.
SUPPLIER_ID NUMBER
Yes Supplier ID for the supplier requesting loading of the attachment(s).
FILE_NAME VARCHAR2 (500) Yes File Name given by the user for the attachment.
ACTION VARCHAR2 (30) Yes Indicates the action to perform on the attachment.
MESSAGE_NAME VARCHAR2 (30) Yes Stores the message name indicating the reason for the rejection.
Query Text

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


SELECT JOB_NUMBER
,      SUPPLIER_ID
,      FILE_NAME
,      ACTION
,      MESSAGE_NAME
FROM ICX.ICX_POR_FAILED_ATTACHMENTS;

Dependencies

[top of page]

ICX.ICX_POR_FAILED_ATTACHMENTS does not reference any database object

ICX.ICX_POR_FAILED_ATTACHMENTS is referenced by following:

SchemaICX
ViewICX_POR_FAILED_ATTACHMENTS#