AutoInvoice Error: Import Credit Memos With Taxes in a Sabrix Instance Fails With: Others exception occured in Tax Accounting routine during Adjustment/Application Accounting
Last updated on SEPTEMBER 20, 2016
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.
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