Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the adapter beyond simple SELECT/INSERT/UPDATE/DELETE operations with .
Stored procedures accept a list of parameters, perform their intended function, and then return, if applicable, any relevant response data from , along with an indication of whether the procedure succeeded or failed.
Adapter Stored Procedures
| Name | Description |
| ApplyCashAdvance | Applies the cash advance to the expense report. |
| ApplyPrepaymentForAnInvoice | Applies prepayments to an invoice. |
| CalculateTaxForInvoice | Calculate taxes for the invoice based on the invoice details and the relevant tax configuration. |
| CancelInvoice | Cancels an invoice. When you cancel an invoice, all invoice amounts are set to zero, and the invoice can't be edited or submitted for processing. |
| CancelInvoiceLine | Cancels an invoice line. When you cancel an item line, the line amount is set to zero, and the invoice line can't be edited. |
| CreateSchema | Creates a schema definition of a table in Oracle Financials Cloud. |
| GenerateDistributionsForInvoice | Generate distributions for the invoice based on the line information such as distribution combinations, distribution sets, and freight or miscellaneous charge allocations. |
| ProcessWorkflowAction | Processes a workflow action on the expense report. |
| RemoveCashAdvance | Removes the cash advance on the expense report. |
| ReverseDistributionsForInvoice | Reverses distributions for an Invoice. |
| SubmitExpenseReport | Submits the expense report after validation. |
| UnapplyPrepaymentForAnInvoice | Unapplies a prepayment from an invoice. |
| ValidateInvoice | Cancels an invoice. When you cancel an invoice, all invoice amounts are set to zero, and the invoice can't be edited or submitted for processing. |