UploadSuppliersAttachment
Uploads new attachments for supplier records, capturing vital documents like certifications or financial statements.
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.
You can upload the attachment in one of the following ways.
- You can provide a FileLocation to upload an attachment:
exec UploadSuppliersAttachment SupplierId=415, Description='adasd', Title='asd15asdasd', FileLocation='D:\\abc.txt'
- You can provide FileName and FileContents(Base64 format) to upload an attachment:
exec UploadSuppliersAttachment FileName='test2.txt', SupplierId=415, Description='adasd', Title='asd15asdasd', FileContents='SGVsbG8gdGhpcyBpcyB0aGUgZmlsZSB'
- You can provide a URL to upload an attachment:
exec UploadSuppliersAttachment FileName='test2.txt', SupplierId=415, Description='adasd', Title='asd15asdasd', URL='http://abc.com/qwerty.txt'
- You can provide a FileURL to upload an attachment:
exec UploadSuppliersAttachment FileName='test2.txt', SupplierId=415, Description='adasd', Title='asd15asdasd', FileURL='http://abc.com/qwerty.txt'
- You can provide a URI to upload an attachment:
exec UploadSuppliersAttachment FileName='test2.txt', SupplierId=415, Description='adasd', Title='asd15asdasd', URI='http://abc.com/qwerty#abc'
- You can provide UploadedText to upload an attachment:
exec UploadSuppliersAttachment FileName='test2.txt', SupplierId=415, Description='adasd', Title='asd15asdasd', UploadedText='dfsdf sdf'
Input
| Name | Type | Description |
| SupplierId | Long | The unique identifier for the supplier. This ID links the attachment to a specific supplier, allowing for tracking and processing of the attachment in relation to the supplier. |
| FileName | String | The name of the attachment file. This is used for storing and identifying the uploaded file within the system. |
| DatatypeCode | String | An abbreviation that identifies the data type of the attachment. Examples include 'PDF,' 'DOCX,' or 'JPEG.' The values for these data types are often defined in lookup types. |
| DmFolderPath | String | The folder path in the document management system where the attachment is stored. This helps in organizing the file and locating it within the system. |
| DmDocumentId | String | A unique identifier for the document in the document management system, ensuring the attachment can be traced and retrieved uniquely. |
| DmVersionNumber | String | The version number of the attachment, useful for tracking revisions or updates to the document. |
| Url | String | The URL pointing to the attachment, which is used to access the document externally or programmatically. |
| Uri | String | The URI (Uniform Resource Identifier) used internally to uniquely identify the attachment within the system. |
| FileUrl | String | The full URL that can be used to access the attachment directly. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared within the content repository. 'True' means the file is shared; 'False' means it is not shared. |
| Title | String | The title of the attachment. It is a brief description or name that identifies the document's content. |
| Description | String | A detailed description of the attachment, providing context and additional information about the document's content. |
| ErrorStatusCode | String | An error code associated with the attachment, if any, indicating issues encountered during the file upload or processing. |
| ErrorStatusMessage | String | A detailed error message corresponding to the error status code, offering more information about the encountered issue. |
| FileContents | String | The contents of the attachment, typically represented as a byte string or Base64-encoded data, allowing the system to store smaller files directly in the database. |
| ExpirationDate | Datetime | The expiration date of the attachment, indicating when the document will no longer be valid or accessible in the system. |
| AsyncTrackerId | String | An identifier used for tracking the asynchronous processing of the uploaded file. This is important for monitoring the status of large or delayed uploads. |
| DownloadInfo | String | A JSON object containing the necessary data to programmatically retrieve the file attachment. This can include download URLs, credentials, or other metadata. |
| PostProcessingAction | String | The action to be performed after the attachment is uploaded. This can include actions like 'Validate,' 'Store,' or 'Approve,' depending on the workflow. |
| CategoryName | String | The category of the attachment, such as 'Invoice,' 'Contract,' or 'Purchase Order,' which helps classify the document for easier retrieval and processing. |
| UploadedText | String | The text content extracted from the uploaded attachment, if the document is text-based (for example, PDF or Word document). |
| FileLocation | String | The location of the file that needs to be uploaded, typically referring to a local or network path to the file. |
Result Set Columns
| Name | Type | Description |
| AttachedDocumentId | Long | The unique identifier of the attached document, assigned once the file has been successfully uploaded and processed. |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated in the system, providing an audit trail for changes. |
| LastUpdatedBy | String | The user or system that last updated the attachment record, providing traceability for modifications. |
| FileName | String | The name of the uploaded file, stored after processing. This ensures that the document is identified consistently. |
| DatatypeCode | String | The data type abbreviation of the uploaded file, such as 'PDF,' 'JPEG,' or 'MP4,' which helps the system process the file correctly. |
| DmFolderPath | String | The folder path where the attachment is stored in the document management system. This provides the location of the document for retrieval. |
| DmDocumentId | String | The unique document ID in the document management system, ensuring the attachment can be tracked and referenced uniquely. |
| DmVersionNumber | String | The version number of the document, which helps track any revisions or updates made to the attachment. |
| Url | String | The URL of the attachment, used to retrieve the file or access it from external systems. |
| Uri | String | The URI of the attachment, providing a system-level reference to the document. |
| FileUrl | String | The full URL of the attachment, providing direct access to the file for external or internal use. |
| UploadedText | String | The extracted text content of the uploaded file, if available. This could include text extracted from PDFs or Word files. |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. |
| UploadedFileLength | Long | The size of the uploaded file in bytes. This can be used to verify that the file meets system size limits. |
| UploadedFileName | String | The name of the uploaded file as stored in the system, which can be used for tracking and referencing the file. |
| ContentRepositoryFileShared | Bool | Indicates whether the uploaded file is shared within the content repository. 'True' means it is shared; 'False' means it is not. |
| Title | String | The title of the uploaded attachment, typically used to describe the content or subject of the file. |
| Description | String | A description of the uploaded attachment, offering further context or details about the document. |
| ErrorStatusCode | String | The error code associated with the attachment, if any. This code can help identify issues encountered during processing or validation. |
| ErrorStatusMessage | String | The error message corresponding to the error status code, providing additional details about the issue. |
| CreatedBy | String | The user who created the attachment record in the system, providing traceability for the file's origin. |
| CreationDate | Datetime | The date and time when the attachment was first created in the system, providing insight into the document's history. |
| FileContents | String | The contents of the uploaded file, typically stored as byte strings or Base64-encoded data in the system. |
| ExpirationDate | Datetime | The expiration date of the attachment's contents, indicating when the document will no longer be accessible or valid. |
| LastUpdatedByUserName | String | The username of the user who last updated the attachment record. This helps track changes to the file. |
| CreatedByUserName | String | The username of the user who initially created the attachment record, providing traceability for the document. |
| AsyncTrackerId | String | An identifier used to track the asynchronous processing of the uploaded file, useful for monitoring file uploads. |
| FileWebImage | String | A Base64-encoded image of the uploaded file, displayed in PNG format if the file is an image that can be converted. |
| DownloadInfo | String | A JSON object containing the details needed to programmatically retrieve the file attachment, including download parameters. |
| PostProcessingAction | String | The action that can be taken after the file is uploaded, such as 'Validate,' 'Store,' or 'Approve,' which determines the next step in the workflow. |
| CategoryName | String | The category of the uploaded attachment, which helps classify and organize documents for easier retrieval. |