Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the provider beyond simple SELECT operations with Oracle Fusion Cloud SCM.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Oracle Fusion Cloud SCM, along with an indication of whether the procedure succeeded or failed.
CData ADO.NET Provider for Oracle Fusion Cloud SCM Stored Procedures
| 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. |