Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9175

UploadStandardReceiptsAttachment

Attaches or modifies supporting documentation for standard receipts, aiding payment reconciliation and recordkeeping.

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 = comparison.

You can upload the attachment in the following ways:

  • You can provide FileLocation to upload an attachment 
    	exec UploadStandardReceiptsAttachment StandardReceiptId=415, Description='adasd', Title='asd15asdasd', FileLocation='D:\\abc.txt'
  • You can provide FileName and FileContents(Base64 format) to upload an attachment 
    		exec UploadStandardReceiptsAttachment FileName='test2.txt', StandardReceiptId=415, Description='adasd', Title='asd15asdasd', FileContents='SGVsbG8gdGhpcyBpcyB0aGUgZmlsZSB'
  • You can provide URL to upload an attachment 
    		exec UploadStandardReceiptsAttachment FileName='test2.txt', StandardReceiptId=415, Description='adasd', Title='asd15asdasd', URL='http://abc.com/qwerty.txt'
  • You can provide FileURL to upload an attachment 
    		exec UploadStandardReceiptsAttachment FileName='test2.txt', StandardReceiptId=415, Description='adasd', Title='asd15asdasd', FileURL='http://abc.com/qwerty.txt'
  • You can provide URI to upload an attachment 
    		exec UploadStandardReceiptsAttachment FileName='test2.txt', StandardReceiptId=415, Description='adasd', Title='asd15asdasd', URI='http://abc.com/qwerty#abc'
  • You can provide UploadedText to upload an attachment 
    		exec UploadStandardReceiptsAttachment FileName='test2.txt', StandardReceiptId=415, Description='adasd', Title='asd15asdasd', UploadedText='sdwwd asdasdwa'

Input

Name Type Description
StandardReceiptId Long The unique identifier of the standard receipt, linking this attachment to a specific receipt for tracking and processing.
FileName String The name of the file being uploaded as an attachment. This name is used for identifying the file in the system.
DatatypeCode String An abbreviation or code that identifies the data type of the attachment, such as text, image, or PDF.
DmFolderPath String The folder path where the attachment is stored in the document management system, indicating the location of the file within the repository.
DmDocumentId String A unique identifier for the document within the document management system, used to track and manage the attachment.
DmVersionNumber String The version number of the document, used to track changes or updates to the attachment over time.
Url String The URL link to access the attachment directly from the system, typically used for online retrieval of the file.
Uri String The URI of the attachment, representing its resource location within the system, useful for programmatic access.
FileUrl String A URL where the attachment file can be directly accessed or downloaded by users or systems.
ContentRepositoryFileShared Bool Indicates whether the attachment file is shared with other users or remains private, defining its access rights.
Title String The title or name given to the attachment, used for identification and sorting purposes in the system.
Description String A brief description of the attachment, providing context or details about the content or purpose of the file.
ErrorStatusCode String The error code indicating any issues that occurred during the upload or processing of the attachment. This helps identify specific errors.
ErrorStatusMessage String The error message providing a detailed explanation if any errors occurred while uploading or processing the attachment.
FileContents String The byte string representing the actual contents of the file being uploaded, used for storage and processing.
ExpirationDate Datetime The expiration date of the attachment, after which the file may no longer be accessible or will be archived.
AsyncTrackerId String An identifier used to track the status of the file upload asynchronously, allowing for non-blocking processing of large files.
DownloadInfo String A JSON object containing necessary metadata to programmatically retrieve the file attachment from the system.
PostProcessingAction String The name of the action that can be performed on the attachment after it is uploaded, such as validation, conversion, or other processing tasks.
CategoryName String The category that the attachment belongs to, which helps in organizing and sorting attachments in the system.
UploadedText String The textual content of the attachment, if the file contains text-based data, enabling easy searching and retrieval of text data.
FileLocation String The file path or location where the file is stored on the system before being uploaded, used during the file transfer process.

Result Set Columns

Name Type Description
AttachedDocumentId Long The unique identifier of the attached document after the attachment process completes, used for future reference or modifications.
LastUpdateDate Datetime The date and time when the attachment record was last updated, helping to track changes over time.
LastUpdatedBy String The user who last updated the attachment record, providing accountability for modifications.
FileName String The name of the attachment file as it is stored in the system, which may differ from the original filename.
DatatypeCode String The data type code assigned to the attachment, recorded in the system to indicate the file format.
DmFolderPath String The folder path of the attachment in the document management system, where it is stored and can be accessed.
DmDocumentId String The unique document ID that identifies the attachment in the document management system, ensuring traceability.
DmVersionNumber String The version number of the attachment document in the system, helping to track updates and revisions.
Url String The URL where the attachment can be accessed by users or systems, used for retrieval purposes.
Uri String The URI representing the location of the attachment resource, providing a standardized address for accessing the file.
FileUrl String The URL to download or access the attachment file directly from the system.
UploadedText String The text content of the uploaded attachment, if applicable, useful for text-based files like documents or reports.
UploadedFileContentType String The content type of the uploaded file, used to identify the file format.
UploadedFileLength Long The length or size of the uploaded file in bytes, which is important for file management and storage calculations.
UploadedFileName String The actual name of the file that was uploaded, which may be different from the original name depending on system rules.
ContentRepositoryFileShared Bool Indicates whether the attachment is shared in the content repository, helping to control access to sensitive documents.
Title String The title given to the attachment when it was uploaded, useful for organizing and identifying files.
Description String The description of the attachment as stored in the system, providing context or additional details for users.
ErrorStatusCode String The error code, if any, associated with the attachment processing, indicating the type of issue encountered.
ErrorStatusMessage String The error message explaining any issues encountered during the processing of the attachment, helping troubleshoot problems.
CreatedBy String The user who created the attachment record in the system, providing a traceable history for the file.
CreationDate Datetime The date and time when the attachment record was created, important for tracking when the file was initially uploaded.
FileContents String The byte string representing the contents of the attachment, which can be retrieved and processed as needed.
ExpirationDate Datetime The expiration date of the attachment, if applicable, used for managing file lifecycle and access rights.
LastUpdatedByUserName String The username of the individual who last updated the attachment record, used for audit and tracking purposes.
CreatedByUserName String The username of the individual who created the attachment record, providing traceability of file management actions.
AsyncTrackerId String The tracking identifier used to monitor the status of the asynchronous file upload process, ensuring smooth file handling.
FileWebImage String The Base64-encoded image of the file, displayed in .png format if the file is an image that can be converted, useful for previews.
DownloadInfo String A JSON object containing all the information needed to retrieve the file attachment programmatically from the system.
PostProcessingAction String The action that can be performed after the attachment is uploaded, such as verification, approval, or further processing steps.
CategoryName String The category of the attachment as stored in the system, aiding in the organization and classification of attachments.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175