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