Auto application of Credit Note to Invoice Using AutoInvoice

When Creating a Credit note by Auto Invoice import Oracle provides the option of auto application of a Credit Note to an invoice i.e. When you are creating a credit note as soon as a credit note is created it will be immediately applied to an AR invoice.
This functionality can be used by by populating the reference_line_attribute columns of ra_interface_lines_all tables By populating the reference line_id or the combination of reference line_context and reference line attributes which correspond to a given AR invoice line you can apply the CM line being created to an existing Invoice.
Ensure that the CM line which you want to apply has an amount less than or equal to the invoice line open amount else you will get an error by Auto Invoice if over application is not enabled.
This is an efficient way of Creating credit notes and also applying them to Open invoices/Debit notes in the system if the information of application is available beforehand

AutoInvoice Import Error : Tax lines with the same Tax Regime and Tax cannot be allocated to the same transaction line more than once.

When importing invoices via the AR Interfaces , in cases where 1 invoice line is associated to multiple tax lines Oracle can throw an error : Tax lines with the same Tax Regime and Tax cannot be allocated to the same transaction line more than once if the TAX setup is incorrect.

For 1 invoice lines we will be having 2 or more tax lines each having its own tax_rate_codes.

For each of these tax rates we cannot have the same combination of regime and Tax. Multiple tax allocations is only possible if tax lines belong to combination of different regimes and tax.

In case of such an issue the TAX setups need to be checked and corrective measures need to be taken

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 up for the Bill To customer

When importing an invoice via the AutoInvoice Import Program we can get an error message : 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 customer

This error occurs when the Invoice line in AR Interface has a receipt method id , but on the Customer Bill TO for which we wish to import the record there is no active bank record present.
If an Automatic receipt method is specified then the Customer BILL TO  needs to have an active bank account else this error will be thrown.

SQL :
select hcsu.location,ieb.bank_account_name,ieb.bank_account_num,hps.party_site_number
from apps.hz_cust_site_uses_all hcsu,
     apps.iby_external_payers_all iep,
     apps.iby_pmt_instr_uses_all pmt,
     apps.iby_ext_bank_accounts ieb,
     apps.hz_cust_acct_sites_All hcas,
     apps.hz_party_sites hps
where hcsu.site_use_id = iep.ACCT_SITE_USE_ID
and hcsu.org_id = iep.org_id
and iep.ext_payer_id = pmt.ext_pmt_party_id
and pmt.instrument_id = ieb.ext_bank_account_id
and hcsu.site_use_code = 'BILL_TO'
and hcsu.cust_acct_site_id = hcas.cust_Acct_site_id
and hcas.party_site_id = hps.party_site_id
and hcsu.org_id = hcas.org_id
and pmt.payment_function = 'CUSTOMER_PAYMENT'
order by 1

Auto Invoice Error : Invalid Value of Conversion Type (CONVERSION_TYPE)

When we run the Auto Invoice Import Program the record errors out with the details Invalid Value of Conversion Type (CONVERSION_TYPE).
This Error occurs because of the below reason :

1. The Conversion Type Specified is not defined in the system
2. Some times the user by mistake updates the value of USER_CONVERSION_TYPE of the table : GL_DAILY_CONVERSION_TYPES where as the value needs to be picked from the field CONVERSION_TYPE.