My Oracle Support Banner

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 SEPTEMBER 29, 2023

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.