ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Oracle Fusion Cloud Financials の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにOracle Fusion Cloud Financials から関連するレスポンスデータを返します。

CData Python Connector for Oracle Fusion Cloud Financials ストアドプロシージャ


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.