SIMPLE Invoices are not getting purged
Hello Dev Team,
SR 3-9978966471
SIMPLE Invoices are not getting purged due to below condition: we have pa_addition_flag='N' for the list of invoices which are not getting purged.
-- Retest PA Invoices
/* https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=11722321bug 11722321 incorporating changes of https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=8842960bug 8842960 and 8979828 in R12 start */
UPDATE ap_purge_invoice_list PL
SET PL.double_check_flag = 'N'
WHERE PL.double_check_flag = 'Y'
AND EXISTS (
SELECT 'Invoices are not transfered to PA'
FROM ap_invoices I,
ap_invoice_distributions D