ストアドプロシージャ

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

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

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


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.