Tableau Connector for Oracle Fusion Cloud Financials

Build 25.0.9434

UnapplyPrepaymentForAnInvoice

Removes a previously applied prepayment from an invoice, adjusting amounts to reflect the updated payment allocation.

Input

Name Type Description
InvoiceNumber String The unique identifier of the supplier invoice that is being processed. This ID is used to identify the specific invoice in the system for further actions such as applying or unapplying prepayments.
BusinessUnit String The name of the business unit that is associated with the invoice. This field helps in categorizing and routing the invoice to the appropriate department within the organization.
Supplier String The name of the supplier from whom the goods or services are purchased. This helps to identify the party from which the company has received products or services, and it links the invoice to the supplier's records.
PrepaymentInvoiceNumber String The unique identifier of the prepayment invoice that is linked to the supplier invoice. This number helps to connect the prepayment made by the company to the specific supplier invoice it relates to.
PurchaseOrder String The purchase order number that is matched to the prepayment invoice to verify transaction details. This helps confirm that the prepayment is being applied to the correct transaction according to the purchase order.
PrepaymentLineNumber Integer The line number on the prepayment invoice that corresponds to the specific items or services. This ensures that the prepayment is applied to the correct line item on the invoice.
PrepaymentAppliedAmount Decimal The amount of prepayment applied to the standard invoice, reducing the balance owed. This value represents the amount of the supplier invoice that has been paid in advance, and it reduces the total invoice balance.
PrepaymentApplicationAccountingDate Date The accounting date on which the prepayment application is recorded in the system. This date is important for accurate financial reporting and ensuring that the transaction is recorded in the correct accounting period.
PrepaymentUnapplicationAccountingDate Date The accounting date to be used when unapplying a prepayment from the invoice, effectively reversing the transaction. This date is important for ensuring that the reversal of the prepayment is recorded in the correct financial period.

Result Set Columns

Name Type Description
Result String The result returned after the execution of the stored procedure, indicating success or failure. This output helps determine whether the operation was successful or if there were any issues during the processing of the prepayment.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434