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

Last updated on MARCH 15, 2022

Applies to:

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

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