JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9175

ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175