Troubleshooting AutoAccounting in AutoInvoice
(Doc ID 1080995.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle Receivables - Version 11.5.10.0 and laterInformation 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:
- AutoInvoice Clearing
- Bills Receivable
- Factored Bills Receivable
- Freight
- Receivable
- Remitted Bills Receivable
- Revenue
- Tax
- Unbilled Receivable
- Unearned Revenue
- Unpaid Bills Receivable
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 |
| 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 |