UploadDraftPurchaseOrdersLinesAttachment
Allows users to add or update an attachment to a specific draft PO line, enhancing clarity with supplementary documents.
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 UploadSuppliersAttachment DraftPurchaseOrdersUniqID=415, POLineId=456, Description='adasd', Title='asd15asdasd', FileLocation='D:\\abc.txt'
- You can provide FileName and FileContents(Base64 format) to upload an attachment:
exec UploadSuppliersAttachment FileName='test2.txt', DraftPurchaseOrdersUniqID=415, POLineId=456, Description='adasd', Title='asd15asdasd', FileContents='SGVsbG8gdGhpcyBpcyB0aGUgZmlsZSB'
- You can provide a URL to upload an attachment:
exec UploadSuppliersAttachment FileName='test2.txt', DraftPurchaseOrdersUniqID=415, POLineId=456, Description='adasd', Title='asd15asdasd', URL='http://abc.com/qwerty.txt'
- You can provide a FileURL to upload an attachment:
exec UploadSuppliersAttachment FileName='test2.txt', DraftPurchaseOrdersUniqID=415, POLineId=456, Description='adasd', Title='asd15asdasd', FileURL='http://abc.com/qwerty.txt'
- You can provide a URI to upload an attachment:
exec UploadSuppliersAttachment FileName='test2.txt', DraftPurchaseOrdersUniqID=415, POLineId=456, Description='adasd', Title='asd15asdasd', URI='http://abc.com/qwerty#abc'
- You can provide UploadedText to upload an attachment:
exec UploadSuppliersAttachment FileName='test2.txt', DraftPurchaseOrdersUniqID=415, POLineId=456, Description='adasd', Title='asd15asdasd', UploadedText='asd asd www'
Input
| Name | Type | Description |
| DraftPurchaseOrdersUniqID | String | The unique identifier for the Draft Purchase Order. This ID links the attachment to a specific draft purchase order within the system. |
| POLineId | String | The unique identifier for the Draft Purchase Order Line. This ID associates the attachment with a specific line item in the draft purchase order. |
| FileName | String | The name of the attachment file. This is used for storing and identifying the file within the system. |
| DatatypeCode | String | An abbreviation that identifies the data type of the attached document. Common data types include PDF or DOCX, often defined in a lookup type. |
| DmFolderPath | String | The folder path where the attachment is stored in the document management system. This path helps locate the document within the system. |
| DmDocumentId | String | A unique identifier for the document in the document management system, ensuring each attachment is distinct and can be tracked. |
| DmVersionNumber | String | The version number of the document, used to track revisions or updates to the attachment. |
| Url | String | The URL that points to the location of the attachment. This is used to retrieve the document through external systems or APIs. |
| Uri | String | The URI (Uniform Resource Identifier) that uniquely identifies the attachment in the system. |
| FileUrl | String | The full URL to the attachment, providing direct access to the file. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared within the content repository. 'True' means the file is shared; 'False' means it is not shared. |
| Title | String | The title of the attachment, typically used to describe the content or subject of the document. |
| Description | String | A brief description of the attachment, providing context or further explanation of the file's content. |
| ErrorStatusCode | String | The error code associated with the attachment, if any. This helps identify issues encountered during document processing or upload. |
| ErrorStatusMessage | String | The error message that corresponds to the error status code, offering further details about the encountered problem. |
| FileContents | String | The contents of the attachment, typically represented as a byte string or Base64 encoding, which allows the system to store smaller files directly in the database. |
| ExpirationDate | Datetime | The expiration date of the attachment's contents. After this date, the document may no longer be accessible or valid. |
| AsyncTrackerId | String | An identifier used for tracking the asynchronous processing of the uploaded file, useful for monitoring or troubleshooting. |
| DownloadInfo | String | A JSON object containing the necessary information to programmatically retrieve the file attachment, such as location or download parameters. |
| PostProcessingAction | String | The action that can be performed on the attachment after it is uploaded, such as 'Validate,' 'Store,' or 'Approve.' |
| CategoryName | String | The category of the attachment, such as 'Invoice,' 'Contract,' or 'Specification.' This helps classify the document for easier retrieval. |
| UploadedText | String | The text content of the attachment, if applicable (for example, for text-based documents like PDFs or Word files). |
| FileLocation | String | The location where the file to be uploaded is stored. This can refer to a local or network path. |
Result Set Columns
| Name | Type | Description |
| AttachedDocumentId | Long | The unique identifier for the attached document once it has been processed by the system. |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated in the system. |
| LastUpdatedBy | String | The user or system that last updated the attachment record, providing traceability of changes. |
| FileName | String | The name of the file associated with the attachment, stored after it has been processed by the system. |
| DatatypeCode | String | The abbreviation identifying the data type of the attachment (for example, 'PDF' or 'image'). |
| DmFolderPath | String | The folder path within the document management system where the attachment is stored. |
| DmDocumentId | String | The unique identifier of the document in the document management system. This ID allows referencing the document in future operations. |
| DmVersionNumber | String | The version number of the attachment, used to track revisions and updates. |
| Url | String | The URL pointing to the attachment, used to access the file through external systems or web services. |
| Uri | String | The URI that uniquely identifies the attachment's location in the system. |
| FileUrl | String | The full URL that provides direct access to the attachment, usable for external linking. |
| UploadedText | String | The text content of the uploaded attachment, useful for text-based documents. |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. |
| UploadedFileLength | Long | The size of the uploaded file in bytes, useful for verifying the file's size and ensuring it meets system limits. |
| UploadedFileName | String | The name of the uploaded file, stored after the document has been processed. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared within the content repository. 'True' means it is shared; 'False' means it is not shared. |
| Title | String | The title of the uploaded attachment, typically used to identify or describe the document. |
| Description | String | A description of the uploaded attachment, providing more context or detail about the document. |
| ErrorStatusCode | String | The error code, if any, associated with the attachment, useful for identifying issues with document processing. |
| ErrorStatusMessage | String | The error message that describes any issues encountered while processing the attachment. |
| CreatedBy | String | The user who created the attachment record, providing traceability of who initiated the upload. |
| CreationDate | Datetime | The date and time when the attachment record was created in the system. |
| FileContents | String | The contents of the attachment, typically stored as byte strings or Base64-encoded for smaller documents. |
| ExpirationDate | Datetime | The expiration date of the attachment, indicating when the document will no longer be 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 the uploaded file. |
| FileWebImage | String | A Base64-encoded image of the file displayed in PNG format, if the source is an image that can be converted. |
| DownloadInfo | String | A JSON object that provides information used to programmatically retrieve the file attachment. |
| PostProcessingAction | String | The name of the action that can be performed on the attachment after upload, such as 'Validate' or 'Store.' |
| CategoryName | String | The category of the attachment, such as 'Invoice,' 'Contract,' or 'Specification.' |