ストアドプロシージャ

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

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

CData Excel Add-In for Oracle Financials Cloud ストアドプロシージャ


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.