My Oracle Support Banner

Unapply an Invoice with Tax Line From a No-Tax On-Account Credit Memo Creates Tax Amount on the Credit Memo (Doc ID 1930903.1)

Last updated on FEBRUARY 24, 2021

Applies to:

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


There is tax amount after adjusting a credit memo that has 0 defined in the Invoice Type Adjustment.

You unapply an Invoice with Tax line from a No-Tax On-Account Credit memo and find the credit memo ends up with tax amount.
The payment schedules gets corrupted.
The credit memos should not have a TAX balance if the credit memo itself never had tax and has no tax distributions.

This results in error when attempt to adjust credit memo balance to zero:

APP-AR-11526: arp_process_adjustment.insert_adjustment exception: ORA-20001:
A cash application is being made against a transaction with zero line amount basis, please contact Oracle Support.

The activity GL account does not meet your requirements - it has to be the revenue on the credit memo since it has 0 tax distributions, this should not be a problem.

FND Debug:
Exception when calling AR_ADJUST_PUB:
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines.begin 2 ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()+
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 1 EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Accounting_Lines:ORA-01400: cannot insert NULL into ("AR"."AR_DISTRIBUTIONS_ALL"."CODE_COMBINATION_ID")
ar.plsql.ar_process_adjustment.insert_adjustment 4 EXCEPTION: ar_process_adjustment.insert_adjustment()


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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