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
- Query invoice in question.
- Access toolbar Menu: Actions > Credit
- Credit balance and save, gives error :
- This action has been blocked to avoid inaccurate accounting entries.
FND debug log shows:
ar.plsql.ARP_BALANCE_CHK.Check_Transaction_Balance .begin 2
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
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