ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Oracle Fusion Cloud SCM の単純なSELECT 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにOracle Fusion Cloud SCM から関連するレスポンスデータを返します。
CData JDBC Driver for Oracle Fusion Cloud SCM ストアドプロシージャ
Name | Description |
BackorderShipmentLine | Triggers a business event to notify stakeholders via a business process management task flow when a shipment line is backordered. |
CancelScheduledProcess | Terminates a scheduled process for locating recalled parts based on a specific request identifier. |
CreateSchema | Creates a schema definition for a table in Oracle Fusion Cloud SCM, ensuring alignment with system requirements. |
FindDuplicateRecallNotices | Identifies and resolves duplicate notices for recalled parts by canceling redundant scheduled processes. |
GenerateShipmentRequest | Facilitates the transmission of shipment lines to external systems like warehouse management and marks them as interfaced. |
RaiseBusinessEvent | Triggers a business event to send notifications via a business process management task flow. |
SubmitScheduledProcess | Executes the Locate Recalled Parts scheduled process, filtering results by header identifier, start date, and end date. |
UploadInnerPackingUnitsPackedShipmentLinesAttachment | Handles uploading or updating files for inner packing unit data in packed shipments. |
UploadOuterPackingUnitsPackedShipmentLinesAttachment | Handles uploading or updating files for outer packing unit data in packed shipments. |
UploadRecallNoticesAttachment | Facilitates uploading or updating recall notice files for inventory management. |
UploadShipmentLineTransactionRequestsAttachment | Enables uploading or modifying files for shipment line transaction requests. |
UploadShipmentTransactionRequestInnerPackingUnits | Manages file uploads or updates for transaction requests concerning inner packing units. |
UploadShipmentTransactionRequestOuterPackingUnits | Manages file uploads or updates for transaction requests concerning outer packing units. |
UploadShipmentTransactionRequestsAttachment | Supports uploading or updating files related to shipment transaction requests. |
UploadUnpackedShipmentLinesAttachment | Enables file uploads or updates for unpacked shipment line data. |