Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components for Oracle Fusion Cloud SCM Stored Procedures
| Name | Description |
| CreateSchema | Generates schema definitions for tables in Oracle Fusion Cloud SCM manufacturing. |
| DownloadFile | Downloads file from the FileContent field of an attachments resource. |
| DownloadImage | Downloads image from the FileWebImage field of an attachments resource. |
| MidpointRescheduleManufacturingWorkOrderOperation | Executes midpoint rescheduling for manufacturing work orders to adjust timelines. |
| MidpointRescheduleProcessWorkOrderOperation | Performs midpoint rescheduling for process work orders to maintain workflow alignment. |
| ResequenceAsNextManufacturingOperation | Updates the sequence of the next manufacturing operation, streamlining workflow execution. |
| ResequenceAsNextProcessOperation | Adjusts the sequence for the next process operation, enhancing operational scheduling. |
| UploadInspectionResultAttachment | Uploads or updates attachments related to inspection results, supporting quality documentation. |