My Oracle Support Banner

Written Off Transactions Are not Marked Correctly in po_accrual_reconcile_temps_all (Doc ID 2646494.1)

Last updated on MARCH 06, 2020

Applies to:

Oracle Purchasing - Version 11.5.10 and later
Information in this document applies to any platform.

Symptoms

 Upgrade from 11.5.8 to 11.5.10
The following query yields different results in the 11.5.8 and 11.5.10 environments.
select invoice_num, invoice_line_num, write_off_flag, write_off_id, program_update_date
from po_accrual_reconcile_temp_all where invoice_num = '6308' order by invoice_num, invoice_line_num

11.5.8

INVOICE_NUM INVOICE_LINE_NUM W WRITE_OFF_ID PROGRAM_U
-------------------- ---------------- - ------------ --------
6308 1 Y 493 13-OCT-04
6308 3 Y 492 13-OCT-04

11.5.10

INVOICE_NUM INVOICE_LINE_NUM W WRITE_OFF_ID PROGRAM_U
-------------------- ---------------- - ------------ --------
6308 1 Y 493 13-JUL-05
6308 3 N      13-JUL-05

This is happening for all transactions that were written off prior to the upgrade where the transaction
picked up for reconciliation from ap_invoice_distributions_all has a quantity_invoiced less than zero.
It is a difference in how the rebuild is handling these transactions when determining the transaction_quantity.

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
  
References

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