ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Oracle Fusion Cloud SCM の単純なSELECT 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにOracle Fusion Cloud SCM から関連するレスポンスデータを返します。

CData JDBC Driver for Oracle Fusion Cloud SCM ストアドプロシージャ


Name	Description
BackorderShipmentLine	Raises a business event to send notifications using a business process management task flow.
CancelScheduledProcess	Cancels the Locate Recalled Parts scheduled process according to the request identifier.
FindDuplicateRecallNotices	Cancels the Locate Recalled Parts scheduled process according to the request identifier.
GenerateShipmentRequest	Selects and sends shipment lines to external applications such as a warehouse management system and also indicates the lines as interfaced.
RaiseBusinessEvent	Raises a business event to send notifications using a business process management task flow.
SubmitScheduledProcess	Submits the Locate Recalled Parts scheduled process according to the header identifier, start date, and end date.
UploadInnerPackingUnitsPackedShipmentLinesAttachment	Upload a new file or update content to an existing file.
UploadOuterPackingUnitsPackedShipmentLinesAttachment	Upload a new file or update content to an existing file.
UploadRecallNoticesAttachment	Upload a new file or update content to an existing file.
UploadShipmentLineTransactionRequestsAttachment	Upload a new file or update content to an existing file.
UploadShipmentTransactionRequestInnerPackingUnits	Upload a new file or update content to an existing file.
UploadShipmentTransactionRequestOuterPackingUnits	Upload a new file or update content to an existing file.
UploadShipmentTransactionRequestsAttachment	Upload a new file or update content to an existing file.
UploadUnpackedShipmentLinesAttachment	Upload a new file or update content to an existing file.