UpdateSuppliersAttachment
Modifies an existing document attached to a supplier record, maintaining up-to-date reference files.
Stored Procedure Specific Information
Oracle Fusion Cloud Financials allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only the = comparison.
For example:
exec UpdateSuppliersAttachment SupplierId=415, AttachmentsUniqID=4544554, Description='adasd asd asd asd asd asdsss sdwdasd adff.'
Input
| Name | Type | Description |
| SupplierId | Long | The unique identifier for the supplier associated with the attachment. This ID helps link the attachment to a specific supplier in the system. |
| AttachmentsUniqID | Long | The unique identifier of the attachment. This is used to reference the specific attachment for the supplier in the system. |
| AttachedDocumentId | Long | The unique identifier of the attached document. This value is required to uniquely identify and reference the document associated with the supplier. |
| FileName | String | The file name of the attachment, which is used to store and retrieve the attachment within the system. |
| DatatypeCode | String | An abbreviation identifying the data type of the attachment. Common values include 'PDF' or 'image', and are often defined in a lookup type. |
| DmFolderPath | String | The folder path in the document management system where the attachment is stored. This path helps locate the document within the system. |
| DmDocumentId | String | A unique identifier for the attachment in the document management system. This ID ensures the attachment is distinctly referenced. |
| DmVersionNumber | String | The version number of the attachment. This helps track revisions and updates to the document. |
| Url | String | The URL where the attachment is stored, used to access the document from external systems or applications. |
| Uri | String | The URI (Uniform Resource Identifier) of the attachment. This serves as a system reference to the attachment location. |
| FileUrl | String | The full URL to the attachment. This link is used to directly access the document in the system. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared with other users or systems. 'True' means the file is shared; 'False' means it is not. |
| Title | String | The title of the attachment, typically describing the content or subject of the document for easier identification. |
| Description | String | A description of the attachment, offering more context about its content or purpose. |
| ErrorStatusCode | String | The error code, if any, associated with the attachment. This code helps identify issues during processing. |
| ErrorStatusMessage | String | The error message related to the attachment, if any, providing further details about the encountered issue. |
| FileContents | String | The contents of the attachment, usually represented as a byte string or Base64 encoding. This allows the file to be stored directly in the system. |
| ExpirationDate | Datetime | The expiration date of the contents in the attachment, indicating when the document will no longer be valid or accessible. |
| AsyncTrackerId | String | An identifier used to track the asynchronous processing of the uploaded file. It is helpful for monitoring or troubleshooting. |
| DownloadInfo | String | A JSON object represented as a string, containing the necessary information to programmatically retrieve the file attachment. |
| PostProcessingAction | String | The action that can be performed after the attachment is uploaded, such as 'Validate,' 'Approve,' or 'Store.' |
| CategoryName | String | The category of the attachment, helping to classify the document (for example, 'Invoice,' 'Contract'). This helps in organizing attachments. |
| Type | String | The type of the attachment, which may represent the file format (for example, 'PDF,' 'Excel'). This is used for categorization and processing. |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. |
| UploadedFileLength | Int | The length of the uploaded file in bytes. This helps verify the file size and ensure it meets system requirements. |
| UploadedFileName | String | The name of the uploaded attachment file, which is stored after the file is processed by the system. |
| UploadedText | String | The text of the attachment, used if the uploaded file is text-based (for example, plain text or PDF). |
| FileLocation | String | The location of the file that is to be uploaded, typically a file path or storage reference. |
Result Set Columns
| Name | Type | Description |
| AttachedDocumentId | Long | The unique identifier of the attached document after the file is uploaded and processed by the system. |
| LastUpdateDate | Datetime | The timestamp of the last update made to the attachment record. This tracks changes made to the attachment after its creation. |
| LastUpdatedBy | String | The user or system that last updated the attachment record, providing traceability of changes. |
| FileName | String | The file name of the attachment after it has been processed and stored in the system. |
| DmFolderPath | String | The folder path where the attachment is stored in the document management system. This path helps locate the document. |
| DmDocumentId | String | The unique document ID for the attachment in the document management system. This ID is used to reference the document in operations. |
| DmVersionNumber | String | The version number of the attachment, showing the latest revision of the document. |
| Url | String | The URL where the attachment can be accessed. This is typically used to retrieve the document externally. |
| Uri | String | The URI that uniquely identifies the attachment within the system. |
| FileUrl | String | The full URL of the attachment, used to access it directly from the system. |
| UploadedText | String | The text content of the uploaded attachment, if applicable (for example, for text-based documents like PDFs). |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. |
| UploadedFileLength | Long | The length of the uploaded file in bytes, used to verify that the file size is within acceptable limits. |
| UploadedFileName | String | The name of the file after it has been uploaded and stored in the system. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared. 'True' means the file is shared within the repository; 'False' means it is not. |
| Title | String | The title of the attachment, used to describe the document or its content. |
| Description | String | The description of the attachment, providing more details about the document. |
| ErrorStatusCode | String | The error code associated with the attachment, if any, which helps identify any issues that occurred during processing. |
| ErrorStatusMessage | String | The error message associated with the attachment, explaining the encountered issue. |
| CreatedBy | String | The user who created the attachment record in the system. |
| CreationDate | Datetime | The timestamp of when the attachment record was created. |
| FileContents | String | The contents of the attachment, typically stored as byte strings or Base64 encoding for smaller documents. |
| ExpirationDate | Datetime | The expiration date of the attachment contents, indicating when the document will no longer be valid. |
| LastUpdatedByUserName | String | The username of the user who last updated the attachment record, for tracking changes. |
| CreatedByUserName | String | The username of the user who originally created the attachment record. |
| AsyncTrackerId | String | An identifier for tracking the asynchronous processing of uploaded files, which helps in troubleshooting or monitoring. |
| FileWebImage | String | A Base64-encoded image of the file, displayed as a PNG format if the source is an image that can be converted. |
| DownloadInfo | String | A JSON object as a string, containing information to programmatically retrieve the file attachment. |
| PostProcessingAction | String | The action that can be performed after the attachment is uploaded, such as 'Validate' or 'Archive.' |
| Category | String | The category of the attachment, helping to classify and organize the documents. |
| Type | String | The type of the attachment, typically representing the file format (for example, 'PDF,' 'Excel'). |