R12: Consolidated Code Fix for Invoice Discard/Cancel Issues (Root cause fix for 1060611.1) (Doc ID 1336437.1)

Last updated on SEPTEMBER 16, 2024

Applies to:

Symptoms

Release 12 patch 9661290 is a consolidated patch addressing several Invoice discard/cancellation issues. It contains most known root cause fixes corresponding to Generic Data Fix <Note 1060611.1>

Patch 9661290 addresses the following code bugs:

• 9178329: Invoice cancelation event is generating reverse distributions whose base amount is not reversing the base amount of parent distribution.
  
  
• 9034405: When an invoice line is created by copying a discarded line and distributions are generated, it is not possible to cancel the invoice. Invoice cancelation is stuck in dist variance hold.
  
  
• 9241090: User can save foreign currency invoice without entering Rate type. If user cancels the invoice after saving, the invoice is put on NO RATE hold. Since the AutoRate program updates invoices based on exchange rate and rate type, the invoice would be stuck in cancellation and cannot be process from the application. This happens only if Payables Option 'Require Exchange Rate entry' is enabled. When option is enabled the Rate type field is mandatory.
  
  
• 9345786: (replacement 9508004:R12.AP.A) Discard Invoice line creates reversals with line GL_date even though the distribution GL date is greater than the line GL date.
  
  
• 9267945: AWT Distributions not reversed while cancelling upgraded (from 11i) invoices.
  
  
• 9702328: Withholding Tax not reversed during cancellation.
  
  
• 9068689: Once the accounting for distributions of a non-tax and non-AWT line is done, if user makes any changes in the system such that there is any impact on the calculation of inclusive tax on that line, then the distribution amount of posted distribution gets updated and it causes issue in accounting.
  
  
• 8733916: Addresses several BC event issues:
1. Whenever discard/reverse/cancel of an invoice with unprocessed bc_events, encumbered_flag is set to 'R' without deleting the bc_events.
2. Orphan bc_events are getting created with encumbered_flag as 'R' and bc_event_id present.
3. Orphan events are getting created with bc_event present and with no data in xla events.
4. Charge line like freight, misc, tax lines are not updated with encumbered flag as 'R' even when the ITEM line corresponding to is set to 'R'.
   
   
• 9231678: Amount and base amount in ap_invoice_distributions_all have different sign.
  
  
• 8879593: Unable to CANCEL / REVERSE PO matched invoice that is corrected against itself using the Corrections function. On canceling invoice error is "Invoice cannot be adjusted or canceled, even if you discard the Correction Lines from the invoice" is thrown.
  
  
• 8925277: User is able to create manual tax distributions in tax line. This causes difference in AP and eBTax repository which in turn causes cancellation issues including others problems.
  
  
• 9570774: Quantity Invoiced for the invoice lines is not set to ZERO when invoice is canceled.
  
  
• 8599985: Quantity Invoiced for the invoice lines is not set to ZERO if the matched line is discarded.
  
  
• 9729201: After calculating tax on MISC or FREIGHT lines, when user deletes these lines, the corresponding tax is not reverted/recalculated. This causes Distribution Variance hold on invoice validation/cancellation.
  
  
• 9021265: Implement cross checks at crucial hand shake points with eBTax
  
  
• 9244765: Inclusive tax lines in eBTax are not getting cancelled when tax distributions do not exist while cancelling invoice. This causes wrong Total_Tax_amount in cancelled invoice.
  
  
• 9034372: Not able to cancel quick credited credit memo invoice which has tax lines.
  
  
• 8481532: In case there is 100% tax rate variance (tax on invoice and no tax on PO) then for a matched item line if TRV is computed on discarding such item line and rematching causes a extra -ve non recoverable TAX to de generated. This makes invoice impossible to validate by putting it on distribution variance hold.
  
  
• 8411165: Amount Paid is not being set to 0 after canceling the Complex-PO matched invoice.
  
  
• 7569660: When you discard a tax inclusive invoice line after it has been accounted the system generates the reversal on the line item to be the total amount of the line in addition to also reversing the tax line. It also changes the already accounted line distribution within AP.
  
  
• 7568031: Manual AWT lines get discarded (line amount is set 0) but the distribution of that line do not get reversed.
  
  
• 6815172: Invoice cancellation is not reverting recoverable tax line in case of inclusive tax.

Changes

N.A.

Cause

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