UploadReceivablesInvoicesAttachment
Attaches documents to a Receivables invoice, helping maintain comprehensive records of billed items or services.
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 UploadReceivablesInvoicesAttachment CustomerTransactionId=415, Description='adasd', Title='asd15asdasd', FileLocation='D:\\abc.txt'
- You can provide FileName and FileContents(Base64 format) to upload an attachment:
exec UploadReceivablesInvoicesAttachment FileName='test2.txt', CustomerTransactionId=415, Description='adasd', Title='asd15asdasd', FileContents='SGVsbG8gdGhpcyBpcyB0aGUgZmlsZSB'
- You can provide a URL to upload an attachment:
exec UploadReceivablesInvoicesAttachment FileName='test2.txt', CustomerTransactionId=415, Description='adasd', Title='asd15asdasd', URL='http://abc.com/qwerty.txt'
- You can provide a FileURL to upload an attachment:
exec UploadReceivablesInvoicesAttachment FileName='test2.txt', CustomerTransactionId=415, Description='adasd', Title='asd15asdasd', FileURL='http://abc.com/qwerty.txt'
- You can provide a URI to upload an attachment:
exec UploadReceivablesInvoicesAttachment FileName='test2.txt', CustomerTransactionId=415, Description='adasd', Title='asd15asdasd', URI='http://abc.com/qwerty#abc'
- You can provide UploadedText to upload an attachment:
exec UploadReceivablesInvoicesAttachment FileName='test2.txt', CustomerTransactionId=415, Description='adasd', Title='asd15asdasd', UploadedText='afdfd dsf eefa'
Input
| Name | Type | Description |
| CustomerTransactionId | Long | The unique identifier of the credit memo to which the attachment is associated. |
| FileName | String | The name of the attachment file being uploaded. |
| DatatypeCode | String | The code that identifies the data type of the attachment (for example, PDF, Image). |
| DmFolderPath | String | The folder path where the attachment is stored in the document management system. |
| DmDocumentId | String | A unique identifier assigned to the attachment within the document management system. |
| DmVersionNumber | String | The version number of the attachment. |
| Url | String | The URL to access the attachment. |
| Uri | String | The URI used to identify the attachment within the system. |
| FileUrl | String | The direct URL 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 | An error code, if any, that occurred during the upload or processing of the attachment. |
| ErrorStatusMessage | String | An error message, if any, providing further details on the error related to the attachment. |
| FileContents | String | The content of the attachment file represented as a byte string. |
| ExpirationDate | Datetime | The date when the attachment contents will expire or become invalid. |
| AsyncTrackerId | String | An identifier used for tracking the status of the uploaded file asynchronously. |
| DownloadInfo | String | A JSON object containing metadata and information needed to retrieve the attachment programmatically. |
| PostProcessingAction | String | The name of any action that can be performed after the attachment is uploaded. |
| CategoryName | String | The category or classification assigned to the attachment. |
| UploadedText | String | The textual content of the attachment, if applicable. |
| FileLocation | String | The location of the file to be uploaded (physical or network path). |
Result Set Columns
| Name | Type | Description |
| AttachedDocumentId | Long | The unique identifier of the document that was 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 file name of the uploaded attachment. |
| DatatypeCode | String | The data type code for the uploaded attachment (for example, PDF, Image). |
| DmFolderPath | String | The folder path where the uploaded attachment is stored in the document management system. |
| DmDocumentId | String | The unique document identifier assigned after the attachment is uploaded. |
| DmVersionNumber | String | The version number of the uploaded attachment. |
| Url | String | The URL to access the uploaded attachment. |
| Uri | String | The URI to the uploaded attachment in the system. |
| FileUrl | String | The URL pointing to the uploaded attachment file. |
| UploadedText | String | The text content of the uploaded attachment, if applicable. |
| UploadedFileContentType | String | The content type of the uploaded file. |
| UploadedFileLength | Long | The size of the uploaded file in bytes. |
| UploadedFileName | String | The name of the uploaded file. |
| ContentRepositoryFileShared | Bool | Indicates whether the uploaded attachment is shared. |
| Title | String | The title of the uploaded attachment. |
| Description | String | The description of the uploaded attachment. |
| ErrorStatusCode | String | The error code, if any, encountered during the upload process of the attachment. |
| ErrorStatusMessage | String | The error message, if any, encountered 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 uploaded attachment, returned as a byte string. |
| 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 | An identifier for tracking the status of the file upload process asynchronously. |
| FileWebImage | String | A Base64-encoded image of the uploaded file displayed in PNG format if the source is a convertible image. |
| DownloadInfo | String | A JSON object containing information to retrieve the uploaded file programmatically. |
| PostProcessingAction | String | The name of the action that can be performed after the file has been uploaded. |
| CategoryName | String | The category of the uploaded attachment. |