Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the add-in 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 Excel Add-In for Oracle Fusion Cloud SCM Stored Procedures


Name	Description
CreateSchema	Generates schema definitions for Oracle Fusion Cloud SCM tables, streamlining data organization.
DownloadFile	Downloads the file from the FileContent field of an attachments resource.
DownloadImage	Downloads the image from the FileWebImage field of an attachments resource.
FetchTableSubtypes	Given a table's name, fetch its polymorphic subtypes if they exist. The value for the 'QualifiedSubtype' output parameter can then be used in the 'IncludePolymorphicSubtypes' connection property.
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 the data from the specified data file by adding it to an item batch.
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.