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 14, 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

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