My Oracle Support Banner

R12: AP: Unable to Cancel Invoice with Tax Error Due to System Failed to Generate Correct Reversals (Doc ID 2260417.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

An invoice has a tax error and cannot be cancelled.

When attempting to cancel an invoice, a pop up window appears stating to redo the cancel/discard process with FND Debug Log turned on and to log a SR.

The Invoice Analyzer of the invoice shows tax distributions records with NULL line numbers.

The Master GDF Analyzer identifies data corruption signature ID 171: Tax distributions which have a null invoice_line_number.

Steps to reproduce - Try to cancel the invoice:

  1. Log into Oracle Applications using a Payables responsiblity
  2. Open the Invoice Workbench
    (N) Invoice > Entry > Invoices
  3. Query Invoice in Invoice Workbench
  4. Click on [Actions]
  5. Select/Check "Cancel" and [OK]
  6. A pop up Note window appears with the following message 
    Note: Please redo cancel/discard with fndlog on and log a SR to resolve the issue, as system has failed to generate correct reversals for following distributions : (REASON= ,42656770)

      

Instead of trying to cancel the invoice, If the invoice is paid and user tries to Create Accounting for the payment; two(2) extra Liability lines are generated with No GL Account (CCID) and the following error is listed:

This line cannot be accounted until the accounting event for the application Payables that it references has been fully accounted.

 

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
Cause
Solution
 CODE-FIX
 DATA-FIX

References


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