UpdateDraftPurchaseOrdersLinesAttachment
Modifies an existing attachment for a draft purchase order line, ensuring revised or additional documentation is kept current.
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.
For example:
exec UpdateDraftPurchaseOrdersLinesAttachment DraftPurchaseOrdersUniqID=415, POLineId=45, AttachedDocumentId='4544554,1554554' , Description='adasd asd asd asd asd asdsss sdwdasd adff.'
Input
| Name | Type | Description |
| DraftPurchaseOrdersUniqID | String | The unique identifier for the Draft Purchase Order. This ID is used to reference a specific draft order in the system. |
| POLineId | String | The unique identifier for the Draft Purchase Order Line. This helps identify the specific line item within the draft order. |
| AttachedDocumentId | Long | A unique identifier for the attached document. This ID is provided to link the document to the purchase order line. |
| FileName | String | The name of the attachment file. This should match the file being uploaded for the purchase order line. |
| DatatypeCode | String | An abbreviation that identifies the data type of the attached document. This may be defined in a lookup type that specifies acceptable data types. |
| DmFolderPath | String | The folder path where the attachment is stored in the document management system. This value helps locate the document in the system. |
| DmDocumentId | String | A unique identifier for the attachment within the document management system. This ensures that each document is referenced distinctly. |
| DmVersionNumber | String | The version number of the attachment. This helps track changes or revisions of the document over time. |
| Url | String | The URL where the attachment can be accessed. This is useful for external access to the document. |
| Uri | String | The URI (Uniform Resource Identifier) of the attachment, providing a reference to its location in the system. |
| FileUrl | String | The full URL of the attachment. This is used to retrieve the file from the system. |
| ContentRepositoryFileShared | Bool | 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 | The title of the attachment, often used for identification and reference purposes. |
| Description | String | A description of the attachment, explaining its content or purpose in relation to the purchase order line. |
| ErrorStatusCode | String | The error code associated with the attachment, if any. This helps identify any issues encountered during the document upload or processing. |
| ErrorStatusMessage | String | A message describing the error, if applicable, that occurred while processing the attachment. |
| FileContents | String | The actual contents of the attachment, typically represented as a byte string. This can be used for storing small documents directly in the database. |
| ExpirationDate | Datetime | The expiration date of the attachment, indicating when the content will no longer be valid or accessible. |
| AsyncTrackerId | String | An identifier used for tracking the asynchronous processing of the uploaded files, which can be useful for troubleshooting or monitoring. |
| DownloadInfo | String | A JSON object that contains information necessary to programmatically retrieve the file attachment, such as the file location or download parameters. |
| PostProcessingAction | String | The action that can be performed after the attachment is uploaded, such as 'Validate,' 'Approve,' or 'Store.' This defines how the document is handled post-upload. |
| CategoryName | String | The category of the attachment, used to classify the document (for example, 'Invoice,' 'Contract,' 'Specification'). This helps categorize documents for easier retrieval. |
| FileLocation | String | The location where the file to be uploaded is stored before it is uploaded to the system. This can refer to a local or network path. |
Result Set Columns
| Name | Type | Description |
| AttachedDocumentId | Long | The unique identifier of the attached document after it has been processed. This allows the system to reference the document in subsequent operations. |
| LastUpdateDate | Datetime | The timestamp of the last update made to the attachment record. This helps track when the attachment was most recently modified. |
| LastUpdatedBy | String | The user or system that made the last update to the attachment record. |
| FileName | String | The file name of the attachment, which is stored in the system after the document is uploaded. |
| DatatypeCode | String | The abbreviation for the data type of the attachment, confirming the format of the file (for example, 'PDF' or 'image'). This is used for validation and processing. |
| DmFolderPath | String | The folder path where the attachment is stored in the document management system after upload. This helps locate the file in the system. |
| DmDocumentId | String | The unique identifier for the attachment in the document management system. This is used to reference the document in subsequent operations. |
| DmVersionNumber | String | The version number of the document after upload. This helps track revisions of the document. |
| Url | String | The URL where the attachment can be accessed or downloaded. This link allows users or systems to retrieve the file. |
| Uri | String | The URI that uniquely identifies the attachment's location in the system. It is used for internal reference and access. |
| FileUrl | String | The full URL of the attachment, which can be used for direct access or linking the file externally. |
| UploadedText | String | The text content of the uploaded attachment, if the file is of a text-based type (for example, text file or PDF). |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. |
| UploadedFileLength | Long | The size of the uploaded file in bytes. This can be used to verify the file size and ensure it is within acceptable limits. |
| UploadedFileName | String | The name of the file after it has been uploaded to the system. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared in the content repository. 'True' means the file is shared, while 'False' means it is not. |
| Title | String | The title of the attachment, which is often used to describe the content or subject of the document. |
| Description | String | A description of the attachment, typically provided during the upload process to help explain the document's purpose. |
| ErrorStatusCode | String | The error code associated with the attachment, if any, indicating issues that occurred during processing. |
| ErrorStatusMessage | String | The error message associated with the attachment, if any, providing further details about issues encountered. |
| CreatedBy | String | The user or system that created the attachment record in the system. |
| CreationDate | Datetime | The timestamp of when the attachment record was created, indicating when the document was first uploaded to the system. |
| FileContents | String | The contents of the attachment, typically stored in Base64 encoding or byte string format for smaller documents. |
| ExpirationDate | Datetime | The expiration date of the attachment, indicating when the document will no longer be considered valid or accessible. |
| LastUpdatedByUserName | String | The username of the user who last updated the attachment record. |
| CreatedByUserName | String | The username of the user who originally created the attachment record. |
| AsyncTrackerId | String | An identifier used for tracking the asynchronous processing of the uploaded files, useful for monitoring or troubleshooting. |
| FileWebImage | String | A Base64-encoded image representation of the file displayed in .png format, if the source is an image file that can be converted. |
| DownloadInfo | String | A JSON object containing information that can be used to retrieve the file attachment programmatically. |
| PostProcessingAction | String | The name of the action that can be performed after the attachment has been uploaded, such as 'Validate' or 'Store.' |
| CategoryName | String | The category of the attachment, which helps classify and organize the documents for easier management. |