Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components 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.