7. Sales Credit Errors

#	Error String or Presentation	Most Common Cause(s)	Comprehensive List of Known Causes
7.1	Invalid salesrep id (SALESREP_ID) ((Nil))	Invalid Value Interfaced. Transaction Source Setup.	Note 1112672.1, AutoInvoice Error: Invalid Salesrep id (SALESREP_ID)
7.2	Invalid sales credit type name (SALES_CREDIT_TYPE_NAME) ((Nil))	Invalid Value Interfaced. Transaction Source Setup.	Note 1112705.1, AutoInvoice Error: Invalid Salesrep Number (SALESREP_NUMBER)
7.3	Invalid sales credit type id (SALES_CREDIT_TYPE_ID) ((Nil))	Invalid Value Interfaced. Transaction Source Setup.	Note 1112672.1, AutoInvoice Error: Invalid Salesrep id (SALESREP_ID)
7.4	Invalid primary salesrep number (PRIMARY_SALESREP_NUMBER)	Transaction Source Setup	Note 1112705.1, AutoInvoice Error: Invalid Salesrep Number (SALESREP_NUMBER)
7.5	You must supply a value for the sales credit amount ((Nil))	Transaction Source Setup	Note 1116984.1, AutoInvoice Error: You Must Supply a Value For The Sales Credit Amount
7.6	You must supply sales credit assignments for this transaction because the system option Require Salesreps is set to Yes	System Options Setup - Require Sales Person. Sales Credits are not provided in the interface.	Note 1117036.1, AutoInvoice Error: You Must Supply Sales Credit Assignments For This Transaction Because The System Option Require Salesreps Is Set To Yes
7.7	Please Enter Quota Sales Credit Percentages That Equal 100 Percent	Sales Credit Percentage	Note 1117668.1, AutoInvoice Error: Please Enter Quota Sales Credit Percentages That Equal 100 Percent
7.8	Primary salesperson is invalid with current transaction date	Salesrep is required but was not provided.	Note 244957.1 AutoInvoice Error: Primary salesperson is invalid with current transaction date

The following note can be referenced for Sales Credit Related Issues:

• Note 1118944.1, Troubleshooting AutoInvoice - Sales Credits

8. Credit Memo Errors

#	Error String or Presentation	Most Common Cause(s)	Comprehensive List of Known Causes
8.1	Cannot apply the credit memo because the invoice is locked by another user. Please try again later.	Data Related - Referenced Invoice.	Note 1087146.1, Cannot Apply The Credit Memo Because The Invoice Is Locked By Another User. Please Try Again Later.
8.2	You can not apply more than the original line amount OR The total amount of your credit memo cannot exceed the balance of the debit item it is crediting	Invoice to be credited has existing applications (receipt, credit memo, etc).	Note 1122945.1, AutoInvoice Error: You Can Not Apply More Than The Original Line Amount
8.3	You cannot supply any account assignment for your credit memo transaction when the system option 'Use Invoice Accounting for Credit Memos' is Yes	When AR: Use Invoice Accounting for Credit Memo is Yes, you should not pass distribution details.	Note 1122964.1, AutoInvoice Error: You Cannot Supply Any Account Assignment For Your Credit Memo Transaction When The System Option 'Use Invoice Accounting For Credit Memos' is Yes
8.4	The Open Receivable flag of your credit memo must match the flag of the transaction you are crediting	Credit Memo/Invoice Transaction Type Open Receivables Flag	Note 1122984.1, AutoInvoice Error: The Open Receivable Flag Of Your Credit Memo Must Match The Flag Of The Transaction You Are Crediting
8.5	A credit memo is attempting to overapply a specific transaction line, but overapplication is not allowed.	Credit Memo/Invoice Transaction Type Allow Overapplication Flag setting	Note 1110573.1, Troubleshooting Credit Memos in Receivables
8.6	You cannot apply a transaction with a negative amount to another transaction with a negative balance and vice versa	Credit Memo/Invoice Transaction Type Allow Overapplication Flag setting	Note 1174659.1 AutoInvoice Error: You cannot apply a transaction with a negative amount to another transaction with a negative balance and vice versa.
8.7	Please enter a unit selling price for this credit line that is less than the unit selling price for its target invoice line	Data Related, UNIT_SELLING_PRICE	Note 1145259.1, AutoInvoice Error: Please enter a unit selling price for this credit line that is less than the unit selling price for its target invoice line
8.8	You cannot over apply this transaction.	Setup Data Related	Note 1147943.1, AutoInvoice Error: You cannot over apply this transaction.
8.9	The valid values for credit method for accounting rule are PRORATE LIFO and UNIT	Data Related	Note 1149363.1, AutoInvoice Error: The valid values for credit method for accounting rule are PRORATE, LIFO and UNIT.
8.10	Invoice Cannot Be Credited Due To Its Electronic Invoice Status	Bug	Note 884528.1 AutoInvoice Error: Invoice Cannot Be Credited Due To Its Electronic Invoice Status

The Following Notes can be used for Credit Memo Related Issues:

• Note 1110573.1, Troubleshooting Credit Memos in Receivables.
• Note 215373.1, How to Setup and Create Credit Memos in Receivables

9. Grouping Rule Errors

#	Error String or Presentation	Most Common Cause(s)	Comprehensive List of Known Causes
9.1	You can supply at most one Receivables account for a transaction (an invoice, a debit memo or a credit memo).	Data Related - Transaction Flexfields Setup Related - Grouping Rules	Note 1146563.1, AutoInvoice Error: You can supply at most one Receivables account for a transaction (an invoice, a debit memo or a credit memo)
9.2	Extensions in the copy group do not have the same values for payment channel, instrument assignment.	Bug	Note 1176555.1, Autoinvoice Error: Extensions in the copy group do not have the same values for payment channel, instrument assignment.

The Following Notes can be used for Credit Memo Related Issues:

• Note 1084554.1, Troubleshooting Grouping Rules In AutoInvoice
• Note 1067993.1, How To Use Grouping Rules With AutoInvoice

10. Receipt, Payment Method and Bank Errors

#	Error String or Presentation	Most Common Cause(s)	Comprehensive List of Known Causes
10.1	A receipt method is required when a payment extension entity is passed	Payment method associated with Automatic receipts or Credit Card payments incorrectly setup	Note 1205775.1 AutoInvoice Error: A receipt method is required when a payment extension entity is passed
10.2	The supplied payment method must be defined and active for the bill-to customer or site	Setup	Note 1058782.1AutoInvoice Error: The supplied payment method must be defined and active for the bill-to customer or site
10.3	When the receipt method is of type Automatic, you must either supply a valid bank account or ensure that a primary bank account for the currency code of the transaction has been set up for the Bill To	Date attached to the receipt method falls after transaction date	Note 1072672.1 AutoInvoice Error: When the receipt method is of type Automatic, you must either supply a valid bank account or ensure that a primary bank account for the currency code of the transaction has been set
10.4	The Supplied Cust Bank account (Customer_bank_account_id) Must Be Valid And Active	AutoInvoice created the customer bank account with effective date as sysdate, and the invoice date is set to the sales-order date, which was before sysdate.  This is happening for non shippable lines.	Note 438237.1 AutoInvoice Error : The Supplied Cust Bank account (Customer_bank_account_id) Must Be Valid And Active
10.5	Transaction extension does not exist.	Setup	,Note 1271912.1 Autoinvoice Error: Transaction Extension does not exist.

11. Payment Terms

#	Error String or Presentation	Most Common Cause(s)	Comprehensive List of Known Causes
11.1	Please set a default payment term for the customer, site, or transaction type.	You will get the error if both of the following is true: You have not setup a default payment term You have not checked Override Terms	Note 1171367.1 AutoInvoice Error: Please set a default payment term for the customer, site, or transaction type
11.2	You cannot supply payment terms for your credit memo transaction.	Credit Memo was passed with payment terms	Note 1174094.1AutoInvoice Error: You cannot supply payment terms for your credit memo transaction
11.3	You Must Supply Payment Terms For Your Non-credit Transaction	Setup/Data	Note 1171284.1 AutoInvoice Error: You Must Supply Payment Terms For Your Non-credit Transaction

12. Invoice/Transaction Numbering

#	Error String or Presentation	Most Common Cause(s)	Comprehensive List of Known Causes
12.1	You must supply an invoice number when your batch source indicates manual invoice numbering; otherwise you must leave invoice number blank.	Setup/Data	Note 277086.1  You must supply an invoice number when your batch source indicates manual invoice numbering; otherwise you must leave invoice number blank
12.2	APP-11948 Duplicate invoice number ()	Setup/Data	Note 130377.1APP-11948 Duplicate invoice number ()

13. Tax Errors

#	Error String or Presentation	Most Common Cause(s)	Comprehensive List of Known Causes
13.1	Invalid tax exempt flag (TAX_EXEMPT_FLAG)	Setup / Data	Note 1086586.1 AutoInvoice Error: Invalid tax exempt flag (TAX_EXEMPT_FLAG)
13.2	The system cannot calculate the taxable basis for the imported tax line because the tax rate is 0 but the tax amount  is not 0. Please change either the tax rate or the tax amount.	AMOUNT interfaced is not equal to the AMOUNT of LINE * TAX_RATE	Note 742419.1 AutoInvoice Error: The system cannot calculate the taxable basis for the imported tax line because the tax rate is 0 but the tax amount is not 0. Please change either the tax rate or the tax amount.
13.3	Adjusted document information is missing in our ZX repository	Bug(s)	Note 551361.1AutoInvoice Error: Adjusted document information is missing in our ZX repository
13.4	This transaction business category code does not exist	Bug(s)	Note 973469.1 AutoInvoice Error: Transaction Business category code does not exist
13.5	The Tax Code does not allow override of the amount includes tax flag	Setup / Data	Note 402892.1 AutoInvoice Error: The Tax Code Does Not Allow Override Of The Amount Includes Tax Flag
13.6	Unable to find a default tax code for this transaction	Occurs in 11i due to setup and defects	Note 1086193.1 AutoInvoice Error: Unable to find a default tax code for this transaction
13.7	Error in ARP_PROCESS_TAX.populate_ar_tax_struct()	Setup / Data	Note 1115984.1 AutoInvoice Error: Error in ARP_PROCESS_TAX.populate_ar_tax_struct

14.Miscellaneous Data Validation Errors

Note: The following errors can be experienced when the AutoInvoice Import validation process determines the transaction records are not valid to create a complete transaction:

#	Error String or Presentation	Most Common Cause(s)	Comprehensive List of Known Causes
14.1	You cannot define rules when your Accounting Method is Cash Basis.	Bug	Note 369508.1 You cannot define rules when your Accounting Method is Cash Basis.
14.2	Please supply both an invoicing rule and an accounting rule for this invoice.	Setup/Data Related	Note 1116934.1, How To Setup And Troubleshoot Invoicing Rules and Accounting Rules (under section 5.j)
14.3	Unable to get the product code for inventory_item_id	Setup/Date Related	Note 1217094.1 AutoInvoice Error: Unable to get the product code for inventory_item_id
14.4	You must supply the amount for this transaction ( Nil )	Setup/Date Related	Note 370557.1 AutoInvoice Error: You Must Supply The Amount For This Transaction ( Nil )
14.5	This inventory item has Invoice Enabled flag set to No	Setup/Date Related	Note 549203.1 Autoinvoice Error: This Inventory Item Has Invoice Enabled Flag Set To No
14.6	The supplied unit of measure and the primary unit of measure of your system item must share the same unit of measure class	Setup/Date Related	Note 1132807.1 Troubleshooting Unit of Measure Issues with AutoInvoice
14.7	Invalid ship via (SHIP_VIA) (SHIP_VIA)	Setup/Date Related	Note 274785.1Autoinvoice Error: Invalid Ship Via (Ship_Via) (Ship_Via)
14.8	Invalid Warehouse ID (WAREHOUSE_ID) (xxx)	Setup/Data Related	Note 1089026.1 AutoInvoice Error: Invalid Warehouse ID (WAREHOUSE_ID) (xxx)
14.9	Consolidated billing is enabled for this customer or bill-to-site, therefore you cannot import bills.	Balance Forward Billing was configured at the Customer level but not at the site level	Note 1082767.1Autoinvoice Error : Consolidated billing is enabled for this customer or bill-to-site, therefore you cannot import bills.
14.10	An invoice can only reference a commitment (xxxxx)	Mandatory fields are not populated for the Commitment Transaction Type that was being passed	Note 755834.1 AutoInvoice Error: An Invoice Can Only Reference A Commitment
14.11	A rule end date is required when using the Daily Revenue Rate rule. (DD-MON-YY)	Bugs	Note 563749.1 AutoInvoice Error: A rule end date is required when using the Daily Revenue Rate rule. (DD-MON-YY)
14.12	Please define the item validation organization in the Parameters window in Order Management	Setup/Data Related	Note 1163873.1 Error: Please define the item validation organization in the Parameters window in Order Management
14.13	The document created must have a non-negative total amount because the creation sign for your transaction type is Positive	Setup / Data Related	Note 568095.1 AutoInvoice Error: The document created must have a non-negative total amount because the creation sign for your transaction type is Positive
14.14	You cannot supply system items for your debit memo transaction	Bugs	Note 1265765.1AutoInvoice Error: You cannot supply system items for your debit memo transaction
14.15	Errors: 1)	Bug	Note 804334.1, Autoinvoice Error: AutoInvoice Validation Report Shows an Error with Blank Text

#	Error String or Presentation	Most Common Cause(s)	Comprehensive List of Known Causes
16.1	in RAXTRX log file: REP-0004: Warning: Unable to open user preference file. in AutoInvoice Execution Report: No Data Found ***** ok no error	Bug(s)	Note 1106851.1, AutoInvoice Error: REP-0004 Warning Unable to open user preference file
16.2	The Input Parameters which is normally shown at the top of the AutoInvoice Execution Report is missing.	Bug(s)	Note 807867.1, AutoInvoice issue: Autoinvoice Execution Report Does Not Show Input Parameters Used by the Process
16.3	AutoInvoice Execution Report output shows the Selected count and Rejected count, however it shows ***** No Data Found ***** under Exceptions, no details are provided regarding the rejected rows.	Setup	Note 1339417.1,  Autoinvoice Issue: AutoInvoice Execution Report is Not Showing Validation Errors For Some Transactions

Still Have Questions?

If you feel that a Service Request is needed, please be sure to provide the information listed below.

• Test to see if the problem can be replicated in the AR transaction workbench
• Include the Autoinvoice Exception Report if any
• Include the Autoinvoice Concurrent Process log file (see Note 1079666.1)
• Enable and include the FND debug log file generated by Autoinvoice (see Note 1079666.1)
• Include Diagnostics:

• Oracle Receivables AutoInvoice Interface Data Collection Test, this would show support what the interface data looks like.
• Oracle Receivables General Setup Test, this would show how the Line transaction Flexfield is defined.

For information on the diagnostic, please review the Diagnostic catalogs:

• Release 11.5: see Note 179661.1, E-Business Suite Diagnostics 11i Test Catalog
• Release 12.x: see Note 421245.1, E-Business Suite Diagnostics References for R12

Once you have identified your release, locate the right note for example, in 12.0.6,
Note 732187.1, R12.0.6+ : Oracle Receivables AutoInvoice Interface Data Collection Test.