ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Oracle Fusion Cloud SCM の単純なSELECT 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにOracle Fusion Cloud SCM から関連するレスポンスデータを返します。
CData Code Assist MCP for Oracle Fusion Cloud SCM ストアドプロシージャ
| Name | Description |
| AutomaticallySchedule | Executes the scheduling of operations automatically, streamlining order management processes. |
| CancelManualClaim | Cancels a manual claim within the order management system, reverting associated changes. |
| CancelSalesOrder | Cancels specified sales orders, halting their processing and updating system records. |
| CreateSchema | Creates schema definitions for tables in Oracle Fusion Cloud SCM, enabling database management. |
| DownloadFile | Downloads file from the FileContent field of an attachments resource. |
| DownloadImage | Downloads image from the FileWebImage field of an attachments resource. |
| ReviseQuantity | Updates the quantity of a configuration in the system, ensuring accurate order fulfillment. |
| ScheduleSalesOrder | Automates the scheduling of sales orders based on availability and demand. |
| SettleManualClaim | Handles manual claims for resolution, including adjustments and approvals. |