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 JULY 30, 2018

Applies to:

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

Symptoms

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()

Changes

 

Cause

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


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