ストアドプロシージャ

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

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

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


Name	Description
ApplyCashAdvance	Associates and applies an approved cash advance to an employee expense report, reducing the outstanding balance.
ApplyPrepaymentForAnInvoice	Offsets an invoice balance by allocating available prepayment amounts, updating invoice totals and remaining prepayment balances.
CalculateTaxForInvoice	Computes tax amounts for a given invoice based on the invoice lines, tax configuration, and applicable rules.
CancelInvoice	Sets an existing invoice’s amounts to zero and prevents further edits or submissions, effectively voiding the transaction.
CancelInvoiceLine	Voids a specific invoice line item, resetting its amount to zero while preserving a history record for auditing.
CreateERPIntegrationsJob	Initializes bulk inbound or outbound data transfers, automating import and export tasks for ERP processes.
CreateSchema	Generates a schema definition for a table, supporting metadata documentation and streamlined integrations in Cloud Financials.
DeleteInvoicesAttachment	Removes a previously attached document from an invoice, freeing up storage and ensuring data relevancy.
GenerateDistributionsForInvoice	Creates invoice distributions based on line-level information, accounting rules, and any added freight or miscellaneous charges.
ProcessWorkflowAction	Executes a specific workflow action (for example, approval, rejection) on an expense report, tracking the action’s impact on status.
RemoveCashAdvance	Eliminates a previously applied cash advance from an expense report, adjusting outstanding balances accordingly.
ReverseDistributionsForInvoice	Reverses existing invoice distributions, typically used for error correction, reclassification, or voiding transactions.
SubmitExpenseReport	Finalizes and sends the expense report through the appropriate workflow approvals, locking modifications to prevent changes.
UnapplyPrepaymentForAnInvoice	Removes a previously applied prepayment from an invoice, adjusting amounts to reflect the updated payment allocation.
UploadInvoicesAttachment	Uploads or updates attachments at the invoice header level in Payables, improving documentation for invoice processing.
UploadReceivablesCreditMemosAttachment	Adds or updates supporting documents on Receivables credit memos, enhancing clarity for financial and audit reviews.
UploadReceivablesInvoicesAttachment	Attaches documents to a Receivables invoice, helping maintain comprehensive records of billed items or services.
UploadReceivablesInvoicesNote	Inserts or updates an invoice note in Receivables, capturing contextual information or instructions for the bill.
UploadStandardReceiptsAttachment	Attaches or modifies supporting documentation for standard receipts, aiding payment reconciliation and recordkeeping.
ValidateInvoice	Checks and finalizes an invoice by setting its amounts to zero if canceled, preventing further modifications or submissions.