Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT operations with Oracle Fusion Cloud SCM.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Oracle Fusion Cloud SCM, along with an indication of whether the procedure succeeded or failed.
CData JDBC Driver for Oracle Fusion Cloud SCM Stored Procedures
| Name | Description |
| CreateSchema | Generates schema definitions for Oracle Fusion Cloud SCM tables, streamlining data organization. |
| SecureObject | Transitions an object to a private security state, restricting its access. |
| UnreleaseWorkspaceParticipants | Reverts workspace participants to their last released state, undoing changes. |
| UploadItemBatches | Uploads and processes item data files into batches for streamlined processing. |
| UploadItemCatalogAttachment | Uploads or updates attachments related to item catalogs, ensuring accurate file management. |
| UploadItemCategoriesAttachment | Uploads or updates attachments for item categories, providing additional context or documentation. |
| UploadNewItemRequestsAttachment | Uploads or updates files for new item requests, facilitating efficient item creation workflows. |
| UploadProductProposalsAttachments | Uploads or updates attachments for product proposals, enabling detailed proposals with supporting files. |
| UploadQualityActionsAttachments | Uploads or updates files for quality actions, ensuring documentation for quality-related processes. |
| UploadQualityIssuesAttachments | Uploads or updates files for quality issues, providing context for issue resolution. |
| UploadSupplierProductsAttachment | Uploads or updates attachments for supplier products, ensuring accurate supplier-product associations. |
| UploadTradingPartnerItemsAttachments | Handles the upload or update of file content for trading partner item attachments within the Product Lifecycle Management module. |