My Oracle Support Banner

How to Import and Troubleshoot Distributions in AutoInvoice Using RA_INTERFACE_DISTRIBUTIONS_ALL (Doc ID 1228525.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program


Purpose

Oracle Receivables (AR): AutoInvoice Information Center >Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 1228525.1


The purpose of this note is to explain how an invoice distribution can be passed to AutoInvoice and to discuss steps needed to troubleshoot many of the problems that can occur when importing transactions.

This note should be used in conjunction with the following two articles:
Note 1067402.1, AutoInvoice Setup for Release 12: A Case Study Using a Simple Script
Note 1075757.1, Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12

The case study includes an example script that you can use as the basis for creating your data load script.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 1. Options for Generating Invoice Distributions
 2.  Columns and Validation
 3. Sample Script
 4. Troubleshooting
      a. Autoinvoice is using AutoAccouting instead of specified distributions
      b. Error calling arp_rounding.correct_dist_rounding_errors()
      c. Must Supply A Distribution Percentage When Batch Source Indicates
      d. The total distribution percent for a transaction line must be 100 for each account class
      e. You Must Supply A Unique Id For Your (Chart Of Accounts)
 5. Still Have Questions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.