Tuesday, June 17, 2014

Troubleshooting Grouping Rule Issues When Using AutoInvoice in AR

1.One Credit Memo Is Created When Expecting Several

After importing credit memo records, you find that they are grouped together on one credit memo transaction.  You are expecting the records to be imported as two separate transactions.  The problem is that the grouping rule was defined only for the invoice transaction class. 

Review the Grouping Rule defined, to see what has been selected for Transaction Class.  You can do this using the following navigation:

Responsibility: Receivables Manager
Navigation: Setup > Transactions > Autoinvoice > Grouping Rules

Note that the Transaction Class is Invoice in the following example of a defined Grouping Rule:


Now navigate to the Class field and use the down arrow to determine what (if any) other classes are defined for this grouping rule:


Then use the List of Values (LOV) to select the Credit Memo Transaction Class.


Now use the LOV in the Optional Grouping Characteristics field to select the desired column.  For this example we chose INTERFACE_LINE_ATTRIBUTE1:


After applying the changes, the Grouping Rule now looks like this:

In order for a grouping rule to work, it must be defined for each transaction class (Invoice, Credit Memo, and/or Debit Memo), based on the types of transactions being imported.

2. Multiple Invoice Transactions Created When Expecting One

    a. Consider the Mandatory and Optional Grouping Attributes

You are importing a sales order that has several sales order lines. The sales order is split into several invoice transactions after executing AutoInvoice.
There are a few reasons why this might happen.  First, a custom grouping rule could be assigned to the Transaction Source.  When optional grouping attributes are applied, this increases the chances for grouping into separate transactions.   Secondly, if there are no optional grouping attributes defined for a grouping rule, then one of the sales order lines has a mandatory grouping attribute that is different then the other sales order lines.   The following will demonstrate both examples:
Example 1 - Additional Optional Grouping Attributes are Defined

AutoInvoice uses the following hierarchy to default Grouping Rules, stopping when the first Grouping Rule is found:

1. From the Transaction Sources screen
2. From the customer profile at customer site level
3. From the customer profile at customer level
4. From the System Options

This order cannot be changed.  As a result, if you have customer specific grouping exceptions then you must define grouping rules at the customer or site level for all customers or set a default grouping rule in the system options form. 

Review the Transaction Source used to determine the Grouping Rule that has been assigned:



In this example the WSH GROUPING RULE is associated to the transaction source, Order Entry Delivery Invoicing, which is the transaction source used when the transactions were imported.

When we review the WSH GROUPING RULE, we see that an optional grouping attribute has been defined for the INTERFACE_LINE_ATTRIBUTE3 column.


Because of this additional attribute, the sales order lines are grouped by INTERFACE_LINE_ATTRIBUTE3.  If any one sales order line has a different value for INTERFACE_LINE_ATTRIBUTE3, then it is grouped into a separate transaction.


Example 2 - Sales Order Line Has Mandatory Grouping Attribute That Differs From Other Sales Order Lines
Usually this issue is identified in the early stages of implementation when testing the AutoInvoice process.  To help verify the issue, you can use the script below to review the sales order lines before importing.
Notes:

  1. For this example INTERFACE_LINE_ATTRIBUTE1 is used as the driving column since sales orders imported from Oracle Order Management use this column for the sales order number.   The query selects all of the Mandatory Grouping Attribute columns (as noted later in this document).  So you can change the where condition as needed, if you are importing from a legacy system or other source.
  2. Different releases of Oracle Receivables may introduce changes to the Mandatory and Optional grouping attributes, so please carefully review the User Guide for your release to determine the proper grouping attributes.

    You may also use the select statements provided in step 4 below to query the database for the grouping attributes.

/*
Test for Mandatory Grouping Attribute Columns Only
Please note that the attributes listed below are for Release 11.5 
*/

Select AGREEMENT_ID,
COMMENTS,CONS_BILLING_NUMBER,
CONVERSION_DATE,CONVERSION_RATE,CONVERSION_TYPE,
CREDIT_METHOD_FOR_ACCT_RULE,
CREDIT_METHOD_FOR_INSTALLMENTS,
CURRENCY_CODE, CUSTOMER_BANK_ACCOUNT_ID,
CUST_TRX_TYPE_ID, DOCUMENT_NUMBER,
DOCUMENT_NUMBER_SEQUENCE_ID,
GL_DATE, HEADER_ATTRIBUTE1,
HEADER_ATTRIBUTE2,HEADER_ATTRIBUTE3,
HEADER_ATTRIBUTE4,HEADER_ATTRIBUTE5,
HEADER_ATTRIBUTE6,HEADER_ATTRIBUTE7,
HEADER_ATTRIBUTE8,HEADER_ATTRIBUTE9,
HEADER_ATTRIBUTE10,HEADER_ATTRIBUTE11,
HEADER_ATTRIBUTE12,HEADER_ATTRIBUTE13,
HEADER_ATTRIBUTE14,HEADER_ATTRIBUTE15,
HEADER_ATTRIBUTE_CATEGORY,
HEADER_GDF_ATTRIBUTE1,HEADER_GDF_ATTRIBUTE2,
HEADER_GDF_ATTRIBUTE3,HEADER_GDF_ATTRIBUTE4,
HEADER_GDF_ATTRIBUTE5,HEADER_GDF_ATTRIBUTE6,
HEADER_GDF_ATTRIBUTE7,HEADER_GDF_ATTRIBUTE8,
HEADER_GDF_ATTRIBUTE9,HEADER_GDF_ATTRIBUTE10,
HEADER_GDF_ATTRIBUTE11,HEADER_GDF_ATTRIBUTE12,
HEADER_GDF_ATTRIBUTE13,HEADER_GDF_ATTRIBUTE14,
HEADER_GDF_ATTRIBUTE15,HEADER_GDF_ATTRIBUTE16,
HEADER_GDF_ATTRIBUTE17,HEADER_GDF_ATTRIBUTE18,
HEADER_GDF_ATTRIBUTE19,HEADER_GDF_ATTRIBUTE20,
HEADER_GDF_ATTRIBUTE21,HEADER_GDF_ATTRIBUTE22,
HEADER_GDF_ATTRIBUTE23,HEADER_GDF_ATTRIBUTE24,
HEADER_GDF_ATTRIBUTE25,HEADER_GDF_ATTRIBUTE26,
HEADER_GDF_ATTRIBUTE27,HEADER_GDF_ATTRIBUTE28,
HEADER_GDF_ATTRIBUTE29,HEADER_GDF_ATTRIBUTE30,
INITIAL_CUSTOMER_TRX_ID,
INTERNAL_NOTES, INVOICING_RULE_ID,
ORIG_SYSTEM_BILL_ADDRESS_ID,
ORIG_SYSTEM_BILL_CONTACT_ID,
ORIG_SYSTEM_BILL_CUSTOMER_ID,
ORIG_SYSTEM_SHIP_CONTACT_ID,
ORIG_SYSTEM_SHIP_CUSTOMER_ID,
ORIG_SYSTEM_SOLD_CUSTOMER_ID,
ORIG_SYSTEM_BATCH_NAME,
PAYMENT_SET_ID, PREVIOUS_CUSTOMER_TRX_ID,
PRIMARY_SALESREP_ID, PRINTING_OPTION,
PURCHASE_ORDER, PURCHASE_ORDER_DATE,
PURCHASE_ORDER_REVISION, REASON_CODE,
RECEIPT_METHOD_ID,RELATED_CUSTOMER_TRX_ID,
SET_OF_BOOKS_ID,TERM_ID,
TERRITORY_ID,TRX_DATE,
TRX_NUMBER
From RA_INTERFACE_LINES_ALL
where INTREFACE_LINE_ATTRIBUTE1 = '&sales_order';
 If Optional Grouping Attributes are used, then you can use the following query, in addition to the one above:
/*
Test for Optional Grouping Attribute Columns Only
Please note that the attributes listed below are for Release 11.5
*/

Select ACCOUNTING_RULE_DURATION,
ACCOUNTING_RULE_ID,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE_CATEGORY,
INTERFACE_LINE_ATTRIBUTE1,
INTERFACE_LINE_ATTRIBUTE2,
INTERFACE_LINE_ATTRIBUTE3,
INTERFACE_LINE_ATTRIBUTE4,
INTERFACE_LINE_ATTRIBUTE5,
INTERFACE_LINE_ATTRIBUTE6,
INTERFACE_LINE_ATTRIBUTE7,
INTERFACE_LINE_ATTRIBUTE8,
INTERFACE_LINE_ATTRIBUTE9,
INTERFACE_LINE_ATTRIBUTE10,
INTERFACE_LINE_ATTRIBUTE11,
INTERFACE_LINE_ATTRIBUTE12,
INTERFACE_LINE_ATTRIBUTE13,
INTERFACE_LINE_ATTRIBUTE14,
INTERFACE_LINE_ATTRIBUTE15,
INTERFACE_LINE_CONTEXT,
INVENTORY_ITEM_ID,
REFERENCE_LINE_ID,
RULE_START_DATE,
SALES_ORDER,
SALES_ORDER_DATE,
SALES_ORDER_LINE,
SALES_ORDER_REVISION,
SALES_ORDER_SOURCE,
TAX_CODE,
TAX_RATE
FROM RA_INTERFACE_LINES_ALL
where INTERFACE_LINE_ATTRIBUTE1 = '&sales_order'
When you execute either of the above queries, the output allows you to compare the sales order lines by column to verify the values assigned to the attributes.  You can use SQL*DEVELOPER to review the output or save the output to a spreadsheet to verify the same.

The following reflects the output from SQL*DEVELOPER for the Mandatory Grouping Attributes for one sales order:

Note:  The TRX_DATE values are different for each record of the two sales order lines. In this case each record will be grouped as a separate invoice transaction.
 

    b. Consider the frequency in which AutoInvoice is executed

When scheduling the AutoInvoice process to execute on a frequent basis, you should consider the timing as to when the interface tables are populated from a source system.

For instance, if you schedule the AutoInvoice process to execute every 5 minutes, you need to consider when the sales orders lines are interfaced from Order Management for a complete sales order.   If it takes 10 minutes for all sales order lines to be processed and interfaced to Receivables, then the AutoInvoice process should be scheduled to execute every 15 minutes.  

Considering the interval of the scheduled AutoInvoice process, will ensure that all sales order lines are imported together.  Otherwise a sales order can be invoiced on multiple invoices when the AutoInvoice process is executed before all sales order lines are interfaced to Oracle Receivables.

3. Order Management - Line Transaction Flexfield

What are the Order Management Details that are interfaced to Receivables in the Line Transaction Flexfield?

Note: These columns can be grouped using the Optional Grouping Attributes
Column NameOrder Management Value
INTERFACE_LINE_ATTRIBUTE1Sales Order Number
INTERFACE_LINE_ATTRIBUTE2Order Type (Type Name)
INTERFACE_LINE_ATTRIBUTE3For Shipped Line: WSH_NEW_DELIVERIES.DEL.NAME
For Non-Shipped:
Non-Shipped: Order Line
Return Line: 0 (zero)
Freight Charges: Delivery Name
Discount Lines: 0 (zero)
INTERFACE_LINE_ATTRIBUTE4For Shipped Line: substr(DEL.WAYBILL,1,30)
Non-Shipped Order Line: 0 (zero)
Freight Charges: substr(DEL.WAYBILL,1,30)
Discount Lines: 0 (zero)
INTERFACE_LINE_ATTRIBUTE5For Sales Order Lines and Return Lines:  The number of times the order or return line has been interfaced for invoice or credit.

Freight Charges: 1 (one)
INTERFACE_LINE_ATTRIBUTE6Sales Order Lines, Return Lines, Discount Lines: LINE.LINE_ID

Freight Charges: Charge.Charge_id
INTERFACE_LINE_ATTRIBUTE70
INTERFACE_LINE_ATTRIBUTE8Shipped Order Line: WSH_DOCUMENT_INSTANCES.SEQUENCE_NUMBER

Non-Shipped Order Line: 0 (zero)

Return Lines: 0 (zero)

Freight Charges: 0 (zero)

Discount Lines: 0  (zero)
INTERFACE_LINE_ATTRIBUTE9Customer Item Number if one is defined, otherwise insert 0 (zero).
INTERFACE_LINE_ATTRIBUTE10Null
INTERFACE_LINE_ATTRIBUTE11Discount Lines: PA.PRICE_ADJUSTMENT_ID
INTERFACE_LINE_ATTRIBUTE12Sales Order Lines, Return Lines, and Discount Lines: LINE.SHIPMENT_NUMBER

Freight Charges: None
INTERFACE_LINE_ATTRIBUTE13Sales Order Lines, Return Lines, and Discount Lines:
LINE.OPTION_NUMBER

Freight Charges: None
INTERFACE_LINE_ATTRIBUTE14Sales Order Lines, Return Lines, and Discount Lines:
LINE.SERVICE_NUMBER

Freight Charges: None
INTERFACE_LINE_ATTRIBUTE15Null

For more details regarding the Order Management Interfaces, review the Oracle Order Management Open Interfaces, API, and Electronic Messaging Guide, page 8-6.

4. Mandatory And Optional Grouping Attribute Columns

The following provides a list of mandatory and optional attributes from the RA_INTERFACE_LINES_ALL table.

Note: 
  • Some attributes have changed between Release 11.5 and 12.x
  • An Enhancement Request (5943921) has been logged requesting the REASON_CODE is removed from the Mandatory Grouping Attributes. 

   a. Release 12.x, Mandatory Grouping Attributes


Note:
Grouping attribute behavior changed between Release 11.5., and Release 12.
Note 1280194.1, Why Autoinvoice Ship to fields were mandatory grouping attributes in release 11i, but are optional in release 12?
AGREEMENT_ID
APPLICATION_ID
BILLING_DATE
COMMENTS
CONS_BILLING_NUMBER
CONTRACT_ID
CONVERSION_DATE
CONVERSION_RATE
CONVERSION_TYPE
CREDIT_METHOD_FOR_ACCT_RULE
CREDIT_METHOD_FOR_INSTALLMENTS
CURRENCY_CODE
CUSTOMER_BANK_ACCOUNT_ID
CUST_TRX_TYPE_ID
DEFAULT_TAXATION_COUNTRY
DOCUMENT_NUMBER
DOCUMENT_NUMBER_SEQUENCE_ID
DOCUMENT_SUB_TYPE
GL_DATE
HEADER_ATTRIBUTE1-15
HEADER_ATTRIBUTE_CATEGORY
HEADER_GDF_ATTRIBUTE1-30
HEADER_GDF_ATTR_CATEGORY
INITIAL_CUSTOMER_TRX_ID
INTERNAL_NOTES
INVOICING_RULE_ID
LEGAL_ENTITY_ID
ORIG_SYSTEM_BILL_ADDRESS_ID
ORIG_SYSTEM_BILL_CONTACT_ID
ORIG_SYSTEM_BILL_CUSTOMER_ID
ORIG_SYSTEM_SOLD_CUSTOMER_ID
PAYMENT_ATTRIBUTES
ORIG_SYSTEM_BATCH_NAME
PAYMENT_SET_ID
PREVIOUS_CUSTOMER_TRX_ID
PRIMARY_SALESREP_ID
PRINTING_OPTION
PURCHASE_ORDER
PURCHASE_ORDER_DATE
PURCHASE_ORDER_REVISION
REASON_CODE
RECEIPT_METHOD_ID
RELATED_CUSTOMER_TRX_ID
SET_OF_BOOKS_ID
TAXED_UPSTREAM_FLAG
TERM_ID
TERRITORY_ID
TRX_DATE
TRX_NUMBER

   b. Release 12.x, Optional Grouping Attributes

ACCOUNTING_RULE_DURATION
ACCOUNTING_RULE_ID
ATTRIBUTE1-15
ATTRIBUTE_CATEGORY
CODE_COMBINATION_ID
INTERFACE_LINE_ATTRIBUTE1-15
INTERFACE_LINE_CONTEXT
INVENTORY_ITEM_ID
LINE_GDF_ATTRIBUTE1-20
LINE_GDF_ATTR_CATEGORY
ORIG_SYSTEM_SHIP_ADDRESS_ID
ORIG_SYSTEM_SHIP_CONTACT_ID
ORIG_SYSTEM_SHIP_CUSTOMER_ID
REFERENCE_LINE_ID
RULE_START_DATE
SALES_ORDER
SALES_ORDER_DATE
SALES_ORDER_LINE
SALES_ORDER_REVISION
SALES_ORDER_SOURCE
TAX_CODE
TAX_RATE

   c. Release 11.5, Mandatory Grouping Attributes

AGREEMENT_ID
COMMENTS
CONS_BILLING_NUMBER
CONTRACT_ID
CONVERSION_DATE
CONVERSION_RATE
CONVERSION_TYPE
CREDIT_METHOD_FOR_ACCT_RULE
CREDIT_METHOD_FOR_INSTALLMENTS
CURRENCY_CODE
CUSTOMER_BANK_ACCOUNT_ID
CUST_TRX_TYPE_ID
DOCUMENT_NUMBER
DOCUMENT_NUMBER_SEQUENCE_ID
GL_DATE
HEADER_ATTRIBUTE1-15
HEADER_ATTRIBUTE_CATEGORY
HEADER_GDF_ATTRIBUTE1-30
INITIAL_CUSTOMER_TRX_ID
INTERNAL_NOTES
INVOICING_RULE_ID
ORIG_SYSTEM_BILL_ADDRESS_ID
ORIG_SYSTEM_BILL_CONTACT_ID
ORIG_SYSTEM_SHIP_CUSTOMER_ID
ORIG_SYSTEM_SOLD_CUSTOMER_ID
ORIG_SYSTEM_SOLD_CUSTOMER_ID
ORIG_SYSTEM_BATCH_NAME
PAYMENT_SET_ID
PREVIOUS_CUSTOMER_TRX_ID
PRIMARY_SALESREP_ID
PRINTING_OPTION
PURCHASE_ORDER
PURCHASE_ORDER_DATE
PURCHASE_ORDER_REVISION
REASON_CODE
RECEIPT_METHOD_ID
RELATED_CUSTOMER_TRX_ID
SET_OF_BOOKS_ID
TERM_ID
TERRITORY_ID
TRX_DATE
TRX_NUMBER

   d. Release 11.5, Optional Grouping Attributes

ACCOUNTING_RULE_DURATION
ACCOUNTING_RULE_ID
ATTRIBUTE1-15
ATTRIBUTE_CATEGORY
INTERFACE_LINE_ATTRIBUTE1-15
INTERFACE_LINE_CONTEXT
INVENTORY_ITEM_ID
REFERENCE_LINE_ID
RULE_START_DATE
SALES_ORDER
SALES_ORDER_DATE
SALES_ORDER_LINE
SALES_ORDER_REVISION
SALES_ORDER_SOURCE
TAX_CODE
TAX_RATE

   e. Scripts to identify grouping attributes

For a comprehensive list of all Mandatory and Optional Grouping Attributes used in your instance, you can run the following:

-- for MANDATORY

select column_type, from_column_name
from ra_group_by_columns
where column_type = 'M';

-- for OPTIONAL

select column_type, from_column_name
from ra_group_by_columns
where column_type <> 'M';

To see a list of fields that will be used by the grouping rule for a particular transaction type, you can use the following scripts:

First, Determine the value to use in &group_rule_id below by running the following:

SELECT GROUPING_RULE_ID
FROM RA_GROUPING_RULES
WHERE NAME = '&Enter Grouping Rule Name';

For example, using the value = 'DEFAULT' will result in GROUPING_RULE_ID = -1

Then run the following replacing &group_rule_id with the value returned by previous script and &trx_type with INV for Invoice, CM for Credit Memo and DM for Debit Memo:

SELECT UPPER(C.FROM_COLUMN_NAME),
C.FROM_COLUMN_LENGTH
FROM RA_GROUPING_TRX_TYPES T,
RA_GROUP_BYS B,
RA_GROUP_BY_COLUMNS C
WHERE T.GROUPING_RULE_ID = &group_rule_id
AND T.CLASS = DECODE('&trx_type',
'INV', 'I',
'CM', 'C',
'DM', 'D')
AND T.GROUPING_TRX_TYPE_ID = B.GROUPING_TRX_TYPE_ID
AND B.COLUMN_ID = C.COLUMN_ID
UNION
SELECT UPPER(C.FROM_COLUMN_NAME),
C.FROM_COLUMN_LENGTH
FROM RA_GROUP_BY_COLUMNS C
WHERE C.COLUMN_TYPE = 'M'
order by 1;

By using the script above, you can identify which fields need to be similar for interface rows to be grouped into a single transaction.

For more information about Grouping Rules, you can also review the Receivables User's Guide, page 2-241.

5. Intercompany Limitations

Is it possible to split two intercompany lines from one order with unique delivery numbers into separate invoices?
Answer:  No - Order management does not pass delivery number to receivables interface tables in any field and thus grouping rules cannot take this into account during invoice creation.

6. What Happens if One Line is Rejected?

Let's assume the Batch Source is set to Invalid Line: REJECT INVOICE in the batch source definition.  Is it possible to reject the entire invoice or is the only option to fix the problem and generate a second invoice?

If you state that you want to import (despite rejected lines), what you are really saying is that you want to import what you can of the transaction despite any rejections that occur to individual lines. However, once the transaction has been grouped, a
rejection on any one line will reject the entire transaction. So, in other words, the feature favors rejecting entire post-group transactions.  In cases such as when a Customer ID is invalid, the customer is part of the grouping criteria and thus if you have a 5 line invoice rejected for invalid customer ID's and then you update 2 of the 5 lines to correct the error and re-run, AutoInvoice will group the two corrected lines into an invoice and import the record, leaving three lines unprocessed.

7. How Commitment Lines are Grouped


In Lines attached to commitments the reference_line_id will populate Initial_customer_trx_id which is a mandatory grouping column.  Lines without commitments have this field as null.  Sales orders subsequently will always  split commitments into separate invoices from non-commitment order lines.

AR Invoice errors and solutions

Message NameError String or PresentationComprehensive List of Known Causes
AR_BFB_TERM_BILL_LEVEL_WRONGBalance forward billing is enabled for this customer at the account level, but
is either disabled or not defined at site level.
Ensure that Balance Forward Billing is enabled at both the Account Level and Site Level profiles.

If balance forward is enabled at both Site and Account and this error message persists, you may be hitting the issue addressed in Patch 8235038.

If balance forward billing is enabled only at the Account level, you may be hitting the issue addresed in Patch 12325638

For additional details on this error message., please review Note 1053006.1, Error "Balance forward billing is enabled for this customer but disabled at the account site level" is raised when creating transactions for Balance Forward enabled customers
AR_BFB_TERM_NO_DEFAULTPlease set a default payment term for the customer, site, or transaction type.Please review Note 1171367.1, AutoInvoice Error: Please set a default payment term for the customer, site, or transaction type.
AR_CKAP_OVERAPPYou cannot over apply this transactionPlease refer to troubleshooting details in Note 1089172.1
AR_INVALID_PAY_EXT_IDInvalid payment extension ID.Please refer to troubleshooting details in Note 1220847.1
AR_INVALID_PAYMENT_TYPE_CODEInvalid payment type code.Please review Note 1280687.1, AutoInvoice Error: INVALID_PAYMENT_TYPE_CODE
AR_MAECM_LINE_OVERAPPLIEDYou can not apply more than the original line amountCheck whether there are other Credit memos, Receipts or Adjustments already applied to the Invoice that you are attempting to Credit via AutoInvoice.

Please refer to Note 1122945.1
AR_RAXINV_INVALID_PARAMETERSThe parameter &PARAM is not valid.Generic error raised when any of the AutoInvoice parameters cannot be validated.
AR_RAXTRX-1513(Null)Generic error message. 
AR_RAXTRX-1514None of the transaction flexfield contexts you have provided for this request have enabled segmentsNote 1077555.1, Troubleshooting Transaction Flexfields in AutoInvoice
AR_RAXTRX-1614Related transactions must have the same or related Bill To customersCheck the Bill-To customer associated, if this is for a Credit Memo, the Bill-To customer must match or must be related to the Bill-To customer of the invoice being credited.
AR_RAXTRX-1615The bill to customer of your transaction must be the same or related to the one of the commitmentCheck the Bill-To customer of the transaction being associated to the  commitment, they must match or must be related.
AR_RAXTRX-1616The currency code of your transaction must be the same as the currency code of the commitmentCheck the currency code of the transaction being associated to the  commitment, the currency codes must match.
AR_RAXTRX-1620You must supply a sales credit percentage when your batch source indicates you supply percentagesCheck whether you have set Amount or Percent for Sales Credit in your Batch Source, for details review Note 1068008.1, Creating Transaction Sources Used For AutoInvoice (review setting in Sales Credit Validation tab)Check whether you have supplied a value in RA_INTERFACE_SALESCREDITS_ALL SALES_CREDIT_PERCENT_SPLIT
AR_RAXTRX-1621Invalid salesrep number (SALESREP_NUMBER)Please refer to troubleshooting details in Note 1089172.1
AR_RAXTRX-1622Invalid salesrep id (SALESREP_ID)Please refer to troubleshooting details in Note 1089172.1
AR_RAXTRX-1623Invalid sales credit type id (SALES_CREDIT_TYPE_ID)Please refer to troubleshooting details in Note 1089172.1
AR_RAXTRX-1624Your sales credit assignment must be for a transaction of line type LINECheck the values in RA_INTERFACE_SALESCREDITS_ALL
INTERFACE_LINE_CONTEXT and INTERFACE_LINE_ATTRIBUTE*  and ensure the values are pointing to a record in RA_INTERFACE_LINES_ALL where LINE_TYPE = LINE
AR_RAXTRX-1625Please enter quota sales credits that equal the line amount.Check the value in RA_INTERFACE_SALESCREDITS_ALL SALES_CREDIT_AMOUNT_SPLIT ensure the value conforms to the precision of the currency.
AR_RAXTRX-1626Invalid sales credit type name (SALES_CREDIT_TYPE_NAME)Ensure that RA_INTERFACE_SALESCREDITS_ALL SALES_CREDIT_TYPE_NAME exists in SO_SALES_CREDIT_TYPES
AR_RAXTRX-1627Please enter quota sales credit percentages that equal 100 percent for this line.Check the total of RA_INTERFACE_SALESCREDITS_ALL
SALES_CREDIT_PERCENT_SPLIT associated to a particular transaction line is 100.
AR_RAXTRX-1628You must supply a value for the sales credit amountEnsure you are passing a non-null value in RA_INTERFACE_SALESCREDITS_ALL SALES_CREDIT_AMOUNT_SPLIT
AR_RAXTRX-1629You must supply sales credit assignments for this transaction because the system option Require Salesreps is set to Yes.Ensure that you have provided sales credit data in RA_INTERFACE_SALESCREDITS_ALL linked to your data in RA_INTERFACE_LINES_ALL.INTERFACE_LINE_ID
AR_RAXTRX-1630Invalid sales group ID (SALESGROUP_ID)Ensure RA_INTERFACE_SALESCREDITS_ALL SALESGROUP_ID exists in JTF_RS_GROUPS_B
AR_RAXTRX-1655Invalid tax exempt reason code (TAX_EXEMPT_REASON_CODE)Note 750064.1, Using and Troubleshooting Tax Exemptions in R 12 E-Business Tax (EBTax)
AR_RAXTRX-1659Tax code must be active, adhoc, and of type VAT or SALES TAXCheck the value passed in RA_INTERFACE_LINES_ALL TAX_CODE exists in AR_VAT_TAX
This error is only relevant in 11.5
AR_RAXTRX-1661Invalid reference line id (REFERENCE_LINE_ID)Ensure the value passed in RA_INTERFACE_LINES_ALL REFERENCE_LINE_ID exists in RA_CUSTOMER_TRX_LINES_ALL CUSTOMER_TRX_LINE_ID
AR_RAXTRX-1662Invalid reference line attribute value (REFERENCE_LINE_ATTRIBUTE1-15)Ensure the values passed in RA_INTERFACE_LINES_ALL REFERENCE_LINE_ATTRIBUTE* exists in RA_CUSTOMER_TRX_LINES_ALL INTERFACE_LINE_ATTRIBUTE*
AR_RAXTRX-1664All enabled segments of Transaction Flexfield must have a valueReview Note 1068344.1, Setting Up Receivables Descriptive Flexfields
validate Line Transaction Flexfield setup, then check that the data in RA_INTERFACE_LINES_ALL passes a value for each of the enabled segments.
AR_RAXTRX-1665AThis line has the same transaction flexfield as another row in the interface table. For each transaction line, the combination of interface_line_context and interface_line_attribute values must be unique.Check that the combination of values in RA_INTERFACE_LINES_ALL INTERFACE_LINE_CONTEXT + INTERFACE_LINE_ATTRIBUTE* is unique.

For tips on how to investigate this error, please review:
Note 1339318.1, Autoinvoice Error: This line has the same transaction flexfield as another row in the interface table 
AR_RAXTRX-1665B"This line has the same transaction flexfield as another invoice within Receivables. For each transaction line in Receivables, the combination of interface_line_context and interface_line_attribute values must be unique."Check that the combination of values in RA_INTERFACE_LINES_ALL INTERFACE_LINE_CONTEXT + INTERFACE_LINE_ATTRIBUTE* does not yet exist in RA_CUSTOMER_TRX_LINES_ALL
AR_RAXTRX-1666Your credit memo transaction can only credit an invoice or a debit memo lineCheck the values in RA_INTERFACE_LINES_ALL REFERENCE_LINE_ATTRIBUTE1-15 and REFERENCE_LINE_CONTEXT,  the record identified by these values has to be an Invoice or a Debit Memo.
AR_RAXTRX-1667Your debit memo transaction cannot be against a commitment, or credit any other transactionDebit memos should not have values in RA_INTERFACE_LINES_ALL  REFERENCE_LINE_ATTRIBUTE1-15 and REFERENCE_LINE_CONTEXT
AR_RAXTRX-1668An invoice can only reference a commitmentReview Note 755834.1, AutoInvoice Error: An Invoice Can Only Reference A Commitment
AR_RAXTRX-1669The valid account class for this line type is 'CHARGES'Check that the value in RA_INTERFACE_LINES_ALL.LINE_TYPE =  'CHARGES'
AR_RAXTRX-1670You must supply a charges account for your charges line if you have not set up AutoAccounting for revenue accountCheck how you have setup AutoAccounting (see Note 1069052.1and Note 1080995.1), then validate that you have completed the setup for the Revenue Account which will be used by Charges.

If you do not wish to use AutoAccounting for Charges, then you must provide a corresponding record in RA_INTERFACE_DISTRIBUTIONS_ALL and supply a value in CODE_COMBINATION_ID or the corresponding SEGMENT* fields for the CHARGES distribution.
AR_RAXTRX-1671Invalid account class (ACCOUNT_CLASS)Check that the value provided in RA_INTERFACE_DISTRIBUTIONS_ALL.ACCOUNT_CLASS is one of the following:
REV, FREIGHT, TAX, REC, UNBILL (for Arrears), UNEARN (for Advance), CHARGES
AR_RAXTRX-1672The valid account classes are: REV, FREIGHT, TAX and RECCheck that the value provided in RA_INTERFACE_DISTRIBUTIONS_ALL.ACCOUNT_CLASS is one of the following:
REV, FREIGHT, TAX and REC
AR_RAXTRX-1673The valid account classes are: REV, FREIGHT, TAX, REC and UNEARNCheck that the value provided in RA_INTERFACE_DISTRIBUTIONS_ALL.ACCOUNT_CLASS is one of the following:
REV, FREIGHT, TAX, REC and UNEARN
AR_RAXTRX-1674The valid account classes are: REV, FREIGHT, TAX, REC and UNBILLCheck that the value provided in RA_INTERFACE_DISTRIBUTIONS_ALL.ACCOUNT_CLASS is one of the following:
REV, FREIGHT, TAX, REC and UNBILL
AR_RAXTRX-1675The total distribution amount for a transaction line must equal the transaction amountCheck that the sum of  RA_INTERFACE_DISTRIBUTIONS_ALL.AMOUNT for a specific INTERFACE_LINE_ID value matches the value in RA_INTERFACE_LINES_ALL.AMOUNT
AR_RAXTRX-1676The total distribution percent for a transaction line must be 100 for each account classCheck that the sum of RA_INTERFACE_DISTRIBUTIONS_ALL.PERCENT for a specific INTERFACE_LINE_ID, ACCOUNT_CLASS and ORG_ID is 100
AR_RAXTRX-1677You can only supply one freight account for a transaction of line type FREIGHTWhen providing Freight you can interface a FREIGHT line either at the RA_INTERFACE_LINES_ALL level or the RA_INTERFACE_DISTRIBUTIONS_ALL level, you cannot provide at both levels
AR_RAXTRX-1678You must supply a value for the distribution amountIf you intend to pass in the distributions you want the transactions to use, check that you have provided a non-null value for RA_INTERFACE_DISTRIBUTIONS_ALL.AMOUNT.

On the other hand, if you would like AutoInvoice to derive all the GL distributions from the AutoAccounting setup, then make sure you are not passing any rows in the RA_INTERFACE_DISTRIBUTIONS_ALL table.
AR_RAXTRX-1679You must supply a distribution percentage when your batch source indicates you supply percentages, or when your transaction uses an accounting ruleEnsure that you provide a value in RA_INTERFACE_DISTRIBUTIONS.PERCENT when your invoice has an Accounting Rule or the ACCOUNT_CLASS = 'REC'
AR_RAXTRX-1680The valid account classes for this line type are: 'REV', 'UNBILL' and 'REC'Check that the value provided in RA_INTERFACE_DISTRIBUTIONS_ALL.ACCOUNT_CLASS is one of the following:
REV,  UNBILL and REC
AR_RAXTRX-1681The valid account classes for this line type are: 'REV', 'UNEARN' and 'REC'Check that the value provided in RA_INTERFACE_DISTRIBUTIONS_ALL.ACCOUNT_CLASS is one of the following:
REV, UNEARN and REC
AR_RAXTRX-1682The valid account class for this line type is 'TAX'Check that for the INTERFACE_LINE_ID value, if  RA_INTERFACE_LINES_ALL.LINE_TYPE = 'TAX', then RA_INTERFACE_DISTRIBUTIONS_ALL.ACCOUNT_CLASS should be 'TAX'
AR_RAXTRX-1683The valid account class for this line type is 'FREIGHT'Check that for the INTERFACE_LINE_ID value, if RA_INTERFACE_LINES_ALL.LINE_TYPE = 'FREIGHT', then RA_INTERFACE_DISTRIBUTIONS_ALL.ACCOUNT_CLASS should be 'FREIGHT'
AR_RAXTRX-1685You must supply a freight account for your freight line if you have not set up AutoAccounting for freight accountCheck how you have setup AutoAccounting (see Note 1069052.1and Note 1080995.1), then validate that you have completed the setup for the Freight Account.

If you do not wish to use AutoAccounting for Freight, then you must provide a corresponding record in RA_INTERFACE_DISTRIBUTIONS_ALL and supply a value in CODE_COMBINATION_ID or the corresponding SEGMENT* fields for the FREIGHT distribution.
AR_RAXTRX-1686You must supply a tax account for your tax line if you have not set up AutoAccounting for tax accountCheck how you have setup AutoAccounting (see Note 1069052.1and Note 1080995.1), then validate that you have completed the setup for the Tax Account.

If you do not wish to use AutoAccounting for Tax, then you must provide a corresponding record in RA_INTERFACE_DISTRIBUTIONS_ALL and supply a value in CODE_COMBINATION_ID or the corresponding SEGMENT* fields for the TAX distribution.
AR_RAXTRX-1687You must supply a receivables account for your document if you have not set up AutoAccounting for receivables accountCheck how you have setup AutoAccounting (see Note 1069052.1and Note 1080995.1), then validate that you have completed the setup for the Receivables Account.

If you do not wish to use AutoAccounting for Receivables, then you must provide a corresponding record in RA_INTERFACE_DISTRIBUTIONS_ALL and supply a value in CODE_COMBINATION_ID or the corresponding SEGMENT* fields for the REC distribution.
AR_RAXTRX-1688You must supply a revenue account for your line if you have not set up AutoAccounting for revenue accountCheck how you have setup AutoAccounting (see Note 1069052.1and Note 1080995.1), then validate that you have completed the setup for the Revenue Account.

If you do not wish to use AutoAccounting for Revenue, then you must provide a corresponding record in RA_INTERFACE_DISTRIBUTIONS_ALL and supply a value in CODE_COMBINATION_ID or the corresponding SEGMENT* fields for the REV distribution.
AR_RAXTRX-1689You must supply an unbilled account for your line if you have not defined an unbilled account in AutoAccountingCheck how you have setup AutoAccounting (see Note 1069052.1and Note 1080995.1), then validate that you have completed the setup for the Unbilled Revenue Account.

If you do not wish to use AutoAccounting for Unbilled Revenue, then you must provide a corresponding record in RA_INTERFACE_DISTRIBUTIONS_ALL and supply a value in CODE_COMBINATION_ID or the corresponding SEGMENT* fields for the UNBILL distribution.
AR_RAXTRX-1690You can supply at most one Receivables account for a transaction (an invoice, a debit memo or a credit memo)Check for a distinct combination of INTERFACE_LINE_CONTEXT + INTERFACE_LINE_ATTRIBUTE* fields that there is only one REC distribution in RA_INTERFACE_DISTRIBUTIONS_ALL.
AR_RAXTRX-1691You must supply an unearned account for your line if you have not defined an unearned account in AutoAccountingCheck how you have setup AutoAccounting (see Note 1069052.1and Note 1080995.1), then validate that you have completed the setup for the Unearned Revenue Account.

If you do not wish to use AutoAccounting for Unearned Revenue, then you must provide a corresponding record in RA_INTERFACE_DISTRIBUTIONS_ALL and supply a value in CODE_COMBINATION_ID or the corresponding SEGMENT* fields for the UNEARN distribution.
AR_RAXTRX-1692The document created must have a non-negative total amount because the creation sign for your transaction type is PositivePlease refer to troubleshooting details in Note 568095.1

Also, validate the Creation Sign of the Transaction type used by this transaction (see Note 1067797.1), if the creation sign is defined as Positive Sign, then the total of RA_INTERFACE_LINES_ALL.EXTENDED_AMOUNT for this transaction must be a positive amount.
AR_RAXTRX-1693The document created must have a non-positive total amount because the creation sign for your transaction type is NegativeValidate the Creation Sign of the Transaction type used by this transaction (see Note 1067797.1), if the creation sign is defined as Negative Sign, then the total of RA_INTERFACE_LINES_ALL.EXTENDED_AMOUNT for this transaction must be a negative amount.
AR_RAXTRX-1694The total amount of your credit memo cannot exceed the balance of the debit item it is creditingPlease refer to Note 1122945.1
AR_RAXTRX-1695You cannot apply a transaction with a negative amount to another transaction with a negative balance and vice versaPlease review Note 1174659.1 AutoInvoice Error: You cannot apply a transaction with a negative amount to another transaction with a negative balance and vice versa.
AR_RAXTRX-1696A credit memo created with a positive total amount cannot credit an invoice which is against a commitmentCheck the following:
- is interface data for a credit memo?
- is the amount of the credit memo positive?
- is it to credit an invoice that was drawn against a commitment?
If you answer Yes to all of the above, then you cannot interface such a credit memo. AutoInvoice will not allow you to "positive-credit" an invoice drawn against a commitment which effectively makes it balance bigger.
AR_RAXTRX-1697An invoice against a commitment cannot have a negative total amountCheck the following:
- is interface data for an invoice?
- is the amount of the invoice negative?
- are the REFERENCE fields pointing to a commitment?

If you answer Yes to all of the above, then you cannot interface such an invoice. AutoInvoice will not allow you to draw from a commitment a negative amount.
AR_RAXTRX-1698The Receivables account of your credit transaction must be the same as that of the transaction being credited, if the credit transaction has the Open Receivables Flag set to NoThe CODE_COMBINATION_ID values used for the REC account for both credit memo and invoice have to match when Open Receivables Flag = No.

If passing in the distributions, the CODE_COMBINATION_ID of the credit memo's REC account has to match the value of the Invoice's REC account.
AR_RAXTRX-1699You can have at most one Freight transaction line at either the line level or the invoice level, but not at both levels.If you need to create an invoice with Freight, ensure that you provide a FREIGHT line either at the RA_INTERFACE_LINES_ALL level or the RA_INTERFACE_DISTRIBUTIONS_ALL level and not both. If provided at the distribution level, each transaction can only have one freight distribution.
AR_RAXTRX-1706BFor each manual tax line, you must include either a tax code, or a combination of the tax regime, tax, tax status, tax jurisdiction, and tax rate code.For RA_INTERFACE_LINES_ALL.LINE_TYPE = 'TAX', check that you have provided either a tax code, or a combination of the tax regime, tax, tax status, tax jurisdiction, and tax rate code.

For details on how to pass Manual tax lines, please review Note 731149.1
AR_RAXTRX-1707Invalid memo line name (MEMO_LINE_NAME)Check that the value you have populated into MEMO_LINE_NAME exists in AR_MEMO_LINES.NAME
AR_RAXTRX-1708Invalid memo line id (MEMO_LINE_ID)Check that the value you have populated into MEMO_LINE_ID exists in AR_MEMO_LINES.MEMO_LINE_ID
AR_RAXTRX-1709The entered amount does not have the correct currency precisionCheck the precision of the value in RA_INTERFACE_LINES_ALL and RA_INTERFACE_DISTRIBUTIONS_ALL AMOUNT has a decimal precision that matches the currency's precision.
AR_RAXTRX-1710The supplied accounted amount does not match the amount calculated by AutoInvoice within the specified tolerance.Check the value in RA_INTERFACE_DISTRIBUTIONS.ACCTD_AMOUNT and verify if this value when rounded using the currency precision or the minimum accountable unit of the currency will still yield the same amount.
AR_RAXTRX-1711Invalid ledger id (SET_OF_BOOKS_ID)Check the value you passed in for SET_OF_BOOKS_ID and verify whether that is a valid value.

You can compare this value with manual transactions you create via the transactions form, see RA_CUSTOMER_TRX_ALL.SET_OF_BOOKS_ID
AR_RAXTRX-1713The supplied amount must match unit selling price times the quantity when you do not use an AutoInvoice Clearing account.Receivables uses the AutoInvoice clearing account to store any differences between the specified revenue amount and the price times the quantity for imported invoice lines.
Receivables only uses the AutoInvoice clearing account if you enabled the Create Clearing option for the batch source of your imported invoices; however, you must define a clearing
account in either case. You can select constant, customer
bill-to site, salesperson, transaction type, and standard item
values for your AutoInvoice clearing account. If you select
salesperson or standard item, the Revenue Flexfield that
you specified in the setup window is used.

Review your batch source definition, see Note 1068008.1 to check if you enabled Create Clearing. Also, check that the values you entered in RA_CUSTOMER_TRX_LINES_ALL for unit_selling_price * quantity = amount
AR_RAXTRX-1716You cannot supply payment terms for your credit memo transaction
Please review Note 1174094.1, AutoInvoice Error: You cannot supply payment terms for your credit memo transaction.
AR_RAXTRX-1717You cannot supply invoicing and accounting rules for your on account credit memo transactionYou cannot associate Accounting/Invoicing rules to On-Account credit memos, please review Note 1110573.1, Troubleshooting Credit Memos in Receivables
AR_RAXTRX-1720The Open Receivable flag of your credit memo must match the flag of the transaction you are creditingCheck the Open Receivables flag setting of the transaction type of the Credit Memo as well as the invoice it is crediting, both need to have the same setting. See Note 1090878.1, Troubleshooting Transaction Types In Oracle Receivables
AR_RAXTRX-1721You must supply unit of measure for transactions with itemsWhen RA_INTERFACE_LINES_ALL.INVENTORY_ITEM_ID is not null, a value has to be provided in UOM_CODE.
AR_RAXTRX-1722You must supply payment terms for your non-credit transactionReview Note 1171284.1, AutoInvoice Error: You Must Supply Payment Terms For Your Non-credit Transaction.
AR_RAXTRX-1728You must supply an accounting rule duration when you supply an accounting rule of type Variable Duration.When using a fixed duration rule, there is no need to populate ACCOUNTING_RULE_DURATION, to fix this you should null out the value in ACCOUNTING_RULE_DURATION.
AR_RAXTRX-1729The supplied unit of measure and the primary unit of measure of your system item must share the same unit of measure classThe RA_INTERFACE_LINES_ALL.UOM_CODE must exist in MTL_ITEM_UOMS_VIEW
AR_RAXTRX-1731You must supply the amount for this transactionRA_INTERFACE_LINES_ALL.AMOUNT has to be populated for FREIGHT or LINE records
AR_RAXTRX-1734Quantity, unit_selling_price, and amount must be null or zero for tax-only and freight-only linesIf RA_INTERFACE_LINES_ALL.LINE_TYPE is TAX or FREIGHT, then the following fields should be null or zero: AMOUNT, QUANTITY, UNIT_SELLING_PRICE
AR_RAXTRX-1735Accounting rule duration must be a positive integerCheck that RA_INTERFACE_LINES_ALL.ACCOUNTING_RULE_DURATION is not a negative number.
AR_RAXTRX-1740Invalid related document value (RELATED_TRX_NUMBER)Check the values populated in RA_INTERFACE_LINES.RELATED_BATCH_SOURCE_NAME and RELATED_TRX_NUMBER. Find the corresponding record in RA_CUSTOMER_TRX_ALL where TRX_NUMBER = RELATED_TRX_NUMBER, check the value in BATCH_SOURCE_ID and cross reference to RA_BATCH_SOURCES_ALL. The batch name of the related transaction's source has to match what was passed in RELATED_BATCH_SOURCE_NAME
AR_RAXTRX-1741Invalid related document id (RELATED_CUSTOMER_TRX_ID)Check the value in RA_INTERFACE_LINES_ALL.RELATED_CUSTOMER_TRX_ID, you should be able to locate a record in RA_CUSTOMER_TRX_ALL where CUSTOMER_TRX_ID = RELATED_CUSTOMER_TRX_ID
AR_RAXTRX-1742Duplicate invoice numberThe value in RA_INTERFACE_LINES_ALL.TRX_NUMBER has to be unique for the same BATCH_SOURCE_ID. Check if there already exists a row in RA_CUSTOMER_TRX_ALL or another row within the RA_INTERFACE_LINES_ALL table having the same BATCH_SOURCE_ID and TRX_NUMBER
AR_RAXTRX-1743Duplicate document numberThis error is raised when there exists a duplicate document number under a different request id, check the value in RA_INTERFACE_LINES_ALL.DOCUMENT_NUMBER.
AR_RAXTRX-1744You must enter a document number.You need to provide a value in RA_INTERFACE_LINES_ALL.DOCUMENT_NUMBER
AR_RAXTRX-1745The supplied accounted amount does not have the correct currency precisionCheck the value in RA_INTERFACE_DISTRIBUTIONS_ALL.ACCTD_AMOUNT and ensure the currency precision matches the definition for the currency code.
AR_RAXTRX-1746The two linked transactions must have the same ledger idThe Ledger ID of the transaction and the transaction it is linked to via REFERENCE* fields should match, check RA_INTERFACE_LINES_ALL.SET_OF_BOOKS_ID
AR_RAXTRX-1747The two linked transactions must have the same currency codeThe currency codes of the transaction and the transaction it is linked to via REFERENCE_* fields should match, check RA_INTERFACE_LINES_ALL.CURRENCY_CODE
AR_RAXTRX-1748The transaction to which you link this transaction must have the line type LINE.Check that the record pointed to by the values in LINK_TO_* fields has RA_CUSTOMER_TRX_LINES.LINE_TYPE = LINE
AR_RAXTRX-1749You cannot supply any transactions in a non-functional currency if you have not set up both realized gains account and realized losses accountCheck that you have setup the Realized Gain/Losses accounts in System Options.

Navigation: Setup > System > System Options (in Accounting tab)
AR_RAXTRX-1750You must either pass amounts for all the compound tax lines or not pass any amounts at allWhen supplying interface data for the AMOUNT of compounding taxes, you must supply for all TAX lines or not at all. If your supplied TAX lines is incomplete, it is better to just null out all the TAX amounts and have the tax engine calculate.
AR_RAXTRX-1753Conversion rate for the given date, currency code, ledger and conversion type has not been definedCheck the conversion rates table and ensure you have a record setup for the date, currency code, ledger and conversion type required.

Navigation: Setup > Financials > Accounting > Currencies > Rates > Daily
AR_RAXTRX-1756"This inventory item has Invoice Enabled flag set to No. Please set the Invoice Enabled flag in the Items window to Yes for this inventory item. "Check the setup of the Inventory Item to ensure that the Invoice Enabled flag is set to Yes, see Note 1069052.1, Setting Up AutoAccounting Rules In Receivables [Video]
AR_RAXTRX-1757The document sequencing feature is enabled, but no 'Automatic' document sequence exists within Oracle Receivables for this document category and date.The System Profile Option: Sequential Numbering is set to Always Used, but there is no Automatic Sequence defined. Please reviewNote 1086565.1,  How To Setup Document Sequences In Receivables
AR_RAXTRX-1761The supplied payment method must be defined and active for the bill-to customer or site.
  1. Check that the RECEIPT_METHOD_NAME or RECEIPT_METHOD_ID you provided is valid and active for your customer.
  2. If at the time of ship confirm in Order Management you did not provide a valid receipt method, a record will be created in RA_CUST_RECEIPT_METHODS with RECEIPT_METHOD_ID  = 0 and this record will be assigned to the customer account. When AutoInvoice attempts to process this record, the invalid receipt method causes the error to be raised.

    To avoid this, you need to enter a valid receipt method on the Order (Sales Order Form, Payments section) before shipping the order to ensure the correct receipt method is assigned to the customer.
AR_RAXTRX-1762Your transaction currency must match one of the currencies which are associated with the receipt method.Check the currencies associated to the banks used by the receipt method and ensure the currency you are passing is valid.
AR_RAXTRX-1763When 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 customerReview 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
AR_RAXTRX-1764The GL date of your invoice against a commitment cannot be prior to the GL date of the commitment itselfCheck the value in RA_INTERFACE_LINES_ALL.GL_DATE and cross-check against the Commitment's GL_DATE as referred to by the values in REFERENCE_* fields and ensure the Invoice's GL_DATE comes on or after the GL_DATE of the commitment.
AR_RAXTRX-1765The transaction date of your commitment invoice cannot be prior to the transaction date of the commitmentCheck the value in RA_INTERFACE_LINES_ALL.TRX_DATE and cross-check against the Commitment's TRX_DATE as referred to by the values in REFERENCE_* fields and ensure the Invoice's TRX_DATE comes on or after the TRX_DATE of the commitment.
AR_RAXTRX-1766The Last Period to Credit must be greater than 0 but less than the accounting rule duration of the invoice line you are creditingCheck the value in RA_INTERFACES_LINES_ALL.LAST_PERIOD_TO_CREDIT has to be a value between 1 and the total number of durations of the invoice being credited.
AR_RAXTRX-1767Unit credit memos can only be applied to invoices that use rulesNote 1110573.1, Troubleshooting Credit Memos in Receivables
AR_RAXTRX-1768You must supply a quantity to credit when passing Unit credit memosCheck the value in RA_INTERFACE_LINES_ALL.CREDIT_METHOD_FOR_ACCT_RULE is PRORATE, LIFO, UNIT
AR_RAXTRX-1770The GL date of your credit memo transaction cannot be prior to the GL date of the invoice it is creditingCheck the value in RA_INTERFACE_LINES_ALL.GL_DATE and cross-check against the Invoice's GL_DATE as referred to by the values in  REFERENCE_* fields and ensure the credit memo's GL_DATE comes on or after the GL_DATE of the invoice.
AR_RAXTRX-1771CM date cannot precede the date of the transaction being creditedCheck the value in RA_INTERFACE_LINES_ALL.TRX_DATE and cross-check against the Invoice's TRX_DATE as referred to by the values in  REFERENCE_* fields and ensure the credit memo's TRX_DATE comes on or after the TRX_DATE of the invoice.
AR_RAXTRX-1772The bill to customer of your credit memo transaction must be the same or related to the one of the invoice it is creditingPlease refer to troubleshooting details in Note 1089172.1
AR_RAXTRX-1773You cannot supply any account assignment for your credit memo transaction when the system option 'Use Invoice Accounting for Credit Memos' is YesPlease review details in Note 1110573.1, Troubleshooting Credit Memos in Receivables
AR_RAXTRX-1774The valid values for credit method for accounting rule are: PRORATE, LIFO and UNITPlease review details in Note 1110573.1, Troubleshooting Credit Memos in Receivables
AR_RAXTRX-1775The valid values for credit method for installments are: LIFO, FIFO and PRORATEPlease review details in Note 1110573.1, Troubleshooting Credit Memos in Receivables
AR_RAXTRX-1776The line type of your credit memo transaction must match the line type of the invoice line or debit memo line it is creditingCheck that the value in RA_INTERFACE_LINES_ALL.LINE_TYPE for the credit memo data, matches the value in RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE of the invoice or debit memo being credited as referred to by the values in REFERENCE_* fields.
AR_RAXTRX-1777The currency code of your credit memo transaction must match the currency code of the invoice line or debit memo line it is creditingCheck that the currency of the credit memo matches the currency of the invoice it is crediting.
AR_RAXTRX-1778You cannot supply territory flexfield data because the territory flexfield is not defined.Check that the territory flexfield is active and frozen. Please review details in Note 432817.1, Is The Territory Flexfield Required
AR_RAXTRX-1779Credit memo charges lines can only be applied to debit memo charges linesRecords with RA_INTERFACE_LINES_ALL.LINE_TYPE = CHARGES should have the REFERENCE_* fields pointing to a Debit Memo's record which also has LINE_TYPE = CHARGES.
AR_RAXTRX-1780You must supply the same transaction code as the one to which this transaction is linked.The value in RA_INTERFACE_LINES_ALL.USSGL_TRANSACTION_CODE has to match the value in the record pointed to by the LINK_TO* fields
AR_RAXTRX-1781You must supply a valid transaction code for this lineCheck that the value in USSGL_TRANSACTION code is valid.
AR_RAXTRX-1782You must define a period for this GL dateCheck that the GL_DATE you provided falls in a valid GL period. Please review details in Note 1069057.1, How To Manage Receivables Accounting Periods
AR_RAXTRX-1783"Please define all periods in which revenue is to be recognized or credited. Note that revenue cannot be recognized or credited in closed and close pending periods."Please refer to Note 455691.1, AutoInvoice & Transaction Workbench Error: Please Define All Periods In Which Revenue Is To Be Recognized Or Credited
AR_RAXTRX-1784Overlapping periods for the accounting rule and first GL date exist.Check the GL periods defined and ensure there are no overlapping dates. Please review details in Note 1069057.1, How To Manage Receivables Accounting Periods
AR_RAXTRX-1785You cannot supply a GL date if the Post To GL option for your transaction type is NoCheck the setup of the transaction type, see Note 1090878.1
and review value in Post to GL, you should not pass in a GL_DATE if this is not checked for your transaction type.
AR_RAXTRX-1791Unable to adjust your gl date which is in a closed period to a non-closed periodCheck your GL periods to ensure that there is at least one open period that comes after the GL_DATE you provided which happens to fall in a closed period.
AR_RAXTRX-1792Unable to derive a gl date for your transaction. Please ensure that your transaction is in a gl period which you have definedPlease refer to troubleshooting details in Note 1089172.1
AR_RAXTRX-1793You must set up AutoAccounting for AutoInvoice Clearing account if your batch source allows AutoInvoice clearingCheck that you have completed the AutoAccounting setup for AutoInvoice Clearing, please review details in Note 1069052.1, Setting Up AutoAccounting Rules In Receivables [Video]
AR_RAXTRX-1795Ensure that supplied rule start date will generate GL Dates that are in Open or Future periods when the GL Date in a Closed Period option is set to Reject in the Transaction Sources window.The code is unable to derive a GL Date, please review Note 201241.1, Troubleshooting AutoInvoice Date Derivation: GL Date, Invoice Date, Due Date, Ship Date, Billing Date, Rule Date
AR_RAXTRX-1796Invoice lines with the same document number have been separated by the grouping process, causing duplicate document numbersCheck the grouping rules you have defined, please review Note 1084554.1 and check why records with common document number values ended up getting split up into multiple invoices instead of being created as one invoice.
AR_RAXTRX-1797Transaction lines with the same transaction number have been separated by the grouping process, causing duplicate transaction numbersCheck the grouping rules you have defined, please review Note 1084554.1 and check why records with common transaction number values ended up getting split up into multiple invoices instead of being created as one invoice.
AR_RAXTRX-1800Cannot apply credit memo because invoice status is Incomplete.Check the status of the invoice referred to by the REFERENCE_* fields, you can only apply to it if it's COMPLETE_FLAG = Y
AR_RAXTRX-1801Cannot apply the credit memo because the invoice is locked by another user. Please try again later.Please refer to troubleshooting details in Note 1089172.1
AR_RAXTRX-1802The tax line of the credit memo does not have a link to the invoice.The credit memo's tax line is not properly linked to the invoice's tax line.

Note 1286966.1, AutoInvoice Error: The tax line of the credit memo does not have a link to the invoice.
AR_RAXTRX-1810All of the transactions in a single group must be for the same Bill-to Customer.Check the value in RA_INTERFACE_LINES_ALL.CONS_BILLING_NUMBER and ensure that rows having identical values all have the same value in  ORIG_SYSTEM_BILL_CUSTOMER_ID
AR_RAXTRX-1811The Imported Billing Number you entered already exists in the system. Please enter a unique Imported Billing Number.Check the value in RA_INTERFACE_LINES_ALL.CONS_BILLING_NUMBER and ensure that it does not yet exist in AR_CONS_INV_ALL or another record in the interface table
AR_RAXTRX-1812All of the transactions in a single group must be for the same Bill-to address.Check the value in RA_INTERFACE_LINES_ALL.CONS_BILLING_NUMBER and ensure that rows having identical values all have the same value in ORIG_SYSTEM_BILL_ADDRESS_ID
AR_RAXTRX-1813Consolidated billing is enabled for this customer or bill-to site, therefore you cannot import bills.You can only import a value in RA_INTERFACE_LINES_ALL.CONS_BILLING_NUMBER if the Bill Type is Imported. Please review details in Note 761180.1
AR_RAXTRX-1814Customer or Bill-to must be enabled to import billing number.Ensure that the customer is consolidated billing (for Release 11.5) or balance forward billing enabled (for Release 12).
AR_RAXTRX-1815"The distributions for this transaction are in the functional currency, but the entered amount does not equal the accounted amount. Please recalculate the accounted amount for this transaction and resubmit AutoInvoice."Check the values in RA_INTERFACE_DISTRIBUTIONS.AMOUNT and ACCTD_AMOUNT, these values should match if transaction is in the functional currency
AR_RAXTRX-1816The payment set ID is invalid because it was not generated by the Receipt APIThe value provided in RA_INTERFACE_LINES_ALL.PAYMENT_SET_ID must exist in AR_RECEIVABLE_APPLICATIONS_ALL.PAYMENT_SET_ID
AR_RAXTRX-1817Only invoices can be associated with a payment set ID. Please remove the ID associated with this transaction.The transaction type associated to the record for which you have provided a PAYMENT_SET_ID value must have type = INV
AR_RAXTRX-1819Please review all invoices that share this invoice's consolidated billing number and correct any errors before resubmitting AutoInvoice.There are other interface records that have already been tagged with errors that have the same value in CONS_BILLING_NUMBER as this row, you are advised to review these records prior to re-running AutoInvoice.
AR_RAXTRX-1820Please do not supply a GL date when the invoicing rule is Bill in Arrears.If INVOICING_RULE_ID = -3 you should not provide a GL_DATE
AR_RAXTRX-1821You cannot create a nonpostable credit memo against a postable invoice.Check the setup of the transaction type, see Note 1090878.1
and review value in Post to GL, the value for the setup at the credit memo should match the setup of the invoice it is crediting.
AR_RAXTRX-1827Others exception occured in Tax Accounting routine during Adjustment/Application Accounting. Please contact oracle support.An unhandled exception has been raised in the tax engine. To help pinpoint cause of error provide a tax debug log using review Note 417238.1 How to obtain debug logfile for R12 E-Business Tax

Also review Note 1215245.1, AutoInvoice Error: Others exception occured in Tax Accounting routine during Adjustment/Application Accounting.
AR_RAXTRX_BAD_ACC_CLASSThe accounting distributions for this transaction are linked to the wrong type of line.Check the value in RA_INTERFACE_DISTRIBUTIONS_ALL.ACCOUNT_CLASS synchronize to the values of RA_INTERFACE_LINES_ALL.LINE_TYPE
AR_RAXTRX_CONV_CMReceivables automatically converted this credit memo to euro. The next time you run AutoInvoice, Receivables will import this as an on-account credit.Interface data was using a currency that has since been replaced by EURO. The currency code will be overridden with EUR.
AR_RAXTRX_DUPLICATE_CM_LINESeparate lines on the same credit memo cannot credit an invoice line more than onceYou are attempting to credit an invoice multiple times via the same credit memo. Please review Note 1322932.1.
AR_RAXTRX_INV_INCL_FLAG_CODEThe Tax Code does not allow override of the amount includes tax flag.You cannot set AMOUNT_INCLUDES_TAX_FLAG to a value that contradicts the setup in AR_VAT_TAX.AMOUNT_INCLUDE_TAX_FLAG for the TAX_CODE used
AR_RAXTRX_INV_INCL_FLAG_GRPYou cannot set the amount includes tax flag when using a Tax Group.You cannot set AMOUNT_INCLUDES_TAX_FLAG if using a Tax group.
AR_RAXTRX_INV_INCL_FLAG_MANYou cannot import manual tax lines with tax inclusive amounts.Importing Manual tax lines is not allowed if tax code is for Inclusive tax
AR_RAXTRX_INV_WAREHOUSEInvalid Warehouse ID (WAREHOUSE_ID)Please review details in Note 1089026.1, AutoInvoice Error: Invalid Warehouse Id (Warehouse_id) (xxx)
AR_RAXTRX_INVAL_EXEMPTYou can enter E (exempt) in the tax_exempt_flag column only if a value exists in the tax_exempt_number column and the eBTax Product Options allow override of customer exemptions.Check the value in TAX_EXEMPT_FLAG_COLUMN.

Also verify the following setup:
Responsibility: Tax Managers
Navigation: Defaults and Controls > Application Tax Options

1. Search for Application name = Receivables, Click Go
2. Select the appropriate Operating Unit from the retrieved list,  and click on the Update icon.
3. In the Others section, ensure the check box Allow Override and Entry of Customer Exemptions is checked.
4. Apply
AR_RAXTRX_LINE_OVERAPPA credit memo is attempting to overapply a specific transaction line, but overapplication is not allowed.You are attempting to credit an invoice such that the balance of the invoice switches signs from the original amount. Please review details in Note 1110573.1, Troubleshooting Credit Memos in Receivables
AR_RAXTRX_OPEN_DEPOSITPlease complete the deposit or guarantee for this line and run the AutoInvoice process again.Check that COMPLETE_FLAG = Y for the commitment/deposit referenced by the values in REFERENCE_*
AR_RAXTRX_PROFILE_ERRYou must assign a value to the &PROFILE profile option.Generic error when System Profile options are not setup and a value is required.
AR_RAXTRX_PROFILE_WARNYou have not assigned a value for &PROFILE profile option. The default value will be used.Generic warning when System Profile options are not setup and default value will be used instead.
AR_RAXTRX_REJECTED_INVThe related invoice has validation errors.Generic error raised when the record referred to by REFERENCE_* values has validation errors as listed in RA_INTERFACE_ERRORS_ALL
AR_RAXTRX_RSD_LT_REDA rule's end date cannot precede its start date.Check that the RULE_END_DATE comes after the RULE_START_DATE
AR_RAXTRX_RULE_END_DATE_VALA rule end date is required when using the Daily Revenue Rate rule.When using an Accounting rule associated with Daily Revenue Rate, you need to provide a value in RULE_END_DATE
AR_RAXTRX_RULE_START_DT_NULLA rule start date is required when using the Daily Revenue Rate rule.When using an Accounting rule associated with Daily Revenue Rate, you need to provide a value in RULE_START_DATE
AR_RAXTRX_UNIT_OVERAPPPlease enter a unit selling price for this credit line that is less than the unit selling price for its target invoice line.When crediting an invoice, the UNIT_SELLING_PRICE for the credit memo records cannot exceed the unit selling price of the invoice. Check the UNIT_SELLING_PRICE in the invoice you are crediting and ensure that the credit amount does not exceed it.

Please review Note 1145259.1
AR_RAXTRX_ZERO_VS_COMMITYou cannot import this invoice because the invoice amount that is allocated to the specified commitment is zero.Check the AMOUNT associated with the invoice being drawn against a commitment and ensure it is more than zero.
AR_TAPI_BFB_INVALID_TERMPayment terms defined with a billing cycle cannot be used for customers who are not set up for balance forward billing.Originally, Balance Forward Payment terms could only be used by Balance Forward enabled customers. Code changes were made to lift this restriction and patches are required to get the new behavior.

Please review the following notes:
Note 1052906.1, How to implement payment terms with cutoff days in R12

Note 1152723.1, AutoInvoice Error: Payment terms defined with a billing cycle cannot be used for customers who are not set up for balance forward billing.
C-1500Error calling &FUNC_NAMEGeneric error message raised during any failure from a function.
C-1501Failed to allocate memory for &VAR_NAMEGeneric error message raised for memroy issues.
C-1502&VAR_NAME should be &VALUEGeneric error message raised for invalid values.
C-1503Invalid argument - &VAR_NAMEGeneric error message raised for invalid values.
C-1504Null &VAR_NAMEGeneric error message raised for invalid values.
C-1505Batch source is not definedNote 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice
C-1506Ledger is not set upThere is no record setup in GL_SET_OF_BOOKS for the SET_OF_BOOKS_ID in AR_SYSTEM_PARAMETERS_ALL
C-1507VARCHAR for &VAR_NAME is not long enoughGeneric error when string value is not long enough
C-1511The given piece memory is not large enough to hold a single rowGeneric error when memory cannot accomodate data
C-1512Please increase the value for the profile option 'AutoInvoice: Maximum Memory (in bytes)'Note 1083467.1, How To Setup AutoInvoice For Optimal Performance
C-1550Request &REQUEST_ID completed with errorGeneric error when a Request completes in error
C-1551Request &REQUEST_ID deletedGeneric error when a Request is deleted
C-1552Request &REQUEST_ID has an unknown statusGeneric error when a Request has undetermined status
C-1553Request &REQUEST_ID could not be foundGeneric error when a Request cannot be found
C-1580Detail posting has been disabled for your Accounting FlexfieldCheck the setup General Ledger setup for the GL account to validate if posting in Detail is allowed
C-1581Invalid extra column nameGeneric error regarding a invalid column
C-1582Invalid segment name - &SEGMENTGeneric error regarding a flexfield segment
C-1583You cannot create this &FLEXNAME because dynamic insertion has been disabledGeneric error when Accounting Flexfield cannot be created since Dynamic Insertion is not allowed.
C-1584Zero row in the main cache is not allowedGeneric error in main cache
C-1585The value of &VAR_NAME is too large for this operating systemGeneric error when string is too large for variable to accomodate
C-1586You must supply an unique id for your &FLEXNAMEGeneric error regarding flexfield ID
C-1587Cross validation for your key flexfield failedGeneric error when GL account cross validation fails
C-1589You cannot supply a blank &FLEXNAMEGeneric error for Flexfield name
C-1590The supplied &FLEXNAME has been disabledGeneric error when flexfield referenced is inactive
C-1591The supplied &FLEXNAME has expiredGeneric error when flexfield referenced is end-dated
C-1593Invalid &FLEXNAMEGeneric error when flexfield name is invalid
C-1594You cannot supply summary account for your Accounting FlexfieldCheck the setup General Ledger setup for the GL account to validate if posting in Summary is allowed
C-1600Invalid sold to customer reference (ORIG_SYSTEM_SOLD_CUSTOMER_REF)Please refer to troubleshooting details in Note 1089172.1
C-1601Invalid sold to customer id (ORIG_SYSTEM_SOLD_CUSTOMER_ID)Please refer to troubleshooting details in Note 1089172.1
C-1602Invalid bill to customer reference (ORIG_SYSTEM_BILL_CUSTOMER_REF)Please refer to troubleshooting details in Note 1089172.1
C-1603Invalid bill to customer id (ORIG_SYSTEM_BILL_CUSTOMER_ID)Please refer to troubleshooting details in Note 1089172.1
C-1604The Bill To address reference must exist in Oracle Receivables, and it must be assigned to the Bill To customer (ORIG_SYSTEM_BILL_ADDRESS_REF)Please refer to troubleshooting details in Note 1089172.1
C-1605The Bill To address id must exist in Oracle Receivables, and it must be assigned to the Bill To customer (ORIG_SYSTEM_BILL_ADDRESS_ID)Please refer to troubleshooting details in Note 1089172.1
C-1606The Bill To contact reference must exist in Oracle Receivables, and it must be assigned to the Bill To customer (ORIG_SYSTEM_BILL_CONTACT_REF)Please refer to troubleshooting details in Note 1089172.1
C-1607The Bill To contact id must exist in Oracle Receivables, and it must be assigned to the Bill To customer (ORIG_SYSTEM_BILL_CONTACT_ID)Please refer to troubleshooting details in Note 1089172.1
C-1608Invalid ship to customer reference (ORIG_SYSTEM_SHIP_CUSTOMER_REF)Please refer to troubleshooting details in Note 1089172.1
C-1609Invalid ship to customer id (ORIG_SYSTEM_SHIP_CUSTOMER_ID)Please refer to troubleshooting details in Note 1089172.1
C-1610The supplied ship to address reference must exist in Oracle Receivables, and it must agree with the supplied ship to customer (ORIG_SYSTEM_SHIP_ADDRESS_REF)Please refer to troubleshooting details in Note 1089172.1
C-1611The supplied ship to address id must exist in Oracle Receivables, and it must agree with the supplied ship to customer (ORIG_SYSTEM_SHIP_ADDRESS_ID)Please refer to troubleshooting details in Note 1089172.1
C-1612The supplied ship to contact reference must exist in Oracle Receivables, and it must agree with the supplied ship to customer (ORIG_SYSTEM_SHIP_CONTACT_REF)Please refer to troubleshooting details in Note 1089172.1
C-1613The supplied ship to contact id must exist in Oracle Receivables, and it must agree with the supplied ship to customer (ORIG_SYSTEM_SHIP_CONTACT_ID)Please refer to troubleshooting details in Note 1089172.1
C-1630Invalid transaction type name (CUST_TRX_TYPE_NAME)Please refer to troubleshooting details in Note 1089172.1
C-1631Invalid transaction type id (CUST_TRX_TYPE_ID)Please refer to troubleshooting details in Note 1089172.1
C-1634Invalid primary salesrep number (PRIMARY_SALESREP_NUMBER)Please refer to troubleshooting details in Note 1089172.1
C-1635Invalid primary salesrep id (PRIMARY_SALESREP_ID)Check RA_INTERFACE_LINES_ALL.PRIMARY_SALESREP_ID is not null
C-1636Invalid invoicing rule name (INVOICING_RULE_NAME)Check whether you have set Id or Value for Invoicing Rule in your Batch Source, for details review Note 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice (review settings in Accounting Information tab)

Check that the value provided exists in RA_RULES.NAME
C-1637Invalid invoicing rule id (INVOICING_RULE_ID)Check whether you have set Id or Value for Invoicing Rule in your Batch Source, for details review Note 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice (review setting in Accounting Information tab)

Check that the value provided exists in RA_RULES.RULE_ID
C-1638Invalid payment terms name (TERM_NAME)Check whether you have set Id or Value for Payment Terms in your Batch Source, for details review Note 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice (review setting in Accounting Information tab)

Check that the value provided exists in RA_TERMS.NAME
C-1639Invalid payment terms id (TERM_ID)Check whether you have set Id or Value for Payment Terms in your Batch Source, for details review Note 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice (review setting in Accounting Information tab)

Check that the value provide exists in RA_TERMS.TERM_ID
C-1640Invalid unit of measure name (UOM_NAME)Check whether you have set Id or Value for Unit of Measure in your Batch Source, for details review Note 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice (review setting in Other Information tab)

Check that the value provided exists in MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE
C-1641Invalid unit of measure code (UOM_CODE)Check whether you have set Id or Value for Unit of Measure in your Batch Source, for details review Note 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice (review setting in Other Information tab)

Check that the value provided exists in MTL_UNITS_OF_MEASURE.UOM_CODE
C-1642Invalid agreement name (AGREEMENT_NAME)Check whether you have set Id or Value for Agreement in your Batch Source, for details review Note 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice (review setting in Other Information tab)

Check that the value provided exists in SO_AGREEMENTS.NAME
C-1643Invalid agreement id (AGREEMENT_ID)Check whether you have set Id or Value for Agreement in your Batch Source, for details review Note 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice (review setting in Other Information tab)

Check that the value provided exists in SO_AGREEMENTS.AGREEMENT_ID
C-1644Invalid accounting rule name (ACCOUNTING_RULE_NAME)Check whether you have set Id or Value for Accounting Rule in your Batch Source, for details review Note 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice (review setting in Accounting Information tab)

Check that the value provided exists in RA_RULES.NAME for TYPE = 'I'
C-1645Invalid accounting rule id (ACCOUNTING_RULE_ID)Check whether you have set Id or Value for Accounting Rule in your Batch Source, for details review Note 1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice (review setting in Accounting Information tab)

Check that the value provided exists in RA_RULES.RULE_ID for TYPE = 'I'
C-1647Invalid line type (LINE_TYPE)Check that the value in RA_INTERFACE_LINES_ALL.LINE_TYPE is one of the following:'LINE', 'TAX', 'FREIGHT', 'CHARGES'
C-1648Invalid printing option (PRINTING_OPTION)Check that the value in RA_INTERFACE_LINES_ALL.PRINTING_OPTION exists as a LOOKUP_CODE in AR_LOOKUPS for LOOKUP_TYPE = 'INVOICE_PRINT_OPTIONS'
C-1649You cannot supply freight charges when the Allow Freight option for your transaction type is No.Please review details in Note 1096942.1
C-1650Invalid FOB point (FOB_POINT).Check that the value in RA_INTERFACE_LINES_ALL.FOB_POINT exists as a LOOKUP_CODE in AR_LOOKUPS for LOOKUP_TYPE = 'FOB'
C-1651Invalid ship via (SHIP_VIA)Check that the value you populated into RA_INTERFACE_LINES_ALL.SHIP_VIA exists in ORG_FREIGHT.FREIGHT_CODE for the organization id you are using.

See also Note 274785.1 for a consolidated listing of causes/solutions
C-1652The supplied gl date is in a closed periodCheck the GL_DATE you provided and validate its status using Open/Close Accounting periods form, please review details in Note 1069057.1
C-1653Invalid currency code (CURRENCY_CODE)Check that the value you populated into RA_INTERFACE_LINES_ALL.CURRENCY_CODE exists in FND_CURRENCIES.CURRENCY_CODE
C-1654Invalid conversion type (CONVERSION_TYPE)Check that the value you populated into RA_INTERFACE_LINES_ALL.CONVERSION_TYPE exists in GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE
IBY_INVALID_XTENSION_ATTRIBA transaction attribute has an invalid value for its type, or a mandatory parameter is NULLPossible Cause: Mandatory Security Code is missing.

It is possible that in the past, the security code was not defined as mandatory, and the interface data was created at that time. However, during import of data the setup has changed such that security code is now mandatory. A workaround is to temporarily set it to not required so you can interface the old data successfully.

Responsibility: Payments Setup Administrator
Navigate:  Oracle Payments Setup > System Security Options


1) In the section Credit Card Owner Verification Control, set the value of Require Security Code Entry to "No" and save the changes.
2) Re-process the interface data
3) After successful processing, re-set the Require Security Code Entry to "Yes"
IBY_INVALID_XTENSION_GROUPExtensions in the copy group do not have the same values for payment channel, instrument assignment.Note 1176555.1, Autoinvoice Error: Extensions in the copy group do not have the same values for payment channel, instrument assignment.
JL_BR_AR_RAXTRX_FED_TR_SIT_INVPlease enter a valid Federal Tributary Situation for the transaction line.This error can be raised in an environment that uses a Brazilian consultation feature, because the code is passing a 3-digit value, whereas only 2-digits is expected.

A fix was implemented via Bug 8304334SPED REQUEST - FIELD CST MUST BE FILLED ON AR INTERFACE WITH JUST TWO DIGITS

Please apply Patch 8465589.
JL_BR_AR_RAXTRX_STA_TR_SIT_INVPlease enter a valid State Tributary Situation for the transaction line.This error can be raised in an environment that uses a Brazilian consultation feature, because the code is passing a 3-digit value, whereas only 2-digits is expected.

A fix was implemented via Bug 8304334SPED REQUEST - FIELD CST MUST BE FILLED ON AR INTERFACE WITH JUST TWO DIGITS

Please apply Patch 8465589.
ZX_REL_DOC_MISSINGRelated document information is missing in our ZX repository.Note 1288642.1, AutoInvoice Error: Related document information is missing in our ZX repository
ZX_PARTY_NOT_EXISTSA Party Tax Profile does not exist for this Party.Note 1338428.1, Autoinvoice Error: A Party Tax Profile Does Not Exist For This Party.