Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the connector 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 Tableau Connector for Oracle Fusion Cloud SCM Stored Procedures


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.