ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Oracle Fusion Cloud SCM の単純なSELECT 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにOracle Fusion Cloud SCM から関連するレスポンスデータを返します。
CData SSIS Components for Oracle Fusion Cloud SCM ストアドプロシージャ
| 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. |