Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT/INSERT/UPDATE/DELETE 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 Python Connector for Oracle Fusion Cloud Financials Stored Procedures
| 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. |