Skip to main content
Integration with Oracle Fusion Tax
Search
Search Indirect Tax Support Help and Support.

This article applies to:

  • Product: ONESOURCE Determination,ONESOURCE Indirect Tax
  • Subject: Integration

Split large invoices for oracle fusion cloud

ONESOURCE Indirect Tax Determination can split large Accounts Receivable invoices for Oracle Fusion Cloud into smaller processing chunks to improve tax calculation performance and reliability.

Large invoice splitting

Accounts receivable transactions can exceed 90,000 lines. These large invoices may cause processing failures or significant performance delays when using ONESOURCE Indirect Tax Determination (IDT). These problems can occur when the integration submits the entire invoice payload as a single processing job.
Large invoice splitting solves this problem by dividing Accounts Receivable invoices into smaller chunks automatically. IDT processes each chunk independently for tax calculation and then consolidates the results. This functionality improves performance and reduces the risk of timeouts or processing failures. It also helps determine reliable tax calculations for high-volume transactions.
To turn on split invoice processing:
  1. Go to the
    ERP Settings
     screen.
  2. Select
    Tools
    Integration
    Oracle Cloud ERP
    Oracle ERP Settings
     tab.
  3. Turn on
    Enable Splitting for Large AR invoices
    .
For large invoice processing, it's recommended that you set the
BIP Report Format
 to
CSV
. For setup information related to CSV processing, refer to
Product updates version 2.6.0.10
.

Processing details

Large invoice splitting provides the following functionality:
  • Splits invoices with more than 20,000 lines into invoices with up to 5,000 lines each.
  • Retains the original invoice number for each split invoice.
  • Modifies the
    unique_invoice_number
    entry for each split invoice to keep the invoice number unique.
  • Sets the invoice-level
    Attribute200
    to
    LARGE_INVOICE
    .
  • Triggers a reversal for all split invoices if tax calculation fails for 1 split invoice, and sets
    Attribute200
    to
    LARGE_INVOICE_REVERSAL
    .

Related Content