AutoInvoice Error: Import Credit Memos With Taxes in a Sabrix Instance Fails With: Others exception occured in Tax Accounting routine during Adjustment/Application Accounting

(Doc ID 1471646.1)

Last updated on FEBRUARY 22, 2018

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.


Running Autoinvoice for an RMA against the existing Sales order also fails with exception:

1) Others exception occured in Tax Accounting routine during Adjustment/Application Accounting. Please contact oracle support. (109879)
2) The tax line of the credit memo does not have a link to the invoice.

Sabrix is being used for tax calculation.

Responsibility: Receivables Manager
Navigation: Transaction > Transactions

FND debug log shows:

ar.plsql.ARP_BALANCE_CHK.Check_Transaction_Balance .begin 2
ARP_BALANCE_CHK.Check_Transaction_Balance (+)
ar.plsql.ARP_BALANCE_CHK.Check_Transaction_Balance 1 GL_DATE : 06-JUN-2012
ar.plsql.ARP_BALANCE_CHK.Check_Transaction_Balance 1 Net Amount :1400
ar.plsql.ARP_BALANCE_CHK.Check_Transaction_Balance 1 Net Acctd Amount :1400
ar.plsql.ARP_BALANCE_CHK.Check_Transaction_Balance 1
ARP_BALANCE_CHK.Check_Transaction_Balance - OUT_OF_BALANCE
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log 4 This action has been
blocked to avoid inaccurate accounting entries. Please contact Oracle  Support Services
ar.plsql.arp_process_header.post_commit 4 EXCEPTION:


Applied following latest code however error still persists:
12702898:R12.AR.B - R12 Receivables Rollup Patch Collection July2011
13806880:R12.AR.B - ARP_CREDIT_MEMO_MODULE/ARTECMMB.pls/120.59.12010000.26
13081505:R12.AR.B - ARP_AUTO_RULE /ARPLARLB.pls/120.45.12010000.10
13880410:R12.AR.B - ARP_DET_DIST_PKG/ARPDDB.pls/120.57.12010000.94
12684247:R12.AR.B - ARP_REVENUE_ASSIGNMENTS/ARREVUB.pls/120.4.12010000.4
Exception occurs only when creating credit memo against the invoice and not on-account credit memo.

By setting the profiles AR: Enable Journal Balance Check = Yes, AR: Use Invoice Accounting For Credit Memos = No, the credit memo is created against the invoice with out errors, however the data is generated incorrectly.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms