Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9111

UploadPurchaseRequisitionsAttachment

The attachments resource is used to view, create, and update attachments.

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 UploadPurchaseRequisitionsAttachment PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', FileLocation='D:\\abc.txt'
  • You can provide FileName and FileContents(Base64 format) to upload an attachment 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', FileContents='SGVsbG8gdGhpcyBpcyB0aGUgZmlsZSB'
  • You can provide FileName and URL to upload an attachment 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', URL='http://abc.com/qwerty.txt'
  • You can provide FileName and FileURL to upload an attachment 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', FileURL='http://abc.com/qwerty.txt'
  • You can provide FileName and URI to upload an attachment 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', URI='http://abc.com/qwerty#abc'

Input

Name Type Description
PurchaseRequisitionsUniqID String The unique identifier of the Purchase Requisition.
AttachmentsUniqID String The unique identifier of the Purchase Requisition attachment.
AttachedDocumentId Long The unique identifier of the attached document.
FileName String The file name of the attachment.
DatatypeCode String Abbreviation that identifies the data type.
DmFolderPath String The folder path of the attachment.
DmDocumentId String Value that uniquely identifies the attachment.
DmVersionNumber String Version number of the attachment.
Url String The URL of the attachment.
Uri String The URI of the attachment.
FileUrl String The URL of the attachment.
ContentRepositoryFileShared Bool Indicates whether the attachment is shared.
Title String The title of the attachment.
Description String The description of the attachment.
ErrorStatusCode String The error code, if any, for the attachment.
ErrorStatusMessage String The error message, if any, for the attachment.
FileContents String The contents of the attachment (Byte String).
ExpirationDate Datetime The expiration date of the contents in the attachment.
AsyncTrackerId String An identifier used for tracking the uploaded files
DownloadInfo String JSON object represented as a string containing information used to programmatically retrieve a file attachment.
PostProcessingAction String The name of the action that can be performed after an attachment is uploaded.
CategoryName String The category of the attachment.
FileLocation String The location of the file that has to be uploaded.

Result Set Columns

Name Type Description
AttachedDocumentId Long The unique identifier of the attached document.
LastUpdateDate Datetime The date when the record was last updated.
LastUpdatedBy String The user who last updated the record.
FileName String The file name of the attachment.
DatatypeCode String Abbreviation that identifies the data type.
DmFolderPath String The folder path of the attachment.
DmDocumentId String Value that uniquely identifies the attachment.
DmVersionNumber String Version number of the attachment.
Url String The URL of the attachment.
Uri String The URI of the attachment.
FileUrl String The URL of the attachment.
UploadedText String The text of the attachment.
UploadedFileContentType String The content type of the attachment.
UploadedFileLength Long The length of the attachment file.
UploadedFileName String The name of the attachment file.
ContentRepositoryFileShared Bool Indicates whether the attachment is shared.
Title String The title of the attachment.
Description String The description of the attachment.
ErrorStatusCode String The error code, if any, for the attachment.
ErrorStatusMessage String The error message, if any, for the attachment.
CreatedBy String The user who created the record.
CreationDate Datetime The date when the record was created.
FileContents String The contents of the attachment.
ExpirationDate Datetime The expiration date of the contents in the attachment.
LastUpdatedByUserName String The user who last updated the record.
CreatedByUserName String The user who created the record.
AsyncTrackerId String An identifier used for tracking the uploaded files
FileWebImage String The base64 encoded image of the file displayed in .png format if the source is a convertible image.
DownloadInfo String JSON object represented as a string containing information used to programmatically retrieve a file attachment.
PostProcessingAction String The name of the action that can be performed after an attachment is uploaded.
CategoryName String The category of the attachment.

The attachments resource is used to view, create, and update attachments.

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 UploadPurchaseRequisitionsAttachment PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', FileLocation='D:\\abc.txt'
  • You can provide FileName and FileContents(Base64 format) to upload an attachment 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', FileContents='SGVsbG8gdGhpcyBpcyB0aGUgZmlsZSB'
  • You can provide FileName and URL to upload an attachment 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', URL='http://abc.com/qwerty.txt'
  • You can provide FileName and FileURL to upload an attachment 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', FileURL='http://abc.com/qwerty.txt'
  • You can provide FileName and URI to upload an attachment 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', URI='http://abc.com/qwerty#abc'

Input

Name Type Description
PurchaseRequisitionsUniqID String The unique identifier of the Purchase Requisition.
AttachedDocumentId Long The unique identifier of the attached document.
FileName String The file name of the attachment.
DatatypeCode String Abbreviation that identifies the data type.
DmFolderPath String The folder path of the attachment.
DmDocumentId String Value that uniquely identifies the attachment.
DmVersionNumber String Version number of the attachment.
Url String The URL of the attachment.
Uri String The URI of the attachment.
FileUrl String The URL of the attachment.
ContentRepositoryFileShared Bool Indicates whether the attachment is shared.
Title String The title of the attachment.
Description String The description of the attachment.
ErrorStatusCode String The error code, if any, for the attachment.
ErrorStatusMessage String The error message, if any, for the attachment.
FileContents String The contents of the attachment (Byte String).
ExpirationDate Datetime The expiration date of the contents in the attachment.
AsyncTrackerId String An identifier used for tracking the uploaded files
DownloadInfo String JSON object represented as a string containing information used to programmatically retrieve a file attachment.
PostProcessingAction String The name of the action that can be performed after an attachment is uploaded.
CategoryName String The category of the attachment.
FileLocation String The location of the file that has to be uploaded.

Result Set Columns

Name Type Description
AttachedDocumentId Long The unique identifier of the attached document.
LastUpdateDate Datetime The date when the record was last updated.
LastUpdatedBy String The user who last updated the record.
FileName String The file name of the attachment.
DatatypeCode String Abbreviation that identifies the data type.
DmFolderPath String The folder path of the attachment.
DmDocumentId String Value that uniquely identifies the attachment.
DmVersionNumber String Version number of the attachment.
Url String The URL of the attachment.
Uri String The URI of the attachment.
FileUrl String The URL of the attachment.
UploadedText String The text of the attachment.
UploadedFileContentType String The content type of the attachment.
UploadedFileLength Long The length of the attachment file.
UploadedFileName String The name of the attachment file.
ContentRepositoryFileShared Bool Indicates whether the attachment is shared.
Title String The title of the attachment.
Description String The description of the attachment.
ErrorStatusCode String The error code, if any, for the attachment.
ErrorStatusMessage String The error message, if any, for the attachment.
CreatedBy String The user who created the record.
CreationDate Datetime The date when the record was created.
FileContents String The contents of the attachment.
ExpirationDate Datetime The expiration date of the contents in the attachment.
LastUpdatedByUserName String The user who last updated the record.
CreatedByUserName String The user who created the record.
AsyncTrackerId String An identifier used for tracking the uploaded files
FileWebImage String The base64 encoded image of the file displayed in .png format if the source is a convertible image.
DownloadInfo String JSON object represented as a string containing information used to programmatically retrieve a file attachment.
PostProcessingAction String The name of the action that can be performed after an attachment is uploaded.
CategoryName String The category of the attachment.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111