JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

UploadPurchaseRequisitionsAttachment

Updates an attachment on a purchase requisition, reflecting new or corrected data in the procurement flow.

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 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 a 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 a 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 a URI to upload an attachment: 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', URI='http://abc.com/qwerty#abc'
  • You can provide UploadedText to upload an attachment: 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', UploadedText='sdf asdf de'

Input

Name Type Accepts Input Streams Description
PurchaseRequisitionsUniqID String False The unique identifier of the Purchase Requisition. This ID is used to reference a specific requisition in the system.
AttachmentsUniqID String False The unique identifier of the Purchase Requisition attachment. This ID links the attachment to the requisition.
AttachedDocumentId Long False A unique identifier for the attached document, which associates the document with the purchase requisition.
FileName String False The name of the attachment file. This should match the file being uploaded for the purchase requisition.
DatatypeCode String False An abbreviation that identifies the data type of the attached document. It could be a value like 'PDF' or 'DOCX', typically defined in a lookup type.
DmFolderPath String False The folder path where the attachment is stored in the document management system. This value helps locate the document in the system.
DmDocumentId String False A unique identifier for the attachment within the document management system. This ID ensures the attachment is referenced distinctly.
DmVersionNumber String False The version number of the attachment. This helps track revisions of the document over time.
Url String False The URL where the attachment can be accessed. This is used to retrieve the file via HTTP or other protocols.
Uri String False The URI (Uniform Resource Identifier) of the attachment, which provides a reference to its location in the system.
FileUrl String False The full URL of the attachment, which can be used for direct access or linking externally to the file.
ContentRepositoryFileShared Bool False Indicates whether the attachment is shared with other users or systems. 'True' means the file is shared; 'False' means it is not shared.
Title String False The title of the attachment, which often describes the content of the document or its purpose.
Description String False The description of the attachment, providing more details about its content, purpose, or context in relation to the purchase requisition.
ErrorStatusCode String False The error code associated with the attachment, if any, which helps identify issues during document upload or processing.
ErrorStatusMessage String False The error message explaining the issue with the attachment, if any, encountered during the upload or processing.
FileContents String False The actual contents of the attachment, typically represented as a byte string for files stored in the system.
ExpirationDate Datetime False The expiration date of the attachment contents, indicating when the document will no longer be valid or accessible.
AsyncTrackerId String False An identifier used for tracking the asynchronous processing of the uploaded files. It is useful for monitoring or troubleshooting.
DownloadInfo String False A JSON object containing the necessary information to programmatically retrieve the attachment, such as download parameters.
PostProcessingAction String False The name of the action that can be performed after an attachment is uploaded, such as 'Validate' or 'Store.'
CategoryName String False The category of the attachment, such as 'Invoice,' 'Contract,' or 'Purchase Order.' It helps classify the document for easier management and retrieval.
FileLocation String False The location of the file that needs to be uploaded, often provided as a file path or storage reference.
Content String True The content of the file to be uploaded, usually in a Base64-encoded format when transmitted through an API or web service.

Result Set Columns

Name Type Description
AttachedDocumentId Long The unique identifier of the attached document after processing. This allows referencing the document in subsequent operations.
LastUpdateDate Datetime The date and time when the attachment record was last updated in the system.
LastUpdatedBy String The user who last updated the attachment record, providing a trace of who made the last modification.
FileName String The file name of the attachment, stored in the system after the document is uploaded.
DatatypeCode String The abbreviation identifying the data type of the attachment, confirming the file format (for example, 'PDF' or 'image').
DmFolderPath String The folder path where the attachment is stored in the document management system after the file has been uploaded.
DmDocumentId String The unique identifier of the document in the document management system. This ID links the attachment to the system.
DmVersionNumber String The version number of the attachment, indicating the revision or update of the document after upload.
Url String The URL of the attachment, which can be used to access the file directly from the system.
Uri String The URI pointing to the attachment's location in the system. This is used for internal referencing and access.
FileUrl String The full URL of the attachment, providing external access or linking to the document.
UploadedText String The text content of the attachment, if the file is a text-based type (for example, plain text, HTML, or PDF).
UploadedFileContentType String The content type of the uploaded file, indicating its format.
UploadedFileLength Long The length of the uploaded file in bytes, used to verify the size and ensure it meets system limits.
UploadedFileName String The name of the uploaded attachment file. This is typically the same as the original file name unless modified during the upload.
ContentRepositoryFileShared Bool Indicates whether the attachment is shared within the content repository. 'True' means it is shared, 'False' means it is not.
Title String The title of the uploaded attachment, which describes the content or purpose of the document.
Description String A description of the uploaded attachment, typically provided to explain its context or relevance to the purchase requisition.
ErrorStatusCode String The error code related to the attachment, if any, that indicates issues encountered during document processing.
ErrorStatusMessage String The error message associated with the attachment, providing further details about the encountered issue.
CreatedBy String The user who created the attachment record in the system.
CreationDate Datetime The date and time when the attachment record was created.
FileContents String The contents of the attachment, typically in byte string or Base64 format for smaller documents.
ExpirationDate Datetime The expiration date of the attachment, indicating when the document will no longer be valid or accessible.
LastUpdatedByUserName String The username of the user who last updated the attachment record.
CreatedByUserName String The username of the user who created the attachment record.
AsyncTrackerId String An identifier used to track the asynchronous processing of uploaded files, useful for monitoring or troubleshooting.
FileWebImage String A Base64-encoded image representation of the file displayed in PNG format, if the attachment is an image file that can be converted.
DownloadInfo String A JSON object represented as a string, containing information needed to programmatically retrieve the file attachment.
PostProcessingAction String The name of the action that can be performed after the attachment is uploaded, such as 'Validate' or 'Store.'
CategoryName String The category of the attachment, used to classify and organize the documents for easier retrieval.

Enables uploading or changing attachments for purchase requisitions, ensuring the most current reference documents are on file.

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 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 a 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 a 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 a URI to upload an attachment: 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', URI='http://abc.com/qwerty#abc'
  • You can provide UploadedText to upload an attachment: 
    	exec UploadPurchaseRequisitionsAttachment FileName='test2.txt', PurchaseRequisitionsUniqID=415, Description='adasd', Title='asd15asdasd', UploadedText='sdf asdf de'

Input

Name Type Accepts Input Streams Description
PurchaseRequisitionsUniqID String False The unique identifier of the Purchase Requisition. This ID links the attachment to a specific purchase requisition, enabling its association within the system.
FileName String False The name of the attachment file. This is used to store and identify the file in the system once uploaded.
DatatypeCode String False An abbreviation that identifies the data type of the attachment. Common values are 'PDF' or 'DOCX', typically defined in a lookup type.
DmFolderPath String False The folder path in the document management system where the attachment is stored. This path helps locate and manage the document within the system.
DmDocumentId String False A unique identifier for the attachment in the document management system, ensuring the attachment can be tracked and referenced.
DmVersionNumber String False The version number of the attachment. This helps in tracking revisions and updates to the document over time.
Url String False The URL that points to the attachment's location. This URL is used for accessing or retrieving the document.
Uri String False The URI (Uniform Resource Identifier) of the attachment. This is a system reference used to uniquely identify the attachment.
FileUrl String False The full URL of the attachment, providing external access to the file if needed.
ContentRepositoryFileShared Bool False Indicates whether the attachment is shared within the content repository. 'True' means it is shared; 'False' means it is not.
Title String False The title of the attachment, typically used to describe the content of the document or its purpose.
Description String False A description of the attachment, offering additional context or details about the document's content.
ErrorStatusCode String False The error code, if any, associated with the attachment. This helps identify problems encountered during the upload or processing.
ErrorStatusMessage String False The error message that provides more detail about the issue encountered when processing the attachment.
FileContents String False The contents of the attachment, typically stored as a byte string or Base64 encoding to allow it to be transmitted and saved.
ExpirationDate Datetime False The expiration date for the attachment's contents, indicating when the document will no longer be valid or accessible.
AsyncTrackerId String False An identifier used to track the asynchronous processing of uploaded files. This is useful for monitoring the file processing status.
DownloadInfo String False A JSON object represented as a string, containing the necessary information to programmatically retrieve the attachment.
PostProcessingAction String False The name of the action that can be performed after the attachment is uploaded, such as 'Validate,' 'Approve,' or 'Store.'
CategoryName String False The category of the attachment, such as 'Invoice,' 'Contract,' or 'Purchase Order,' used for organizing and classifying attachments.
UploadedText String False The text content of the attachment, if the uploaded file contains text, such as in a document or report.
FileLocation String False The location of the file that needs to be uploaded. This can refer to a local or network-based file path.
Content String True The actual content of the file to be uploaded, typically Base64-encoded when transmitting files through APIs or web services.

Result Set Columns

Name Type Description
AttachedDocumentId Long The unique identifier of the attached document once it has been processed and stored in the document management system.
LastUpdateDate Datetime The date when the attachment record was last updated in the system. This tracks changes made after the attachment's initial upload.
LastUpdatedBy String The user or system who last updated the attachment record. This helps track the changes made by various users.
FileName String The name of the uploaded attachment file, which is stored after the file is processed.
DatatypeCode String The abbreviation identifying the data type of the uploaded file, such as 'PDF' or 'image'.
DmFolderPath String The folder path in the document management system where the attachment is stored, which helps locate the document.
DmDocumentId String The unique identifier of the document in the document management system. This ID links the document to the system.
DmVersionNumber String The version number of the document, indicating the latest revision of the uploaded attachment.
Url String The URL of the attachment, which can be used to access the file externally or within internal systems.
Uri String The URI that uniquely identifies the attachment within the system, used for referencing.
FileUrl String The full URL that points to the attachment, providing external access if required.
UploadedText String The text content of the uploaded file, if applicable. This may include the content extracted from text-based documents.
UploadedFileContentType String The content type of the uploaded file, indicating its format.
UploadedFileLength Long The length of the uploaded file in bytes. This is used to verify the file size against system limits.
UploadedFileName String The name of the file after it is uploaded and processed by the system.
ContentRepositoryFileShared Bool Indicates whether the uploaded file is shared. 'True' means the file is shared across users, while 'False' means it is not.
Title String The title of the uploaded attachment, often describing its purpose or content.
Description String The description of the uploaded attachment, providing further context regarding its content.
ErrorStatusCode String The error code associated with the uploaded attachment, if any, indicating the processing issue.
ErrorStatusMessage String The error message detailing the problem encountered while processing the uploaded attachment.
CreatedBy String The user who created the attachment record in the system. This helps track the origin of the document.
CreationDate Datetime The date and time when the attachment record was created, providing context on when the attachment was first uploaded.
FileContents String The contents of the uploaded file, typically stored as a byte string or Base64-encoded for efficient transmission and storage.
ExpirationDate Datetime The expiration date of the attachment's contents, indicating when the document will no longer be valid.
LastUpdatedByUserName String The username of the user who last updated the attachment record, providing traceability for updates.
CreatedByUserName String The username of the user who originally created the attachment record.
AsyncTrackerId String An identifier used to track the asynchronous processing of uploaded files. It is essential for monitoring large files or time-consuming operations.
FileWebImage String A Base64-encoded image representation of the uploaded file, displayed in PNG format if the source file is an image that can be converted.
DownloadInfo String A JSON object that provides information for programmatically retrieving the uploaded attachment, such as download parameters.
PostProcessingAction String The action that can be taken after the file is uploaded, such as 'Validate' or 'Store.'
CategoryName String The category of the uploaded attachment, used to classify the document for easier management and retrieval.

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