Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Oracle Fusion Cloud Financials.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Oracle Fusion Cloud Financials, along with an indication of whether the procedure succeeded or failed.

CData Power BI Connector for Oracle Fusion Cloud Financials Stored Procedures


Name	Description
CreateSchema	Generates a schema definition of a table in Oracle Fusion Cloud Procurement, supporting consistent data structures.
DeleteDraftPurchaseOrdersLinesAttachment	Removes an attachment linked to a draft purchase order line, ensuring updated document references in procurement records.
DeletePurchaseRequisitionsAttachment	Deletes a file attached to a purchase requisition, maintaining relevance and storage efficiency for procurement documentation.
DeleteSuppliersAttachment	Removes an attachment from a supplier record, keeping supplier documents current and organized.
UpdateDraftPurchaseOrdersLinesAttachment	Modifies an existing attachment for a draft purchase order line, ensuring revised or additional documentation is kept current.
UploadPurchaseRequisitionsAttachment	Updates an attachment on a purchase requisition, reflecting new or corrected data in the procurement flow.
UpdateSuppliersAttachment	Modifies an existing document attached to a supplier record, maintaining up-to-date reference files.
UploadDraftPurchaseOrdersLinesAttachment	Allows users to add or update an attachment to a specific draft PO line, enhancing clarity with supplementary documents.
UploadPurchaseRequisitionsAttachment	Enables uploading or changing attachments for purchase requisitions, ensuring the most current reference documents are on file.
UploadSuppliersAttachment	Uploads new attachments for supplier records, capturing vital documents like certifications or financial statements.