Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the cmdlet 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 Cmdlets PowerShell Module for Oracle Fusion Cloud Financials 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 Fusion Cloud Financials. |
| 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. |