ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Oracle Fusion Cloud Financials の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにOracle Fusion Cloud Financials から関連するレスポンスデータを返します。
CData Excel Add-In 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. |
CreateERPIntegrationsJob | Create an inbound or outbound set of data. |
CreateSchema | Creates a schema definition of a table in Oracle Fusion Cloud Financials. |
DeleteInvoicesAttachment | Delete attachment of an invoice. |
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. |
UploadInvoicesAttachment | The attachments resource for a payable invoice is used to manage attachments that the user has attached to the invoice header. |
UploadReceivablesCreditMemosAttachment | The attachments resource is used to view, create, and update attachments. |
UploadReceivablesInvoicesAttachment | The attachments resource is used to view, create, and update attachments. |
UploadReceivablesInvoicesNote | Uploads the receivalbles invoice note. |
UploadStandardReceiptsAttachment | The attachments resource is used to view, create, and update attachments. |
UploadSuppliersAttachment | Uploads the supplier attachment. |
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. |