ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、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.
CreateSchema	Creates a schema definition of a table in Oracle Fusion Cloud SCM.
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.