FND_FILE_UPLOAD_TRACKERS
This table tracks the state of files being uploaded for Attachments using a background process, which is separate from the primary process used by the User Interface.
Details
-
Schema: ATTACHMENTS
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FND_FILE_UPLOAD_TRACKER_PK |
UPLOAD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| UPLOAD_ID | NUMBER | 18 | Yes | Unique Identifier for a File Upload that is being tracked by this table. | |
| TRACKER_ID | VARCHAR2 | 40 | Yes | Public Identifier used to synchronize the upload of the file and the attachment it is associated with. | |
| DOCUMENT_ID | NUMBER | 18 | Yes | Unique identifier in the FND_DOCUMENTS table generated from the creation of a new Attachment record. | |
| FILE_NAME | VARCHAR2 | 2048 | Yes | Name of the File that is being uploaded. | |
| FILE_SIZE | NUMBER | 18 | Yes | Size of the file, in bytes, of the file that is being uploaded. | |
| MIME_TYPE | VARCHAR2 | 257 | Yes | Type of the file being uploaded, using the MIME type assigned. | |
| LANGUAGES | VARCHAR2 | 256 | Yes | Language codes associated with the file being uploaded. | |
| STATUS | VARCHAR2 | 10 | Yes | The state of the file being uploaded. | |
| ERROR_MESSAGE | VARCHAR2 | 4000 | Describes the reason for the error to the end user. | ||
| ERROR_ACTION | VARCHAR2 | 4000 | Describes the action the end user needs to take to resolve the error. | ||
| DM_REPOSITORY | VARCHAR2 | 80 | Name of the Content Server connection that received the file upload. | ||
| DM_DOCUMENT_ID | VARCHAR2 | 255 | Document Identifier assigned to the file by the Content Server. | ||
| DM_VERSION_NUMBER | VARCHAR2 | 255 | Version Number assigned to the file by the Content Server. | ||
| RECENT_ITEM_ID | NUMBER | 18 | Navigation information for the page and record that initiated the upload. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_BUCKET | VARCHAR2 | 256 | Name of the bucket that stores the file in the Object Store. | ||
| OBJECT_NAME | VARCHAR2 | 1024 | Name of the file in the Object Store. | ||
| CEC_PARENT_ID | VARCHAR2 | 255 | The identifier of the parent folder of the file in Oracle Content and Experience Cloud. | ||
| CEC_FILE_ID | VARCHAR2 | 255 | The identifier of the file in Oracle Content and Experience Cloud. | ||
| UPLOAD_METADATA | VARCHAR2 | 4000 | Additional custom information required as part of an upload for a specific repository | ||
| SOURCE_CONTENT_TYPE | VARCHAR2 | 257 | Original MIME type of the file being uploaded. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_FILE_UPLOAD_TRACKER_N1 | Non Unique | FUSION_TS_TX_DATA | DOCUMENT_ID |
| FND_FILE_UPLOAD_TRACKER_N2 | Non Unique | Default | DM_DOCUMENT_ID |
| FND_FILE_UPLOAD_TRACKER_U1 | Unique | FUSION_TS_TX_DATA | UPLOAD_ID |
| FND_FILE_UPLOAD_TRACKER_U2 | Unique | FUSION_TS_TX_DATA | TRACKER_ID |