UploadInvoicesAttachment
Uploads or updates attachments at the invoice header level in Payables, improving documentation for invoice processing.
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 UploadInvoicesAttachment InvoiceId=415, Description='test.', Title='asd15asdasd', FileLocation='D:\\abc.txt'
- You can provide FileName and FileContents(Base64 format) to upload an attachment:
exec UploadInvoicesAttachment FileName='test2.txt', InvoiceId=415, Description='test.', Title='asd15asdasd', FileContents='SGVsbG8gdGhpcyBpcyB0aGUgZmlsZSB'
- You can provide a URL to upload an attachment:
exec UploadInvoicesAttachment FileName='test2.txt', InvoiceId=415, Description='test.', Title='asd15asdasd', URL='http://abc.com/qwerty.txt'
- You can provide a FileURL to upload an attachment:
exec UploadInvoicesAttachment FileName='test2.txt', InvoiceId=415, Description='test.', Title='asd15asdasd', FileURL='http://abc.com/qwerty.txt'
- You can provide a URI to upload an attachment:
exec UploadInvoicesAttachment FileName='test2.txt', InvoiceId=415, Description='test.', Title='asd15asdasd', URI='http://abc.com/qwerty#abc'
- You can provide UploadedText to upload an attachment:
exec UploadInvoicesAttachment FileName='test2.txt', InvoiceId=415, Description='test.', Title='asd15asdasd', UploadedText='sddsfe df d'
Input
| Name | Type | Description |
| InvoiceId | Long | The unique identifier of the invoice associated with the attachment. |
| FileName | String | The name of the attachment file. |
| DmFolderPath | String | The folder path where the attachment is stored in the document management system. |
| DmDocumentId | String | The unique identifier of the document in the document management system. |
| DmVersionNumber | String | The version number of the attachment within the document management system. |
| Url | String | The URL where the attachment can be accessed. |
| Uri | String | The URI used to locate the attachment in the system. |
| FileUrl | String | The URL link to the attachment file. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared with other users or systems. |
| Title | String | The title or name of the attachment. |
| Description | String | A brief description of the attachment's content or purpose. |
| ErrorStatusCode | String | The error code associated with the attachment, if any. |
| ErrorStatusMessage | String | The detailed error message related to the attachment, if any. |
| FileContents | String | The binary content of the attachment as a byte string. |
| ExpirationDate | Datetime | The date when the attachment's content expires or becomes invalid. |
| AsyncTrackerId | String | A unique identifier for tracking the status of file uploads asynchronously. |
| DownloadInfo | String | A JSON object containing metadata and information required to programmatically retrieve the attachment. |
| PostProcessingAction | String | The name of the post-processing action to be performed once the attachment is uploaded. |
| Category | String | The category or classification of the attachment (for example, Invoice, Receipt). |
| Type | String | The file type of the attachment. |
| UploadedText | String | The text content of the attachment, if applicable. |
| FileLocation | String | The physical or network location of the file to be uploaded. |
Result Set Columns
| Name | Type | Description |
| AttachedDocumentId | Long | The unique identifier of the document that has been attached. |
| LastUpdateDate | Datetime | The date when the attachment record was last updated. |
| LastUpdatedBy | String | The user who last updated the attachment record. |
| FileName | String | The name of the attachment file after upload. |
| DmFolderPath | String | The folder path where the attachment was stored after being uploaded. |
| DmDocumentId | String | The document ID assigned by the document management system after upload. |
| DmVersionNumber | String | The version number of the document after it has been uploaded. |
| Url | String | The URL where the uploaded attachment can be accessed. |
| Uri | String | The URI to the uploaded attachment in the system. |
| FileUrl | String | The URL pointing directly to the uploaded attachment file. |
| UploadedText | String | The text content of the attachment, if applicable. |
| UploadedFileContentType | String | The content type of the uploaded attachment file. |
| UploadedFileLength | Long | The size of the uploaded attachment file in bytes. |
| UploadedFileName | String | The name of the uploaded attachment file. |
| ContentRepositoryFileShared | Bool | Indicates whether the uploaded attachment is shared across multiple users or systems. |
| Title | String | The title of the uploaded attachment. |
| Description | String | The description of the uploaded attachment. |
| ErrorStatusCode | String | The error code if there was an issue during the upload of the attachment. |
| ErrorStatusMessage | String | The error message if there was an issue during the upload of the attachment. |
| CreatedBy | String | The user who created the attachment record. |
| CreationDate | Datetime | The date when the attachment record was created. |
| FileContents | String | The content of the attachment file, returned after upload. |
| ExpirationDate | Datetime | The expiration date of the uploaded attachment's contents. |
| LastUpdatedByUserName | String | The username of the person who last updated the attachment record. |
| CreatedByUserName | String | The username of the person who created the attachment record. |
| AsyncTrackerId | String | The tracking ID for asynchronous upload operations. |
| FileWebImage | String | A Base64-encoded image of the file in PNG format, if the source is a convertible image. |
| DownloadInfo | String | A JSON object containing information used to retrieve the attachment programmatically. |
| PostProcessingAction | String | The post-processing action to be performed after the attachment has been uploaded. |
| Category | String | The category of the uploaded attachment. |
| Type | String | The type of the uploaded attachment. |