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 JUNE 05, 2024

Applies to:

Symptoms

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
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:
arp_process_header.post_commit()

Changes

Applied following latest code however error still persists:
 
12958998:R12.AR.B  
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.

Cause

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