My Oracle Support Banner

Troubleshooting AutoAccounting in AutoInvoice (Doc ID 1080995.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.
Executable:RAXMTR - AutoInvoice Master Program
Executable:RAXTRX - AutoInvoice Import Program
Form:RAXSUAGL.FMB - Define Automatic Accounting


Purpose

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

This note was created to facilitate troubleshooting issues regarding AutoAccounting in AutoInvoice.

AutoAccounting is a powerful, flexible, and time saving feature that automatically defaults your general ledger Accounting Flexfields during data entry. You can set up AutoAccounting to create Accounting Flexfields that meet your business needs.

In Receivables, AutoAccounting is enabled for the following Accounts:

These are discussed in detail in Note 1069052.1, Setting Up AutoAccounting Rules In Receivables.

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. Troubleshooting AutoAccounting related errors encountered during Import
      a. Error: Not all AutoAccounting types are defined
      b. Error: Please complete the offset account assignments
         Error: Please complete your tax accounting flexfield
         Error: Please correct the receivable account assignment
         Error: Please correct the revenue account assignment
         Error: Please correct the freight account assignment
           1) Review Segment Sources
               a) Segments Source = Salesreps
               b) Segment Source =  Standard Lines
               c) Segment Source = Taxes
               d) Segment Source = Transaction Types
               e) Segment Source = Sites
           2) Validate the Shipping Inventory Organization
           3) You are providing data in RA_INTERFACE_DISTRIBUTIONS_ALL
           4) Check the profile option: AR: Use Invoice Accounting for Credit Memos
           5) Check if the GL account exists and is active
           6) Verify Accounting Flexfield setting for Enabled and Allow Dynamic Inserts
           7) Verify whether the GL account does not violate any cross-validation rules of the segments.
 2. Troubleshooting Unexpected Behavior re. AutoAccounting
      a. AutoAccounting for invoices from OM is failing if source = Standard Line (Inventory Item)
      b. Default Value Not Working As Expected
      c. AutoAccounting overrides distributions from RA_INTERFACE_DISTRIBUTIONS_ALL
      d. Impact of System Parameter: Item Validation Organization (previously Profile Option: OE: Item Validation Organization)
      e. Impact of RA_INTERFACE_LINES.OVERRIDE_AUTO_ACCOUNTING_FLAG
      f. Impact of Cross Validation Rules
      g. Unexpected GL accounts derived for Revenue / Receivables when AutoAccounting is based on Salesreps
      h. Wrong Revenue GL distributions when AutoAccounting is based on Salesreps
 3. Troubleshooting issues in Imported Transactions in the Transaction Workbench
      a. Warning: Rerun AutoAccounting when maintaining AutoInvoice sourced transactions
 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.